A bit of Google Apps Script that automates the process of generating personalized documents based on document templates using data stored in a spreadsheet.
Fill Google Doc Template Using Sheet Apps Script
Posted on 06/05/2025
Everything from embedding Custom Google Searches to tip’s and tricks for using Google Search Console.
Or just changing the password to something you registered for using a Google account.
A bit of Google Apps Script that automates the process of generating personalized documents based on document templates using data stored in a spreadsheet.
Posted on 06/05/2025
This is a simple bit of Google Sheets formula used to add a row of incremental number is row A where row B is not blank.
Posted on 25/02/2025
Here’s a simple bit of Google Apps Script for locking a document (effectively making the document read-only).
Posted on 28/01/2025
A simple bit of Google Apps Script that converts all links within an active Google Sheet into full URL links instead.
Posted on 28/01/2025
Another simple bit of code that’s worth writing down: how to get the last row in a specific column using Google Apps Script.
Posted on 08/12/2024
A simple bit of code that’s worth writing down for counting all cells in a column that contain a specific word/symbol.
Posted on 08/12/2024
A simple Google Apps Script that I came up with to change the colour of every link within the current active sheet all at once.
Posted on 29/07/2024
A simple explanation of Google Analytics’ new EU consent rules and how to satisfy them with a simple script.
Posted on 03/04/2024
In this guide, I’ll walk you through the simple steps to set up conditional formatting to identify functions in Google Sheets.
Posted on 02/04/2024
A simple bit of Google Apps Script for a Google Sheet to add a function which returns the name of whatever sheet it’s placed within.
Posted on 02/04/2024