rjwalkerz3sm
Member
This is happening more and more and more.... https://www.loom.com/share/94b8e896b67447a9bd3b2f8f5f3f5d13
-
Instructions to Ask a Question
For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.
We offer seven comprehensive applications designed to help you efficiently manage and grow your business:
- Pabbly Connect
- Pabbly Subscription Billing
- Pabbly Email Marketing
- Pabbly Form Builder
- Pabbly Email Verification
- Pabbly Hook
- Pabbly Chatflow
Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.
🚀 Exclusive Lifetime Offers 🚀
We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:
- 🔥 Pabbly Connect — Lifetime Access for $249 — View Offer
- 🔥 Pabbly Subscription Billing — Lifetime Access for $249 — View Offer
- 🔥 Pabbly Chatflow — Lifetime Access for $249 — View Offer
Make a one-time investment and enjoy the advantages of robust business management tools for years to come.
-
Error with "lookup" in google sheet
- Thread starter rjwalkerz3sm
- Start date
aidan cottrell
Member
I've also recieved this message, seem's to be Pabbly's API is exhausting it's quota?
aidan cottrell
Member
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
Well-known member
P
PabblyMember3
Guest
We have checked our project quotas and everything seems to be ok and are under limits.
aidan cottrell
Member
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:
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.
P
PabblyMember3
Guest
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.
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
Member
Then how do I get this error to stop??
P
PabblyMember3
Guest
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.
We will keep updating you about the same.
rjwalkerz3sm
Member
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
Member
P
PabblyMember3
Guest
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.
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.
Last edited by a moderator:
rjwalkerz3sm
Member
It just did it again... here are details: https://www.loom.com/share/2f477e27d2aa461098ed353765a2b6ed
@Naveen
@Naveen
P
PabblyMember3
Guest
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
Member
It is happening less... but still happening - https://www.screencast.com/t/Au2sL1ywZtv
Similar threads
