New Project Create and already at Quota Limit

[rkrausse]

Hello,

    New here. I just created a NEW project, added API access to Drive and Sheets. My first called to sheets to clear out a sheet returns 

Quota exceeded for quota metric 'Write requests' and limit 'Write requests per minute per user' of service 'sheets.googleapis.com' for consumer 'project_number:XXXXXXXXXXX

How can it be exceeded when I just created it? Is it by project or user? How can I see these in the console.

Thanks

Ralph

[greb]

Hi @rkrausse,

Welcome to Google Cloud Community!

The error message you are encountering, "Quota exceeded for quota metric 'Write requests' and limit 'Write requests per minute per user'", usually arises when the Sheets API surpasses the permitted write requests quota.

Quick Fixes:

1. Check Quota Usage:
   Go to IAM & Admin > Quotas & System Limits in the Cloud Console to see if you're hitting the limit:
   Google Cloud Console - Quotas
2. Optimize Your Calls:
   Batch your operations with spreadsheets.batchUpdate to reduce the number of requests
3. Retry Logic:
   Add a delay with exponential backoff if you hit the limit.
4. Request More Quota:
   If you need higher limits, you can request an increase here.

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.

[jayeshmahajan]

The quota is applied per user (or service account, if you are using one), not just the project. If the same user or service account is making excessive requests (even across multiple projects), they can hit the limit. Some services have shared quotas across projects for the same user or service account, so creating a new project doesn't reset those quotas.

To check the quotas 

• Go to https://console.cloud.google.com/  -> IAM & Admin  -> Quotas in the Google Cloud Console.
• Filter for Sheets API: In the "Services" filter, search for sheets.googleapis.com.
• Find the Quota Metric: Look for "Write requests per minute per user."
• Check Usage: You'll see the current usage and limits applied.

This quota, Write requests per minute per user, is user-based.