It looks like this:
429: RESOURCE_EXHAUSTED - Resource has been exhausted (e.g. check quota).
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.
Yes it is, You can check the Gsheet Limit here.
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
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.