What Breaks When Apps Script Projects Sprawl
What breaks when Apps Script projects multiply and ownership, triggers, permissions, and versions become scattered.
All tags Tags
#Apps Script
26 posts
Make.com Subscription vs Free Apps Script: Which Is Actually Cheaper?
The real cost tradeoff between Make.com subscriptions and Apps Script ownership across speed, exceptions, and maintenance.
Why Vibe-Coded Apps Script Turns Into Trash After Three Months
Why quickly vibe-coded Apps Script projects become maintenance problems after the first successful demo.
Why a Daily Apps Script Trigger Suddenly Stops
The common reasons a daily Apps Script trigger suddenly stops, and what operators should check first.
Why Google Forms Data Turns Messy in Days
Why Google Forms responses get messy in days, and what to normalize immediately after collection.
Where Free Google Apps Script Automation Starts Leaking Money
Where free Apps Script automation turns into real operating cost: triggers, external APIs, maintenance, and ownership.
When the Browser Throws Your Data Away: The Green Checkmark Lies
Mobile localStorage drops data silently when it fills up — but the 'saved' flag stays, so a Done check shows with no data. Which store to use for what, keeping large bodies in IndexedDB, an integrity check on open, and cutting eviction with storage.persist().
Installed ≠ Working: the Backup Trigger Never Ran Once
In GAS, scopes, triggers, and permissions fail silently. Miss one manifest scope and the trigger never runs. Why it fails silently, installing idempotently to dodge the 20-trigger cap, a heartbeat, and proving it ran right after install.
GAS Has No Gradual Rollout: One 'Correct' Check Locks Out Every User
Apps Script goes to 100% of users the instant you promote — there's no canary. The difference between push and deploy, shipping new checks on a compat → warn → enforce ladder, telemetry that counts old clients, and the rollback command when it goes wrong.
Sheets Turns Your Text Into a Date: When '2026-06' Blocks Completion Forever
Google Sheets silently coerces strings like '2026-06' into a Date. When save, read, and compare each compute the month differently, completion is rejected forever. What gets coerced, how to pin cells to text and guard on read, plus batch writes and formula injection.
I Vibe-Coded a Real GAS App — the Demo Was Fine, and the Field Broke Everything
AI built me a field-inspection app on GAS. The demo ran fine. Then one deploy button locked out every field worker, Sheets swapped my text for a date, and a green checkmark lied. The tiny bugs I fixed all day — and what to watch for before you vibe-code on GAS.
Automating Your Work with Google Apps Script — The Complete Guide
How to automate repetitive work — orders, bookings, inventory, settlement, field input — with Google Apps Script (GAS). What it does, how far it stays free, and where it hits limits, in one place.
An App Where Many Write to One Sheet: Concurrency, Duplicates, and Export Design
The places I actually got stuck building the CheckReport Demo, with the code. Concurrent saves to a shared sheet are blocked with ScriptLock + an idempotency key, cells hold only metadata, and exports are cut off with a time budget. Good code and bad code, side by side.
How a Multi-User Inspection App Is Different
A single-user app just needs a screen. An inspection app where several people write the same data hinges on sharing, collisions, and reports. Even so, narrow the scope and you can start with GAS, Sheets, and Drive at no running cost. There's a public demo you can try yourself.
Don't Read Cells One at a Time: Service Calls Are the Real Cost
In GAS the slow part isn't JavaScript, it's service calls to Sheets and Drive. Swap in-loop getValue/setValue for batched getValues/setValues and it's tens of times faster.
Stuffing JSON or Images into a Sheet Cell Will Break It
A Google Sheets cell caps at 50,000 characters. Put a photo or signature in a record row as a data URL and the save breaks. Keep only metadata in the cell.
One Deploy Setting Decides Your Security Model: Execute as / Access
The 'execute as' × 'who can access' combination sets data permissions and whether your code is exposed. Public apps need their own app-level auth.
The 6-Minute GAS Limit: Chunk and Resume Before It Kills You
Apps Script kills any single run at 6 minutes. Design bulk jobs as chunk + cursor + time-trigger resume, or you get the half-processed-data accident.
PropertiesService Is Not a Database: the 9KB Wall
A Properties value caps near 9KB. Cache only data you can lose. Big state goes to Sheet, Drive, or an external DB. Plain JSON loses types.
Why Saving a Screen as an Image Freezes on Mobile
Capturing the DOM via SVG foreignObject freezes or returns a blank image on mobile Safari and the GAS iframe. Draw to canvas directly, and download via Web Share.
Concurrent Writes to the Same Sheet Break: LockService and the 30-Run Ceiling
When users and triggers write the same asset, numbers collide and rows get overwritten. Guard with tryLock + finally + flush, and design for the 30-per-user concurrency ceiling.
Your /exec URL Must Not Change on Every Redeploy
Reuse the deployment ID when you push a new version with clasp and the /exec URL stays fixed. Guard shared sheet writes with LockService.
External Calls Fail Sometimes: Exponential Backoff and a Retry Budget
Transient failures like 429, 503, and timeouts can be recovered by retrying. But never retry a non-idempotent write without an idempotency key, and stop before 6 minutes.
HtmlService Apps: Shell First, Then Async Load and Mobile Back
Loading data in the template delays first paint. Draw the shell first and load via google.script.run, but attach a failure handler to every call.
When to Graduate from GAS: Limit Signals and Moving to an External DB
GAS is strong at short automation and weak at long-running, high-volume, high-concurrency work. Quotas are shared per account. Know the signals and plan the move.
Adding a Brain and an Engine Room to GAS: Vertex AI and Cloud Run
Add classification, summary, and drafts by calling Vertex AI (Gemini) straight from GAS. Hand heavy work that exceeds 6 minutes to Cloud Run. A human-approval gate stays mandatory.