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
Why is it so Hard to get the Creator of a File in Google Drive Programmatically?
You would think that accessing the name or email of the creator of a Google Drive file would be super easy. In the Google Drive display, there is already a provision for the creation date and the name of the file’s owner, and in the Shared Drive, we can see the creator’s name. It is … Continue reading "Why is it so Hard to get the Creator of a File in Google Drive Programmatically?"...
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"...
Courses
A growing list of free and paid course:
Social
