topic You have exceeded the Google Sheets API limit of 100 requests per 100 seconds." in Workato Pros Discussion Board

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

kdosko — Tue, 25 Apr 2023 06:54:44 GMT

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 ?

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

vascoeagles — Thu, 04 May 2023 19:44:50 GMT

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)