I know it’s been a similar problem in the mid September.
I got the same problem now:
"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",
I am currently trying to read the one Google Sheet every 10 minutes, to run automations based off it.