• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

error while running automated whatsapp. No clue what this means. Anyone can help?

srikant16

Member
{
"error > code": 429,
"error > message": "Quota exceeded for quota metric \u0027Write requests\u0027 and limit \u0027Write requests per minute per user\u0027 of service \u0027sheets.googleapis.com\u0027 for consumer \u0027project_number:1011300378975\u0027.",
"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 > service": "sheets.googleapis.com",
"error > details > 0 > metadata > quota_limit": "WriteRequestsPerMinutePerUser",
"error > details > 0 > metadata > quota_metric": "sheets.googleapis.com/write_requests"
}
 

Supreme

Well-known member
Staff member
Hey @srikant16

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: Update Value".

2022-01-18_16h02_15.png


Google API documentation for the error which you have got.


2022-01-18_16h03_10.png


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 you to us 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.

(Add this action step before the "Update Cell Value" action step)
1642502461719.png
 
Top