Add row did not work on Google Sheets

[rohan090]

Hey guys,

I need some help. Here's what I'm trying to do. I have a list of records that I want to transfer to google sheets. I need two fields (locationID and ContactID) that cannot be exported to csv directly from crm. So using a webhook and Pabbly Connect to export the list.

There are 3280 records. I created a webhook and 3280 tasks were consumed but only 41 were exported. What happened?

 

[Neeraj]

Hey guys,

I need some help. Here's what I'm trying to do. I have a list of records that I want to transfer to google sheets. I need two fields (locationID and ContactID) that cannot be exported to csv directly from crm. So using a webhook and Pabbly Connect to export the list.

There are 3280 records. I created a webhook and 3280 tasks were consumed but only 41 were exported. What happened?

Did you track the task history to see what exactly is the issue while adding the new row to Google Sheets?

Task History gives you all the details on what happened with that specific task. It will show all the tasks executed on that specific workflow.

Can you share the task history to see if there are any errors on the same?

 

[rohan090]

Here's what I found on the task history

 

[Neeraj]

You will see the error in Data Out of the Google Sheets. What error do you see there?

 

[rohan090]

{
"error > code": 429,
"error > message": "Quota exceeded for quota metric 'Write requests' and limit 'Write requests per minute per user' of service 'sheets.googleapis.com' for consumer 'project_number:1011300378975'.",
"error > status": "RESOURCE_EXHAUSTED",
"error > details > 0 > @type": "type.googleapis.com/google.rpc.ErrorInfo",
"error > details > 0 > reason": "RATE_LIMIT_EXCEEDED",
"error > details > 0 > domain": "googleapis.com",
"error > details > 0 > metadata > consumer": "projects/1011300378975",
"error > details > 0 > metadata > quota_metric": "sheets.googleapis.com/write_requests",
"error > details > 0 > metadata > quota_limit": "WriteRequestsPerMinutePerUser",
"error > details > 0 > metadata > service": "sheets.googleapis.com"
}

 

[Neeraj]

{
"error > code": 429,
"error > message": "Quota exceeded for quota metric 'Write requests' and limit 'Write requests per minute per user' of service 'sheets.googleapis.com' for consumer 'project_number:1011300378975'.",
"error > status": "RESOURCE_EXHAUSTED",
"error > details > 0 > @type": "type.googleapis.com/google.rpc.ErrorInfo",
"error > details > 0 > reason": "RATE_LIMIT_EXCEEDED",
"error > details > 0 > domain": "googleapis.com",
"error > details > 0 > metadata > consumer": "projects/1011300378975",
"error > details > 0 > metadata > quota_metric": "sheets.googleapis.com/write_requests",
"error > details > 0 > metadata > quota_limit": "WriteRequestsPerMinutePerUser",
"error > details > 0 > metadata > service": "sheets.googleapis.com"
}

Google Sheets API has a usage limits of per user basis. In the error shown, your rate limit for adding rows of data to Google Sheets has exceeded.

You can check the limits here.

You can only add upto 100 rows of data every 100 seconds. Prior which your operation will fail.

In case of any failure, you can re-execute the step manually from the Task History Tab.

Also, check if there is any other way to send the webhooks that are not more than 100 rows of data in the period of 100 seconds.