Limits & Quotas for Google Apps Script (GAS)

Limits & Quotas

Google Apps Script (GAS) has certain limits & quotas. They apply to custom software or workflows created using Google Apps Script (GAS).

A short list of certain (but not all) Google Sheet limits follows:

40,000 new rows at a time
Number of Tabs: 200 sheets per workbook
GoogleFinance formulas: 1,000 GoogleFinance formulas
Maximum string length is 50,000 characters (see note below)
Maximum number of columns of 18,278 columns(column ZZZ)
ImportRange formulas: 50 cross-workbook reference formulas
Up to 10 million cells for spreadsheets that are created in or converted to Google Sheets
ImportData, ImportHtml, ImportFeed, or ImportXml formulas: 50 functions for external data
Note: When you convert a document from Excel to Google Sheets, any cell with more than 50,000 characters will be removed in Sheets

Another short list of certain (but not all) Google Apps Script (GAS) quotas follows:

Feature	Regular / Legacy Edition	Workspace accounts
Calendar events created	5,000 / day	10,000 / day
Code or Script runtime	6 min / execution	6 min / execution
Contacts created	1,000 / day	2,000 / day
Custom function runtime	30 sec / execution	30 sec / execution
Documents created	250 / day	1,500 / day
Email recipients per day	100* / day	1,500* / day
Email read/write (excluding send)	20,000 / day	50,000 / day
Files converted	2,000 / day	4,000 / day
Simultaneous executions	30 / user	30 / user
Spreadsheets created	250 / day	3,200 / day
Triggers	20 / user / script	20 / user / script
Triggers total runtime	90 min / day	6 hr / day
URL Fetch calls	20,000 / day	100,000 / day
URL Fetch response size	50 MB / call	50 MB / call
URL Fetch headers	100 / call	100 / call
URL Fetch header size	8 KB / call	8 KB / call
URL Fetch POST size	50 MB / call	50 MB / call
URL Fetch URL length	2 KB / call	2 KB / call
Apps Script Projects	50 / day	50 / day