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.
Bonne nouvelle!
My first book about Google Apps Script (in French) will be published next month. It expands on the tutorials from this blog and walks through complete real-world automation projects step by step.
Conditional formatting in Google Sheets is one of the easiest ways to make your data more readable and actionable. Instead of manually styling cells, you can automatically apply formatting based on rules.Want to: Conditional formatting handles all of that.In this guide, you’ll learn the most useful techniques to master conditional formatting in…
If you’re working with Google Apps Script, creating calendar events programmatically is a very common need, especially when building internal tools, workflows, or automation. However, CalendarApp does not support generating Google Meet links. This article shows a simple and practical way to work around that limitation. Enable the Calendar Advanced Service Before…
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…
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…
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…
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…
