About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces Zapier Canvas Zapier Chatbots

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

Google Sheet "check quota" Zap Error

  • 12 May 2021
  • 4 replies
  • 753 views
A
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

Troy Tessalone
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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
A
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?

Troy Tessalone
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

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
A
Userlevel 1

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


Testing right now the Less than 1 min solution!

Terms & Conditions