Best answer

Google Sheet "check quota" Zap Error

  • 12 May 2021
  • 4 replies
  • 728 views

Userlevel 1

One of our zaps gives a Google Sheet error: google sheet "check quota"

How can we increase the Google Sheets quota?

Will signing up for a Google Developer account and increasing the API Quota as mentioned here help?

https://developers.google.com/sheets/api/limits

Or it would not work as we are not adding a direct API link in the zap to that Google Spreadsheet?

icon

Best answer by Troy Tessalone 12 May 2021, 18:27

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +14

Hi @Andrei O. 

GSheets API limits: https://developers.google.com/sheets/api/limits

This version of the Google Sheets API has a limit of 500 requests per 100 seconds per project, and 100 requests per 100 seconds per user.
Limits for reads and writes are tracked separately.
There is no daily usage limit.

 

Also, make sure to check out the available help articles for using GSheets with Zaps: https://zapier.com/apps/google-sheets/help

Userlevel 1

@Troy Tessalone you’re always helpful!

Zapier does not have a direct “API” integration with Google Sheet. Meaning, for a new Zap, we don’t add a Google Spreadsheet endpoint. We just mention the Spreadsheet and the Sheet, and the trigger (for new row, create row, etc).

Right now, it seems we are sending from time to time too many items to the spreadsheet, and Google sends back a notice to Zapier saying “check quota” and our understanding is that the quota for the sheet is exceeded. Most probably these are more that 100 requests in 100 seconds per user.

Is there a way for us to increase Google Quota?

Do we sign up for a Google Sheet for Developers account here?

https://developers.google.com/sheets/api/limits

Is there a way to manage quota for the Sheet we have integrated with Zapier after?

Not sure if you went trough this process before?

Userlevel 7
Badge +14

@Andrei O. 

FYI: Zap apps are all build on app APIs behind the scenes, Zaps just makes it easier to interact with app APIs thru a friendly interface.

 

Q: Is there a way for us to increase Google Quota?

A: No, these are governed by Google via Zapier.

 

Try adding a Delay After Queue step to your Zap to smooth out the number of request b

Delay: https://zapier.com/help/create/customize/add-delays-to-zaps

 

Userlevel 1

@Troy Tessalone this probably saved us a few hours of work. 


Testing right now the Less than 1 min solution!