Blog: Google Apps Script Tips & Tutorials

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!

  • 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…

  • Build Your Google Sheets Like React Components (with Apps Script)

    Faster dashboards, cleaner code, and a rendering engine powered by the Sheets API. Google Sheets is fantastic for quick dashboards, tracking tools, and prototypes. And with Apps Script, you can make them dynamic, automated, and even smarter. But the moment you start building something real, a complex layout, a styled dashboard, a multi-section report, the…

  • Google Apps Script Cache Service: What It Is and When You Should Use It

    Even if I’m a real advocate of Apps Script, I’m also very aware of its limits when it comes to performance. When a script keeps fetching the same API data or repeatedly processes large spreadsheets, things slow down fast. Each execution feels heavier than the previous one, and you end up wasting both user time…