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
Add Custom Queryable Properties to Any File in Google Drive with Apps Script
I recently needed a way to easily search for files in Google Drive related to specific projects, the file template version, and whether it was an archived file or a live file with Google Apps Script. In most cases, I needed to reference a bunch of Google Sheets built upon a template Google Sheet that … Continue reading "Add Custom Queryable Properties to Any File in Google Drive with Apps Script"...
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...
Courses
A growing list of free and paid course:
Social
