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
Tag: Google Apps Script
Lock Google Docs On Shared Drives
Here’s a simple bit of Google Apps Script for locking a document (effectively making the document read-only).
Posted on 28/01/2025
Replace Links With URL In Active Google Sheet
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
Get Last Row in A Column Using Google Apps Script
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
Change Colour Of All Links On Active Google Sheet
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
Get Sheet Name in Google Sheets Function
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
Create a Folder Using Google Spreadsheet
A simple guide on how to create a folder at the press of a button using a Google Spreadsheet.
Posted on 18/01/2024
Updated Sheet to Calendar
An improved version of my code for scheduling Google & Outlook calendar events using a simple list within a Google Sheet as a starting point.
Posted on 11/01/2024
Send WhatsApp Messages From Google Sheets
How to make a google sheet that allowed the sending of WhatsApp messages to a list of recipients in a Google Spreadsheet.
Posted on 11/12/2023
Schedule Google & Outlook Calendar Events Using Google Sheets
Automatically schedule Google & Outlook calendar events using a simple list within a Google Sheet as a starting point.
Posted on 25/09/2023
