As the Google Sheets API is a shared service, we apply quotas and limitations to make sure it's used fairly by all users and to protect the overall health of the Google Workspace system.
Quota limits
While Sheets API has no hard size limits for an API request, users might experience limits from different processing components not controlled by Sheets. To speed up requests, Google recommends a 2-MB maximum payload.
Sheets API has per-minute quotas, and they're refilled every minute. For example, there's a read request limit of 300 per minute per project. If your app sends 350 requests in one minute, the additional 50 requests exceed the quota and generates a 429: Too many requests HTTP status code response. If this happens, you should use an exponential backoff algorithm. After 1 minute, you can execute requests again. Users can submit multiple requests at the same time, as long as they're within the quota limit.
All Sheets requests are applied atomically. That is, if any request is not valid then the entire update is unsuccessful and none of the (potentially dependent) changes are applied.
The following table details the request limits. Provided that you stay within the per-minute quotas, there's no limit to the number of requests that you can make per day.
| Quotas |
| Read requests | | Per minute per project | 300 | | Per minute per user per project | 60 | |
| Write requests | | Per minute per project | 300 | | Per minute per user per project | 60 | |
For details about file limits, go to Files you can store in Google Drive.
Resolve time-based quota errors
For all time-based errors (maximum of N requests per X minutes), we recommend your code catches the exception and, using an exponential backoff algorithm, implement a small delay before trying again. If requests are still unsuccessful, it's important the delays between requests increase over time until the request is successful. Generally, you should use a truncated exponential backoff. To learn how to use exponential backoff, go to Retry strategy.
Pricing
All use of the Google Sheets API is available at no additional cost. Exceeding the quota request limits doesn't incur extra charges and your account is not billed.
Request a quota increase
Depending on your project's resource usage, you might want to request a quota increase. API calls by a service account are considered to be using a single account, so you might need a higher per-user, per-project quota in that scenario. Applying for an increased quota doesn't guarantee approval. Large quota increases can take longer to be approved.
Not all projects have the same quotas. As you increasingly use Google Cloud overtime, your quotas might need to increase. If you expect a notable upcomingincrease in usage, you can proactivelyrequest quota adjustmentsfrom the Quotas pagein the Google Cloud console.
To learn more, see the following resources:
FAQs
Quota limits
What is the API limit for Google developer? ›
The Google Play Developer API has a default limit of 200,000 queries per day. You can view your quota in the Quotas section of the Google Cloud Console.
What are the limitations of Google Sheets? ›
Google Spreadsheets are extremely powerful and convert very well from Excel, but they do have some limitations: Up to 10 million cells for spreadsheets that are created in or converted to Google Sheets. 40,000 new rows at a time. Maximum number of columns of 18,278 columns.
What is the API key limit for Google Sheets? ›
For Google Sheets, the limit is 500 requests per 100 seconds per project, and 100 requests per 100 seconds per user. There is no daily usage limit. You can get your own free Google Sheets API key by following the steps below.
How do I increase quota limits in Google Sheets? ›
In the Google Cloud console, go to the Quotas page. For Service, select Filestore API. Select the checkbox next to the Filestore quota you want to increase. On the top of the page, click Edit Quotas.
Is Google Developer API free? ›
All use of Google Search Console API is free of charge. However, it is subject to usage limits. Was this helpful?
What is Google Admin API rate limit? ›
The API limits the number of requests for your Google Cloud project. The default value set in the Google Cloud console is 2,400 queries per minute per user per Google Cloud project. You can increase this limit from the Admin SDK API Quotas page of your Google Cloud project.
Can Google Sheets handle 100000 rows? ›
Based on the number of cells available in the sheet, you can add as many rows (at one time) as will not surpass 10,000,000 cells. So you can add 200,000 rows all at the same time if you have enough cells remaining in the file. For the columns, 18,278 is column ZZZ, and you can not add any more columns.
What are the limitations of Google Sheets vs Excel? ›
In Google Sheets, you can have a maximum of 5,000,000 cells or 18,278 columns in a worksheet. If you already have 5 million cells, you can't add more columns even if the number of your columns is under 18,278. What about Microsoft Excel? It's 1,048,576 rows by 16,384 columns, or 17,179,869,184 cells in total.
What are 2 pros and cons of Google Sheets? ›
The advantages and disadvantages of using Google Sheets for your eCommerce business come down to four main factors. Pros: They're free (with a Microsoft Office or Google Workspace implementation), and they don't require training. Cons: They're limited in scalability and functionality.
Using the Google Sheets API is free, but there are usage limits for each user. There are quotas for queries as well as quotas for document creation.
What is the limit of Zapier Google Sheets? ›
Just because Google Sheets can have 10 million cells, does not mean your sheet should have 10 million cells. When Zapier sends a request to Google Sheets, whether it's to create a new row, or see if there are any changes that need to be triggered on, it waits around 30 seconds for a response.
Can I use API in Google Sheets? ›
The Google Sheets API is a RESTful interface that lets you read and modify a spreadsheet's data. The most common uses of this API include the following tasks: Create spreadsheets. Read and write spreadsheet cell values.
How do I make limited options in Google Sheets? ›
Restricting Values
- Open up your Google Sheet and select the cells where you want to restrict values.
- Click on the Data tab.
- Click on Data validation.
- In the "Criteria" section, select "List from a range"
- In the "Range" field, enter the range of cells that contains the values you want to restrict.
- Step 1: Open a new Sheet.
- Step 2: Open Apps Script Editor.
- Step 3: Name the Project.
- Step 4: Add API example code.
- Step 5: Run the Function.
- Step 6: Authorize your Script.
- Step 7: View the Logs.
Maximum of five
The Google Places API will only return five reviews for a given place ID. However, for many, five is sufficient alongside a link off to Google's listing of all the business' reviews.
What is the Gmail API limit per day? ›
Yes, the Gmail API has a daily quota limit for sending emails. According to the Gmail API documentation, the daily sending quota is 1,000 messages per day for free Gmail accounts and 10,000 messages per day for paid G Suite accounts.
How do I check my Google API limit? ›
Option 1: API-specific quota
- Go to Google Cloud and sign in as a Google Workspace super administrator.
- Under Project, select the project you're using for the migration.
- On the left, click APIs & Services. Dashboard.
- Scroll to the bottom and click the API you want to monitor. The Overview tab shows details of the API.
