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
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"...
Creating Webhooks for Google Chat App with Apps Script
In this tutorial, we follow the adventures of Captain Webhook and his crew in their insatiable desire to report their latest booty conquest to me via Google Chat webhooks… That, dear readers, did not come out right. Webhooks are HTTP POST requests that are usually generated by a triggered event. The event could come from … Continue reading "Creating Webhooks for Google Chat App with Apps Script"...
Get the Difference Between Two Arrays in JavaScript
Sometimes we want to compare the difference between two arrays in JavaScript and return the remaining values in a new array. This can be useful for inventory or purchase management where we could compare the selected items against the available stock, for example. In this tutorial, we will cover two approaches to this: A single … Continue reading "Get the Difference Between Two Arrays in JavaScript"...
How do I reverse a range by Rows or Columns in Google Sheets
Google Sheets: SORT, INDEX, ROWS Sometimes you have a need to reverse a list quickly in Google Sheets. That’s pretty easy to do if the list is sorted alphabetically. Just go on into the <Data> menu and choose from one of the sort functions. But what if the data you want to flip is not … Continue reading "How do I reverse a range by Rows or Columns in Google Sheets"...
Courses
A growing list of free and paid course:
Social
