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!
-
Workaround for Apps Script UrlFetchApp “Bandwidth quota exceeded” errors using Cloud Run
We are currently experiencing intermittent UrlFetchApp errors in Apps Script: Exception: Bandwidth quota exceeded: <url>. Try reducing the rate of data transfer. This started suddenly around April 2026 and matches the public issue reported here: https://issuetracker.google.com/issues/505172128 The problem is that the error happens even with low usage, small payloads, and previously stable scripts. In our case, this…
-
Apps Script Logging Best Practices: console, Logger, Cloud Logging, and a Production-Ready Logging System
Logging in Google Apps Script is easy when you are testing a small script in the editor. It becomes much more important when the project turns into a real web app used by other people. At that stage, logs are no longer just for debugging. They help you understand what happened, where a request failed,…
-
Conditional Formatting in Google Sheets (Simple Guide)
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 Google Sheets. How…
-
Create a Google Calendar event with a Meet link (Apps Script)
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 writing any code,…
-
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…