Skip to main content
Best answer

Google Sheets error "Trigger Partner Failure"


Forum|alt.badge.img+3

Google Sheets: Trigger partner failure: The app returned "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute' of service 'sheets.googleapis.com' for consumer 'project_number:927538837578'.".

 

Any thoughts what this is about?  

 

The ZAP involves looking up a row in another spreadsheet 

 

gml

Best answer by blueguyBest answer by blueguy

I just got this from Zapier:

 

I’m reaching out because you may have received the following error from the Google Sheets integration: "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute' of service 'sheets.googleapis.com' for consumer 'project_number:927538837578'." I wanted to let you know we recently got these quota limits increased for the Google Sheets integration which should resolve these error with no action needed from your end. If you continue to see this specific error, please don't hesitate to reach out. Have a great one!

 

Thank you Zapier!!

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

40 replies

christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • 2653 replies
  • March 15, 2022

Thanks for looping back around to update the thread, @blueguy! You beat us to it. 😜

For anyone else following along, if you continue to receive errors, definitely reach out to support team and they can do a bit more digging for ya. 


Forum|alt.badge.img+3
  • Author
  • Beginner
  • 87 replies
  • Answer
  • March 14, 2022

I just got this from Zapier:

 

I’m reaching out because you may have received the following error from the Google Sheets integration: "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute' of service 'sheets.googleapis.com' for consumer 'project_number:927538837578'." I wanted to let you know we recently got these quota limits increased for the Google Sheets integration which should resolve these error with no action needed from your end. If you continue to see this specific error, please don't hesitate to reach out. Have a great one!

 

Thank you Zapier!!


Forum|alt.badge.img+3
  • Author
  • Beginner
  • 87 replies
  • March 14, 2022

It has been 3 weeks and I am still getting the same error message.

 

Is there any new information to pass along?  Is this the best that customer service can do with a critical tool like this?  What happened to the priority related to this issue?

 

Can we not do better?

 

gml


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • 2653 replies
  • March 2, 2022

Hi @ablit! You’ve been added to the list of impacted users. Thanks for hanging in there with us. We’ll let you know as soon as there’s a fix in place!


  • New
  • 1 reply
  • March 2, 2022

We are also being affected.  Three different google sheet time out issues.  We have had several in between that have gone through.  So it is hit and miss.  Thanks for researching this.  We’ll check back here for updates.


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7811 replies
  • February 28, 2022

Hi @Jack H. and @blueguy

@Jack H., it looks as though you’ve already been added to the list of impacted users by our Support team. We’ll be in touch as soon as we have any updates to share!

@blueguy, I’m not certain what trigger you’re using for those Zaps but if it’s using a polling rather than instant type of trigger then it’s possible for the Zap to be triggered (or at least attempt to trigger) outside of working hours.

With polling triggers the Zap will check the trigger app at regular intervals (every 1 to 15 minutes depending on your plan) to see if there’s been any updates and if there has it will trigger for them. And equally, if the Zap runs into an error while checking we’ll send you a notification about that, which appears to be the case here.

You can find out more about the difference between polling and instant triggers here: Trigger Types 

Hope that helps! :slight_smile:


Forum|alt.badge.img+3
  • Author
  • Beginner
  • 87 replies
  • February 26, 2022

Here are some more errors messages that came in today:

 

 

Now I am posting these not to complain but try to help here.  Both of these errors occurred at the same time: it was on a Saturday morning at 9:52 AM.  However, our business was not even open during this time so it was “impossible” for these ZAPS to trigger in the first place. 

 

So I am wondering what is going on here?  Why am I getting errors on ZAPS that should not be triggering?

 

Thoughts?

 

gml 


  • New
  • 1 reply
  • February 25, 2022

@SamB Can you please add me to the list of impacted users as well? We have been experiencing the same issue detailed in this thread.


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7811 replies
  • February 25, 2022

I’m really sorry to hear that, @BazookaJoe. I’ve gone ahead and added you to the list of affected users.

I don’t know whether tray.io/automate.io are running into similar issues but we’ll be sure to email you the minute this issue has been fixed.


  • New
  • 1 reply
  • February 25, 2022

Our team is also affected by these errors. Going to look at alternative integration solutions. Don’t believe these issues are happening with tray.io or automate.io. 


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • 2653 replies
  • February 25, 2022

Thanks for letting us know @TheHistoryQuill and @Greg_GW. I’ve got you both added to the list of impacted users. We’ll be sure to let ya’ll know and keep the thread updated once there’s a fix in place!


Forum|alt.badge.img+3
  • Author
  • Beginner
  • 87 replies
  • February 24, 2022

I agree with Martin above!! This is an issue.

Here are some more errors in the past 60 min alone!!

 


  • New
  • 1 reply
  • February 24, 2022

Hi @SamB - we are now experiencing this issue as well.  Please add us to the list of affected users.


Hi, we’re also experiencing this problem, so please add me to the list of affected users. We have lots of Zaps relying on Google Sheets, and this is becoming a concern.


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7811 replies
  • February 24, 2022

Thanks for reaching out here @NoahFr, @JacobW, @jayarr and @martinsimmermann. Really sorry that you’re all running into these errors as well. I’ve gone ahead and added all of you the the list of affected users. We’ll be in touch as soon as it’s resolved.


We are experiencing the same issues. And for us the issue is VERY serious. Errors have meant that we have failed to provide the service that the customers have paid for and it has really negatively impacted our business and customer satisfaction. :/

So please add me to the list of users affected by this, @christina.d.

 


  • New
  • 1 reply
  • February 23, 2022

Please add me to the list of users affected by this, @christina.d. I’d appreciate any updates as they become available.


  • New
  • 1 reply
  • February 23, 2022

Running into this issue as well - appreciate Zapier looking into a fix! Have many workflows running on Sheets. The chance of them working as intended has been sort of 50/50 since this issue started appearing ~a week ago


Forum|alt.badge.img
  • Beginner
  • 10 replies
  • February 23, 2022

We too are experiencing the same issue. Any update?


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • 2653 replies
  • February 23, 2022

Thank you for letting us know,@e.dgr. I’ve got you added to the list of affected users!

I definitely appreciate you sharing your candid feedback,@blueguy. While I can’t provide you with an ETA, I do want to reassure your thoughts aren’t falling on deaf ears. The team is actively digging into this and hopefully, we’ll have more news for you soon. 

For anyone who may be following along I also wanted to share some of what was discussed in the support ticket in case it adds any clarity:

...the error wasn't caused by the traffic in your Zap (specific to your user account) but rather an accumulation of requests coming from all user accounts from Zapier.

Unfortunately, this must be resolved at a platform level by our team responsible for the Google Sheets integration, as we may require an increase of rate-limits allowed.


Forum|alt.badge.img+3
  • Author
  • Beginner
  • 87 replies
  • February 23, 2022

I have not heard anything....i I'm not trying to be hypercritical here either. I would just rather have my things work because we depend upon them. Hopefully this is a big enough concern for them to get moving on this


  • 3 replies
  • February 23, 2022

We’re experiencing the same issue. Any update on when this may be solved?


Forum|alt.badge.img+3
  • Author
  • Beginner
  • 87 replies
  • February 22, 2022

More error messages:

 

This is getting annoying

 

gml


Forum|alt.badge.img+3
  • Author
  • Beginner
  • 87 replies
  • February 21, 2022

Sam B:   Several questions for you to ponder:

 

  1. How long should I wait for Zapier to fix this problem? 3 days? 3 months?
  2. How many errors should I endure before switching over to something like AirTable or Microsoft Excel?  And spending hours of our time re-working our processes?
  3. Can we do better at giving your customers who rely on this product with the guidance?  Saying this is a priority for tech support provides little assurance.

Out business relies on your product and your simplistic answer was not so re-assuring. 

 

GML


Forum|alt.badge.img+3
  • Author
  • Beginner
  • 87 replies
  • February 21, 2022

I redid some of the Google Sheets but that did not help matters!!