A place to expand your knowledge of Google Workspace, learn new Google Sheets formulas and tricks, and automate the boring stuff with Google Apps Script.
More?! Well, I also explore front-end development (JavaScript, HTML, CSS) and dive into other Google Cloud products like Firebase, and all the fancy Google APIs like Maps, Document AI, Chat, Admin Directory and so… so much more.
You can select from the 3 main categories below and see what I have been writing lately. In the sidebar, you can select a category item or use the search bar in the top right.
Want some more structured content? Head over to my courses pages for FREE and quality courses to upskill than grey mush 🧠! Need a handy solution for Google Sheets? Check out my products page or my list of Google Workspace Add ons.
Written by a real live human!
All Posts
Latest Posts
Get Google Sheet Tab Name and ID with Google Sheets API Advanced Service with Apps Script
The Google Sheets API Advanced Service has a strange habit of switching between using Google Sheet names like 'Sheet1' and the sheet ID that you would see in the URL, like 482103711. This can be problematic when working with complex processes in the Sheets API. One of the first things I do when running a … Continue reading "Get Google Sheet Tab Name and ID with Google Sheets API Advanced Service with Apps Script"...
Append – Google Sheets API Advanced Service for Apps Script
In my last written tutorial, I covered how to create a Google Sheets Row Archiver with Google Sheets API Advanced Service and Apps Script and the very last task of this service was to append rows into an archive Google Sheet. The standard approach to appending data in Google Apps Script is to use the … Continue reading "Append – Google Sheets API Advanced Service for Apps Script"...
Creating a Google Sheets Row Archiver with Google Sheets API Advanced Service and Apps Script
I have a client project coming up shortly where I will be diving back into the Google Sheets API Advanced Service in Google Apps Script. As part of my refamiliarisation with the API, I was thinking about the minimum number of API calls it would take to efficiently create a Google Sheets line archiver based … Continue reading "Creating a Google Sheets Row Archiver with Google Sheets API Advanced Service and Apps Script"...
Get a Google Docs Body Text with Apps Script
Retrieving a Google Docs body text is quite easy with the help of Google Apps Script. Well, until it isn’t. Let me explain...
Colory – A small JavaScript Class for HEX to RGB, RGB to HEX conversion and Gradient Color List Building
This is a small JavaScript pseudo-class that I use to quickly convert HEX to RGB colour format and RGB back to HEX and also create an array of gradient colours between two colours. This guide is just a convenient place for me to store this reference for future use. I hope you can get some … Continue reading "Colory – A small JavaScript Class for HEX to RGB, RGB to HEX conversion and Gradient Color List Building"...
Courses
A growing list of free and paid course:
Social
