Getting error code 429 “quota exceeded on google sheet” on and off for several days. Kindly help on it on how should i solve it?
{
“response”: {
“status”: 429,
“body”: {
“error”: {
“code”: 429,
“message”: “Quota exceeded for quota metric ‘Read requests’ and limit ‘Read requests per minute’ of service ‘sheets.googleapis.com’ for consumer ‘project_number:674512252699’.”,
“status”: “RESOURCE_EXHAUSTED”,
“details”: [
{
“@type”: “type.googleapis.com/google.rpc.ErrorInfo”,
“reason”: “RATE_LIMIT_EXCEEDED”,
“domain”: “googleapis.com”,
“metadata”: {
“quota_limit_value”: “900”,
“service”: “sheets.googleapis.com”,
“quota_metric”: “sheets.googleapis.com/read_requests”,
“quota_limit”: “ReadRequestsPerMinutePerProject”,
“quota_location”: “global”,
“consumer”: “projects/674512252699”
}
},
{
“@type”: “type.googleapis.com/google.rpc.Help”,
“links”: [
{
“description”: “Request a higher quota limit.”,
“url”: “Work with quotas | Documentation | Google Cloud”
}
]
}
]
}
}
},
“request”: {}
}