Google Sheet Error - 429 - Resource has been exhausted (e.g. check quota).

[rob_moser]

Your Task History ID

IjU3NjAwNTY1MDYzZjA0MzA1MjZmNTUzMDUxMzA1MTYxNTQzNyI_3D_pc

@Neeraj Currently pabbly connect's google sheet integration is not working properly and giving 429 error too many times even when we are not even close to the 1-minute quota limits.

We know that pabbly team thinks it is an issue from Google side and not from pabbly side.

But this makes using pabbly connect almost impossible for us. None of the other platforms like zapier or make are having these issues.

We don't know how you can solve it, but it needs to be solved immediately for making pabbly a reliable automation platform.

 

[Pabblymember11]

Hey @rob_moser

As we can see from your shown error, you have exhausted your rate limit to pass the request to write data per minute by "Google Sheets : Lookup Spreadsheet Rows".

Google API documentation for the error which you have got.

cloud.google.com
Errors | Cloud APIs | Google Cloud
cloud.google.com cloud.google.com

Moreover, you are also running the tasks in bulk and because of that, the error has occurred by the Google API. So, we should suggest to use a delay action step to delay the task to run after 1 min after every update of value, in that way, you wouldn't be exhausting your rate limit.

 

[getitdone.solutions]

Hey @rob_moser

As we can see from your shown error, you have exhausted your rate limit to pass the request to write data per minute by "Google Sheets : Lookup Spreadsheet Rows".

View attachment 28196

Google API documentation for the error which you have got.

cloud.google.com
Errors | Cloud APIs | Google Cloud
cloud.google.com cloud.google.com


View attachment 28198

Moreover, you are also running the tasks in bulk and because of that, the error has occurred by the Google API. So, we should suggest to use a delay action step to delay the task to run after 1 min after every update of value, in that way, you wouldn't be exhausting your rate limit.

View attachment 28199

Where do we put this delay function? Our recipe is iterating through an array of data and writing out one row for every row of data. There are about 300 records. Is there another way to 'output' this data such as into a text file? I could perhaps format it like a CSV? Thanks for your help / suggestions on this.

 

[Pabblymember11]

Could you kindly provide the complete use case along with the workflow URL where you are implementing the same? This will enable us to investigate the matter further.

 

[getitdone.solutions]

Could you kindly provide the complete use case along with the workflow URL where you are implementing the same? This will enable us to investigate the matter further.

Use Case: to retrieve a full list of customers from Freshbooks and write these names to a Google Sheet.

Using interval trigger (set to run once), pulls names from Freshbooks (get all clients) then uses iterator to parse data, then add the data to Google sheets using "add multiple rows",

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[Pabblymember11]

Please incorporate a Delay action step prior to the Google Sheets action step in order to extend the processing interval.