What's With Google Sheets "Resource Exhausted, Check Quota" 429 Runtime Error?

Questions & Answers
1

It looks like this:

image

RuntimeError

429: RESOURCE_EXHAUSTED - Resource has been exhausted (e.g. check quota).

Origin

Google Sheets

I looked in the Sheets help docs, no mention of “quotas” that I could find. My operations are not exhausted by any means, so I’m guessing this is a Google API issue where they limit the number of calls you can make? If that’s the case I’m going to have to seriously rethink my use of Google Sheets as a piece of my data stack. Any help much appreciated.

2

Yes it is, You can check the Gsheet Limit here.

2 Likes
3

I’m hitting that limit with 1 check every 30 mins of a google form spreadsheet. Like Robert, I’m going to have to rethink everything. I didn’t run into this issue with Zapier for the same process.

Seems like maybe Make.com needs to up its API funding with google

4

Thank you for that! Do you happen to know if each row or each cell searched would be a request? I’m assuming it’s rows because I’m getting the error when I search a few hundred rows. It seems there’s some way to request a quota increase from Google, but it quickly gets over my non-technical head with Google Cloud, etc.

1 Like