Chunked import
Instead of processing fifty thousand rows in one run, a time trigger processes five hundred rows per pass using PropertiesService cursor until done.
What are Apps Script quotas in Google Sheets?
Quotas are daily and per-run limits Google places on Apps Script, such as how long a function may run, how many emails you can send, and how many URL fetches you can make. Consumer Gmail and Workspace accounts have different caps. Hitting a quota stops your automation until the reset window, often the next day.
When to use it
Know quotas when you design production automations: nightly reports, form intake at scale, bulk MailApp, or web apps with heavy UrlFetchApp. Plan batching, caching, and error alerts before launch.
When to skip it
Do not obsess over quotas for personal one-click tools that run once a day. Do measure once traffic grows or many users share one script owner account.
How it works
-
1
Each service has limits documented on Google's Apps Script quotas page (execution time, triggers, email, UrlFetch, Properties size).
-
2
Execution time per run is typically six minutes for consumer accounts; long jobs need chunking or multiple scheduled runs.
-
3
Triggers count toward trigger total limits per user per script.
-
4
MailApp and GmailApp share email sending caps tied to the sending account.
-
5
UrlFetchApp counts each HTTP request toward the daily fetch quota.
-
6
Workspace admins may set additional policies; consumer limits differ from business plans.
Examples in Google Sheets
Email digest not per row
A form with hundreds of daily submits batches one summary email instead of one MailApp per row.
Cached API reads
CacheService stores lookup results so a popular web app does not call UrlFetchApp on every page view.
Build this without starting from a blank cell
Use a Better Sheets tool for Apps Script quotas, then watch a walkthrough when you want the full pattern.
Better Sheets resources
Common mistakes
- One giant getDataRange and loop in a single run that exceeds execution time.
- Creating a 1-minute trigger for work that could run hourly, burning trigger and execution budget.
- Sharing one owner account for all customer scripts so one busy sheet exhausts quota for everyone.
- Ignoring quota errors in Executions until users complain emails stopped.
- Assuming Workspace unlimited; limits are higher but not infinite.
Frequently asked questions
- How long can a Google Sheets script run?
- Most consumer scripts max around six minutes per execution. Design longer work as chained or scheduled chunks.
- What happens when I hit a quota?
- The service throws an error and stops. Executions log the failure. Some quotas reset daily.
- Do quotas apply per spreadsheet?
- They apply per Google account and script project context, not per tab. One owner runs many sheets under the same caps.
- How many emails can Apps Script send?
- MailApp daily limits depend on account type. Check Google's current quota table for consumer vs Workspace.
- Can I request higher quotas?
- Workspace admins sometimes have options. Consumer accounts generally cannot raise core Apps Script caps.
- Do simple triggers have different quotas?
- Simple triggers share execution time limits and cannot use services that need authorization anyway.
- How do I monitor quota usage?
- Watch Executions for quota exceptions, add error logging to a sheet, and set trigger failure notifications.
- Does getValues count toward a special quota?
- No separate getValues quota, but huge reads cost execution time and may timeout.
Related Tutorials
Watch how Apps Script quotas works
Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5
Automatic Screenshots in Apps Script
Run 100 ChatGPTs at One Time
Calculate ROAS in Google Sheets
10 Google Sheets I Wish Someone Would Make
Related blog posts
Guides that explain Apps Script quotas in more depth.
What's Better Than Google Sheets?
Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.
Read post →Explore Coding in Google Sheets
Did you know you can actually code in Google Sheets?
Read post →3 Google Sheet Tips for App Developers
App developers, this one is for you. Kick Trello out. Stomp out those new fangled project management apps.
Read post →Related glossary terms
Apps Script triggers
Triggers tell Apps Script when to run a function: on edit, on open, on a schedule, or when a form is submitted. Simple triggers use reserved names like onEdit. Installable triggers are created in the Apps Script Triggers page and can do more, including running as a specific user or on a timer.
Read guide →MailApp
MailApp is an Apps Script service that sends email from your Google account without opening Gmail. You call MailApp.sendEmail with a recipient, subject, and body, often using cell values as the content. It is the fastest way to notify someone when a row is added or a deadline hits in a tracker.
Read guide →Google Sheets automation
Automation means work happens without repeating the same clicks every day: imports update, emails send, rows move, and dashboards refresh. In Sheets, automation usually stacks built-in features, Apps Script, and sometimes the Sheets API or add-ons. Start with the lightest tool that still solves the job.
Read guide →Google Sheets API
The Google Sheets API lets other programs read and update spreadsheets over HTTP using JSON. It is how dashboards, backends, and mobile apps sync data without opening the Google Sheets UI. Apps Script inside a file is simpler for sheet owners; the API fits systems built in Python, Node, or other stacks.
Read guide →Done reading about Apps Script quotas?
Membership unlocks 636+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.