Help for owners
My Google Sheet automation fails with a 429 quota error
Short answer
Google limits the Sheets API to 300 read and 300 write requests per minute per project, and 60 of each per minute per user. Going over returns 429 Too many requests. Google says to wait a minute and retry with exponential backoff, and a batch request counts as one request.
Does this sound like your situation?
- My sheet automation fails with 429, Too many requests.
- A script that loops over rows stops partway.
- It works for a few rows and fails with many.
- Several people use the same tool and it fails more often.
- It recovers by itself after a minute or so.
Why does this happen?
One request per cell or per row
A loop that reads or writes one cell at a time uses a request every time. Google states that each batch request, including its subrequests, counts as one API request, so moving to batch calls cuts the count sharply.
Confirmed by developers.google.com
The per-minute caps are small
Google lists 300 read requests and 300 write requests per minute per project, and 60 of each per minute per user per project. Quotas refill every minute.
Confirmed by developers.google.com
Several users share one login
If every staff member or every job runs through the same account, they share the per-user limit of 60 a minute, and the failure looks random.
Confirmed by developers.google.com
Immediate retries
Google says that after exceeding a quota you should wait one minute before sending requests again, and recommends truncated exponential backoff. A script that retries instantly keeps hitting the limit.
Confirmed by developers.google.com
The sheet is used as a database
A sheet that many users and automations read all day is being used as a small database, and request limits are one of the first signs it has outgrown that.
What can I do about it today?
- Note how many rows and how many usersThe size of the job and the number of people or tools at that moment explain most failures.
- Do not run the job again straight awayWait a minute or two before running it again, as Google advises, so the quota refills.
- Check which account the automation usesFind out whether one shared login runs everything.
- Make a copy of the sheet before experimentsA copy keeps your original data safe while anyone changes the automation.
- Send the error and the sheet name to your developerInclude the time and what the script was doing.
When should I bring someone in?
- Rows or updates are lost when the script stops halfway.
- More people and more rows are coming, and the sheet is becoming the business system.
- You cannot tell which script is making the calls.
How do I handle it?
- Count requests per runI read the script and log how many Sheets calls one run makes, and where they come from.
- Switch to batch reads and writesMany cells are read or written in a single request, so one run uses a few calls, not thousands.
- Add backoff and a safe restartFailed calls are retried with exponential backoff and a random delay, and a run that stops can continue where it left off instead of repeating rows.
- Separate the users and the jobsHeavy jobs run on a schedule, away from busy hours, and not through one shared login.
- Say when a database is the better answerIf the sheet has become the system, I describe what moving the data to a database with the sheet as a view would involve, so you can decide.
The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.
What do owners ask about this?
How long should I wait after a 429?
Google states to wait one minute before sending requests again, and recommends exponential backoff for automatic retries.
Can I raise the Sheets limit?
The limits page states the numbers and the refill every minute. Cutting the number of requests, with batching, is the reliable route.
Does a batch count as many requests?
No. Google states that each batch request, including its subrequests, counts as one API request.
Sources
How was this page made?
I drafted this page with AI assistance from the official documents listed under Sources. Found a mistake? Tell me.