Skip to main content
Answer

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

  • March 2, 2023
  • 5 replies
  • 1066 views

Forum|alt.badge.img

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 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.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • March 2, 2023

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
  • March 3, 2023

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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 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
  • 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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • March 6, 2023

@Mato 

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