In this post, we’re going to look at how to create a timeline in Google Sheets, which automatically creates a timeline from a set of data. Short on time? Here’s a quick video to show you how to do it: Action plan A common use of this is to visually see the actions in a… Continue reading How to easily create a timeline in Google Sheets
Category: Posts
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
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 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
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