ServicesProductsDocsBlogConsultingAboutContactBook a free call

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

  1. Click Make a copy. The sheet is saved to your own Google Drive.
  2. 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).
  3. 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.
  4. Pick your account type in B13: Gmail or Workspace. The limits change with it.
  5. 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

apps-script-quota-calculator-formulas.txt
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.

We value your privacy

We use essential cookies to make our site work. With your consent, we may also use non-essential cookies to improve user experience and analyze website traffic. By clicking "Accept", you agree to our website's cookie use as described in our Cookie Policy.