Error with "lookup" in google sheet

[rjwalkerz3sm]

This is happening more and more and more.... https://www.loom.com/share/94b8e896b67447a9bd3b2f8f5f3f5d13

 

[aidan cottrell]

I've also recieved this message, seem's to be Pabbly's API is exhausting it's quota?

 

[aidan cottrell]

Nothing to do with Pabbly Connect. This limits are at individual gmail account level.

Check this for more details on limits - https://developers.google.com/sheets/api/limits

Sorry mate, you're only half correct. If you read the link you provided, you'll see it's not only based on an individual account level; it's by project (eg API credentials (eg Pabbly Connect) as well as the user account.

I'm recieving this message on a stand-alone gmail account, with nothing connected to it except Pabbly. And recieving it on the very fist lookup that only occurs once per day. Obviously not anywhere near the 60 per minute per user per project limit. Only explanation is that the entire project (eg Pabbly Connect) is reaching the 300 per minute per project limit.

It's entirely to do with Pabbly Connect, they need to request a higher quota.

 

[Fagun Shah]

Sorry mate, you're only half correct. If you read the link you provided, you'll see it's not only based on an individual account level; it's by project (eg API credentials (eg Pabbly Connect) as well as the user account.

I'm recieving this message on a stand-alone gmail account, with nothing connected to it except Pabbly. And recieving it on the very fist lookup that only occurs once per day. Obviously not anywhere near the 60 per minute per user per project limit. Only explanation is that the entire project (eg Pabbly Connect) is reaching the 300 per minute per project limit.

It's entirely to do with Pabbly Connect, they need to request a higher quota.

Let's tag pabbly team here, @Pabbly @Naveen

 

[PabblyMember3]

We have checked our project quotas and everything seems to be ok and are under limits.

 

[aidan cottrell]

Are you guys very very sure about that?

Look at my account/task history:
I only have a single active workflow on my Pabbly account.
It's a simple "Grab row from Google Sheet -> Post on Twitter".
It only occurs once per day, and uses 4 Google Sheets related-steps.
It's been running fine, once per day, for almost 8 months.

Why would i suddenly get a 429 "Resource has been exhausted (e.g. check quota)." error today, with absolutely no changes from my side? And on the very first Google Sheet related step in the workflow?

Theres only a few possible explanations:

• Somehow something changed on the backend so that the "Google Sheets: Lookup Spreadsheet Rows" action is actually making >60 calls.
• You're using my Google account identity to make other API calls without my permission or instruction, or you've suffered a data breach.
• You briefly went over your project quota for a single minute, 9 hours ago.

I'd like to hope it's the third option.

 

[PabblyMember3]

I have checked your account but didn't get such workflow, Can you please share the correct Pabbly Connect account email here.

I have double checked our project's quota and everything is fine there. Also, only the authorized accounts are able to make the API calls to Google project via Pabbly Connect workflow. Our Lookup function searches the specified data in the specified column. I need to check your API call in the logs, do share a task history ID so that, I can check it deeply and get back to you with more details.

 

[rjwalkerz3sm]

We have checked our project quotas and everything seems to be ok and are under limits.

Then how do I get this error to stop??

 

[PabblyMember3]

We are looking into this issue, our Google Sheets project quota is under limit still a couple of users are getting this error. We have also reported this issue to the Google support team.

We will keep updating you about the same.

 

[rjwalkerz3sm]

We are looking into this issue, our Google Sheets project quota is under limit still a couple of users are getting this error. We have also reported this issue to the Google support team.

We will keep updating you about the same.

Thank you ! I literally just got another one - https://www.screencast.com/t/MFIkMoo1

Is there something i can set up that will auto retry those in 30 seconds if they fail??

 

[rjwalkerz3sm]

Any update @Naveen ?

Is there something i can set up that will auto retry those in XX seconds if they fail??

 

[PabblyMember3]

Hey @aidan cottrell, @rjwalkerz3sm ,

We have made some changes to the Lookup Spreadsheet and Gmail Send Email actions. It should work fine. Please check your workflows and let us know if issue persists.

 

[rjwalkerz3sm]

It just did it again... here are details: https://www.loom.com/share/2f477e27d2aa461098ed353765a2b6ed
@Naveen

 

[PabblyMember3]

It just did it again... here are details: https://www.loom.com/share/2f477e27d2aa461098ed353765a2b6ed
@Naveen

It seems the row index didn't passed into the action. Will check your task history and get back to you with more explanation.

 

[rjwalkerz3sm]

It is happening less... but still happening - https://www.screencast.com/t/Au2sL1ywZtv