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
Google Workspace Tutorials
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
Style your Google Site with themes
When the new version of Google Sites first came out you had very limited options to style it but that’s all changed and now you can use themes to not only style the way you want it but to save and share those styles between sites. In this post, I’m going to show you all… Continue reading Style your Google Site with themes
Using Google Meet directly from Sheets Docs & Slides
In this post, we’re going to look at how we can quickly access Google Meet directly from Google Sheets, Docs, and Slides. From April 2022, Google added the ability to open a Meet directly from a Sheet, etc and where the Meet will then appear in the sidebar, allowing you to collaborate on the document… Continue reading Using Google Meet directly from Sheets Docs & Slides
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
How to use the Google Calendar Appointment System
Google recently improved their appointment system on Google Calendar, which allows people to book appointments directly on your calendar. It’s a great, simple system that may negate the need for 3rd party appointment solutions. However, as you’ll see below it does have one flaw, which means we can’t use it for all our situations. Creating… Continue reading How to use the Google Calendar Appointment System
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