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
Author: bazroberts
Learn useful Google URL tricks to make your online easier
In this post, we’re going to look at several useful Google URL tricks which allow us to quickly do a whole range of things, like quickly create documents, provide links to copy master templates, and from a link automatically download a PDF version of a document, and many more. We’re going to look at….. Useful… Continue reading Learn useful Google URL tricks to make your online easier
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
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