Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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?

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

@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?

@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

 

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


Testing right now the Less than 1 min solution!

Terms & Conditions