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
Darcula Syntax Highlighting for Black Apps Script Chrome Extension
This year, I became a huge fan of the Chrome Extension Black Apps Script from the team at SW Root. Not only does it allow us to have dark mode syntax highlighting for our Google Apps Script code in the IDE, but it also has some other great functionality. My favourites are: Search and, search … Continue reading "Darcula Syntax Highlighting for Black Apps Script Chrome Extension"...
Multiple Google Sheets Async Requests in Google Apps Script
While we can efficiently read and update multiple ranges in Google Sheets with the Google Sheets API Advanced Service in Google Apps Script, there is often occasions where I want to run multiple batch updates on different Google Sheet files. As you have probably discovered, updating multiple sheets consecutively can be time-consuming and frustrating. I … Continue reading "Multiple Google Sheets Async Requests in Google Apps Script"...
Find and Inspect Apps Script-generated HTML in Chrome Dev Tools
HTML generated from Google Apps Script in Web Apps, or Sidebars and Modals in bound scripts can be pretty tricky to debug from Chrome Developer Tools. Typically, the approach is to develop and test your Apps Script HTML code externally in a more suitable text editor either via CLASP ( A command line tool that … Continue reading "Find and Inspect Apps Script-generated HTML in Chrome Dev Tools"...
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"...
Courses
A growing list of free and paid course:
Social
