429: RESOURCE_EXHAUSTED - Resource has been exhausted (e.g. check quota).
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.
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.