In this final post on the 2023 improvements to Google Workspace in 2023, let’s look at the AI and coding side of things. Duet AI Google weren’t content with just bringing out Bard to compete in the AI ‘arms race’ last year, they also brought out Duet AI. This uses AI right across Google Cloud.… Continue reading Summary of Google Workspace 2023 improvements (Part 3)
Category: Apps Script
How to combine arrays of data into 1 sheet
In this post, we’re going to look at how we can easily combine arrays of data on separate sheets in a Google Sheet and add them on one single sheet. We’re going to use the relatively new spread operator (…) to do this. Situation In this example, we have a set of data on 3… Continue reading How to combine arrays of data into 1 sheet
Learn how to make a World Cup game using Apps Script
It’s almost World Cup time and I thought what better way to get into it than to create a little World Cup game amongst friends and colleagues using Google Sheets, Sites, and Apps Script. This year I decided to create a game where the participants guess how many goals will be scored in each stage… Continue reading Learn how to make a World Cup game using Apps Script
How to split Google Slides automatically
In this post, we’re going to see how to split Google Slides automatically into separate files with Apps Script. Problem and solution The reason I wrote this script was to resolve a problem at work, where we have an admin system that produces a document with the certificates for the students that are going to… Continue reading How to split Google Slides automatically
How to make an automatic team maker app using Apps Script
In this post, we’re going to look at a script to be able to make an automatic team maker which makes even teams from a selection of players. I play football every Sunday and every week my friends sign up to play and most weeks there are different players playing, so we end up having… Continue reading How to make an automatic team maker app using Apps Script
JavaScript – Template Literals
In this post, we’re going to look at template literals. What can you do with them? Uses of template literals Mixing single and double quotes First of all, these live in between back-ticks (`) instead of single or double quotes. e.g. This then means we don’t have to worry about what type of quotes we’re… Continue reading JavaScript – Template Literals
Automatically format rows for Google Form responses
Here, we’re going to see how we can automatically format rows on a Google Sheet when a Google Form response is submitted. When the form responses come in normally, they have the default format below. But I want them to be formatted as below. So, changing the cell backgrounds to red, only showing the day… Continue reading Automatically format rows for Google Form responses
Quickly format multiple Google Sheets with Apps Script
In this post, we’re going to see how we can very quickly format multiple Google Sheets with a little help from Apps Script. The idea of this post, came from the Department of Education in Hawaii, where they have about 300 schools and a guy who works there told me he had to format about… Continue reading Quickly format multiple Google Sheets with Apps Script
Importing Amazon royalty data from Excel to Google Sheet
In this post we’re going to look at how we can get data from an Excel spreadsheet and import some of it into a Google Sheet. As an example, we’re going to upload an Excel which contains the current month’s royalty data from Amazon and add it to a central sheet which contains all the… Continue reading Importing Amazon royalty data from Excel to Google Sheet
Calculate hours worked from Google Calendar
In this post, we’re going to see how we can use Google Calendar to record the number of hours we’re working to make sure not overworking! On my Google Calendar I add events to show the periods I’m working (in this case on admin). A script will then get these events and list all of… Continue reading Calculate hours worked from Google Calendar