Welcome! Just sharing some stuff I build with Apps Script, tips, tutorials, and whatever else I find useful
Google Apps Script Tips & Tutorials, Simple, Practical, Powerful
I share step-by-step guides, code snippets, and real-world automations built with Google Apps Script™. Sometimes I also cover other Google Workspace products, GCP tutorials and productivity hacks.
For my French-speaking fellows :
Want to get started with Apps Script? Watch my introduction video where I show you how to build your first automation from scratch.
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…
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…
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…
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…
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…
I love BigQuery. It’s the beast that handles the data Google Sheets chokes on. But let’s be honest: connecting it to Apps Script can sometimes feel like trying to open a locked door while holding a handful of different keys. Usually, you just turn on the “BigQuery Advanced Service,” run a query,…
