Welcome to my blog!
Here I share practical guides, code snippets, and real-world automation ideas built with Google Apps Script™.
You’ll also find occasional articles about other Google Workspace tools, productivity hacks, and creative workflows.
Dive in below to explore my latest posts!
-
onEdit vs onChange in Google Sheets (Apps Script)
When automating Google Sheets with Apps Script, two triggers are often confused: onEdit and onChange. They behave differently, and this short guide summarizes what actually triggers each one. What triggers each event Action in the spreadsheet onEdit onChange Edit a cell value ✔️ ✔️ Insert a row or column ❌ ✔️ Delete a row or…
-
Handle Multiple Google Form Submissions in One Spreadsheet with a Single Apps Script Trigger
When working with Google Forms + Google Sheets, a common setup is to connect several forms to the same spreadsheet. Each form creates its own response sheet automatically. This works well at first. But as soon as you want to automate workflows with Google Apps Script, things become messy. Typical situations: The issue is that…
-
Clasp: managing dev and prod environments
If you code in Google Apps Script using clasp, you already use clasp pull and clasp push. But as soon as you work with multiple environments (dev and prod), manually changing the scriptId in .clasp.json becomes annoying, and risky. Here’s a simple and clean way to manage dev and prod environments with clasp. Create one…
-
OAuth with Google Apps Script
One of the biggest strengths of Google Apps Script is how easily it interacts with other Google products. Reading a Google Sheet, creating a Drive file, or updating a document requires almost no setup. You don’t have to think about authentication, token management, or security flows. Google automatically prompts the required scopes and takes care…
-
Automatically import Xero bills into Google Sheets (Google Apps Script + OAuth2)
If you use Xero and Google Sheets on a daily basis, this automation tutorial is for you. In this post, you’ll learn how to automatically sync your Xero bills into a Google Sheet on a schedule, so your spending table stays up to date without copy-pasting. We’ll build it in a production-friendly way: OAuth2 authorization…
-
10 Practical Google Sheets Tips
Here are 10 Google Sheets tips I use in my day-to-day.You might recognise a few of them, but I’m pretty confident you’ll still learn something new! Highlight an entire row based on a single cell One of the most common questions:“I want the whole row to change color when the status is ‘Done’ / the…