Skip to main content
Best answer

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


Forum|alt.badge.img
  • Beginner
  • 4 replies

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?

 

 

Best answer by Troy TessaloneBest answer by Troy Tessalone

@Mato 

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

Looping can only handle a max of 500 records.

View original
Did this topic help you find an answer to your question?

5 replies

Troy Tessalone
Forum|alt.badge.img+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


Forum|alt.badge.img
  • Author
  • Beginner
  • 4 replies
  • March 3, 2023
Troy Tessalone wrote:

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? 


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30887 replies
  • Answer
  • March 3, 2023

@Mato 

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

Looping can only handle a max of 500 records.


Forum|alt.badge.img
  • Author
  • Beginner
  • 4 replies
  • March 6, 2023

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

 


Troy Tessalone
Forum|alt.badge.img+14

@Mato 

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