Outgrown Google Sheets? Count the Slow Formulas Before You DecideOne Apps Script function counts NOW(), A:A ranges and IMPORTRANGE in every tab and writes a Sheet health report. Testing it also found three inputs our locked recordSale() let through.12 min read·magesheet-team.hashnode.dev2d ago
Build vs Buy in Google Sheets: The Break-Even Cell That Said -400 MonthsB / (S - R - M) is the right formula. In a sheet it returns -400 when upkeep eats the saving, and it holds the subscription flat for three years. Three custom functions fix both.11 min read·magesheet-team.hashnode.dev2A4d ago
Apps Script Error Handling: The Failed Invoice Your Ledger Skips ForeverRun against fakes, the guide's retry ledger skipped a send that threw on every later run: 0 invoices sent, heartbeat ok. A failed state, a retry limit and a watchdog with memory fix it.12 min read·magesheet-team.hashnode.devNov 1
Google Workspace Offboarding: A Dry Run That Survives a Failed StepRun against a fake Admin SDK, the plan-then-apply offboarding script could not finish after one transient error, wiped a phone twice, and ignored a row the reviewer deleted. Moving the plan into the sheet fixes all three.13 min read·magesheet-team.hashnode.devOct 28
WhatsApp Response Time in Google Sheets: The Webhook Can't Tell Your Bot From Your AgentRun on fake events, the usual webhook-to-Sheets code logs a 2-second bot acknowledgement and a 10-minute agent reply as identical rows. Tag every outgoing message, and count business minutes.14 min read·magesheet-team.hashnode.devOct 26