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.
All tags Tags
#Pitfall
4 posts
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.
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.
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.