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.
All Posts
Latest Posts
Google Sheets FILTER function: Dates and Times
If you have landed on this page you may have discovered that dates and times don’t always work as you might expect with the Google Sheets FILTER function. In this tutorial, we are going to cover how to use FILTER on dates, times and date and time stamps (DTS). You can follow through the tutorial … Continue reading "Google Sheets FILTER function: Dates and Times"...
Preventing Cross-Site Request Forgery (CSRF) in Google Apps Script Dialogs and Sidebars
Cross-Site Request Forgery (CSRF) is a web security vulnerability that allows a nefarious entity to take actions on a website that are unintended by the user. Typically, this is done by tricking the user into using another website resembling the intended site and then submitting a form or clicking a button. The dodgy site then … Continue reading "Preventing Cross-Site Request Forgery (CSRF) in Google Apps Script Dialogs and Sidebars"...
Adding Charts to Google Workspace Add-on Sidebar Apps with Apps Script
Creating dynamic charts in the sidebar of your Google Workspace Add-on can be an effective approach to getting across a lot of meaning in a somewhat confined space. In this tutorial, we will use Google’s Chart API to generate a live chart, first from some static data and then live from an external data source … Continue reading "Adding Charts to Google Workspace Add-on Sidebar Apps with Apps Script"...
Add the Editor’s Email when they Tick the Check Box in Google Sheets with Apps Script
This tutorial is for Google Workspace Domain accounts. Recently, I was a guest interviewee at a Google Workspace Developer Summit in Singapore and an attendee asked me how they could automatically add the editor’s email to an adjacent cell when the user checks a check box in Google Sheets. This can be incredibly handy for … Continue reading "Add the Editor’s Email when they Tick the Check Box in Google Sheets with Apps Script"...
Courses
A growing list of free and paid course: