Home/Guides
Google Sheets and Apps Script guides
Write-ups of problems I run into often, with code you can paste into your own sheet.
- How to send emails from Google Sheets automaticallySend emails from Google Sheets automatically with Apps Script: a working script that emails each row once, marks it sent, runs on a trigger and respects quotas.7 min read
- Apps Script limits and how to fix "Exceeded maximum execution time"Google Apps Script limits explained: the 6-minute run cap, trigger runtime, custom function and URL Fetch quotas, and how to fix Exceeded maximum execution time.8 min read
- Why is my Google Sheet so slow, and how do I speed it up?Make a slow Google Sheet faster: replace volatile functions and copied-down formulas, fix whole-column references, IMPORTRANGE chains and cell-by-cell scripts.7 min read
Tell me what your sheet needs to do
A few sentences is enough to start. I'll reply with questions, then a plan and a fixed quote.