Best answer

Google Sheets error: The app returned "Resource has been exhausted (e.g. check quota)

  • 2 March 2023
  • 5 replies
  • 789 views

Badge

Hey.
I’m testing Transfer on our private integration and google sheets.
In my test data I have  ~700 rows, but after about half of those are transferred, google sheets throws an error. It seems that I’m hitting the api limit. I checked my google sheets api limits and it looks like the limit is 300 calls/minute. Is there a way to get around this limit or add delay after X rows?

 

 

icon

Best answer by Troy Tessalone 3 March 2023, 16:15

View original

5 replies

Userlevel 7
Badge +14

Hi @Mato 

Good question.

You can configure a Zap instead to do the data transfer since Zaps can support Delay steps: https://zapier.com/apps/delay/help

Badge

Hi @Mato 

Good question.

You can configure a Zap instead to do the data transfer since Zaps can support Delay steps: https://zapier.com/apps/delay/help

Hmm, thanks. So I have to create another action that fetches all the data and then use a loop or something similar? I guess I can’t reuse Perform List from the trigger that is used in Transfer? 

Userlevel 7
Badge +14

@Mato 

In Zaps you can use the Looping app: https://zapier.com/apps/looping/help

Looping can only handle a max of 500 records.

Badge

Thanks  @Troy Tessalone .
I know that Transfer is still in beta, but hopefully in the future we will get something similar to what we require.

 

Cheers

 

Userlevel 7
Badge +14

@Mato 

Feedback and features can be submitted via a ticket to Zapier Support to be properly logged: https://zapier.com/app/get-help

Reply