429: RESOURCE_EXHAUSTED - Resource has been exhausted (e.g. check quota).
From my research it appears I hit a Google Sheets API limit. Does anyone know how to “check quota” and would it help if I upgraded my Google plan? Would a better Google plan give me a larger “quota”? (Currently on starter plan)
I haven’t seen that. I might be paying more money for things to make sure the system always works (such as 800K transactions a month on Integromat kind of thing).
A quick search and it does look like it’s a Google api quota you are hitting. If you are using your own api key (and not accidentally using someone else’s) them it’s best to go to Google Console and poke about to find out what limit you’ve hit… and what you pay to keep things working.
I think from memory this message relates to a rate limit rather than an absolute limit i.e. too many API calls per sec / min. Can you reduce your rate in any way?
Google Workspace Account:
Business Starter 100/100 sec for both read and write
Business Standard 500/100 sec for both read and write
Business Plus 1000/100 sec for both read and write