You have exceeded the Google Sheets API limit of 100 requests per 100 seconds."

[kdosko]

I have a gsheet I am using a recipe to check data in each row and update but it is failing and I am getting this  message "You have exceeded the Google Sheets API limit of 100 requests per 100 seconds."  Is there a way to slow down the number of requests being sent ?

[vascoeagles · Accepted solution]

I had a similar issue with OpenAir which doesn't allow batch processing.  I'm not sure if this is best practice but the way i handled was:

- Created a variable called API Counter and set to 1

- After each API call, updated the variable by adding 1

- Added an IF statement that IF  API Counter % 0  equals 0 Then Wait for 60 seconds (Scheduler Action)