Free resource
Apps Script Quota Calculator: Free Google Sheets Template
A free Google Sheets calculator that checks your Apps Script triggers against Google's daily quotas: trigger run time, email recipients and URL Fetch calls, for a free Gmail or a Google Workspace account. Make a copy and it lives in your own Google Drive.
Make a copyOpens Google with your own copy. Nothing is shared with us.
Set it up
- Click Make a copy. The sheet is saved to your own Google Drive.
- Replace the example rows with your own time-driven scripts: one row each, with how often the trigger runs in minutes (60 = hourly, 1440 = daily).
- Enter the average seconds per run from the Executions page of your Apps Script project, plus email recipients per day and URL Fetch calls per run.
- Pick your account type in B13: Gmail or Workspace. The limits change with it.
- Read the Status column. OVER means the quota runs out before the day ends; Close means you are past 80%. Run the least urgent scripts less often first.
The formulas
Calculator tab: one row per time-driven script in rows 2-11.
A script name, B trigger interval in minutes (60 = hourly, 1440 = daily), C average seconds per run (from the Executions page),
D email recipients per day, E URL Fetch calls per run.
Runs per day (F2, fill down):
=IF(B2>0,1440/B2,"")
Trigger minutes per day (G2, fill down):
=IF(B2>0,F2*C2/60,"")
URL calls per day (H2, fill down):
=IF(B2>0,F2*E2,"")
Account type in B13: Gmail or Workspace (dropdown).
Used (B15, B16, B17):
=SUM(G2:G11)
=SUM(D2:D11)
=SUM(H2:H11)
Limit (C15, C16, C17), from Google's Apps Script quotas page, checked 15 Nov 2026:
=IF(B13="Workspace",360,90)
=IF(B13="Workspace",1500,100)
=IF(B13="Workspace",100000,20000)
% used (D15, fill down to D17):
=IF(C15>0,B15/C15,0)
Status (E15, fill down to E17):
=IF(D15>1,"OVER",IF(D15>0.8,"Close","OK"))
Quota lasts, in hours (B18):
=IF(B15>C15,C15/B15*24,24)
Sheets set to a language that uses a comma as the decimal mark (Turkish, German, ...):
use semicolons between arguments, e.g. =IF(B2>0;1440/B2;"")
Common mistakes
- The formula shows a parse error.
- Your Sheets uses a comma as the decimal mark (for example Turkish or German settings). Use semicolons between arguments: =IF(B2>0;1440/B2;"").
- The sheet says OK, but your triggers still stopped.
- Quotas are per user, not per script. Add every time-driven script that runs under the same Google account, including ones in other projects.
- Email recipients look too low.
- The quota counts recipients, not messages. An email to 9 people uses 9. Count every address in To, Cc and Bcc.