Free tool · No signup
Apps Script 6-minute timeout estimator
Google Apps Script kills any execution at exactly 360 seconds. Tell us what your script is doing and we'll tell you whether it's going to die in production — and how to fix it before it does.
Estimated wall-clock time
40s
out of 6m 0s (+89% margin)
How we got here
- JDBC database (MySQL / Postgres / SQL Server): 4s overhead + ~6s per 1,000 rows
- Reading ~6,000 rows → 36s read time
Apps Script's Jdbc service is the fastest path — single connection, batched reads. The risk is connection latency from Apps Script's data center to your DB (often 200-500ms) and the network round-trip on each ResultSet page.
What to do about it
- You have plenty of headroom. Add basic error handling (try/catch around the main loop) and a Logger.log of elapsed time to monitor for regression as your data grows.
How accurate is this estimator? Conservative. The numbers come from Google's published Apps Script benchmarks, public JDBC driver performance data, and our own measurements running production sync jobs at Brooked. We round up because telling you "will time out" and being wrong (it actually finishes in 5m 50s) is fine. Telling you "safe" and being wrong (it dies at 5m 59s with no progress saved) loses your afternoon.
Why doesn't Apps Script just raise the limit? Google Workspace runtime quotas are shared across every script execution in the workspace. Raising it for individual users would let one team starve everyone else's triggers. The 6-minute cap has been the same since 2014; Google has signalled no plans to change it. Workspace Business plus accounts get 30 min on standard runtime but not on triggered runs.
What about Apps Script V8? V8 made JavaScript execution faster but didn't change the wall-clock cap. Most timeouts are network I/O bound (waiting for API responses, JDBC round-trips), not CPU. Switching runtime won't fix a timeout caused by 200 serial HTTP requests.
Get your spreadsheet hours back
Brooked installs in seconds. Your team is querying live data before lunch.
Install for Google Sheets