error while running automated whatsapp. No clue what this means. Anyone can help?
Status: Closed · Asked by srikant16 on · 0 views
{
"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"
}
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".

Google API documentation for the error which you have got.
https://cloud.google.com/apis/design/errors

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)