• Resolved ilarsf

    (@ilarsf)


    Dear,

    I am receiving error 429 intermittently when form submissions from WP Forms are written to the linked Google Sheets.

    Here is the error:

    23 April 2025 08:29:03 PHP 8.3.11 {<br /> "error": {<br /> "code": 429,<br /> "message": "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute' of service 'sheets.googleapis.com' for consumer 'project_number:<project NR>'.",<br /> "errors": [<br /> {<br /> "message": "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute' of service 'sheets.googleapis.com' for consumer 'project_number:<project NR>'.",<br /> "domain": "global",<br /> "reason": "rateLimitExceeded"<br /> }<br /> ],<br /> "status": "RESOURCE_EXHAUSTED",<br /> "details": [<br /> {<br /> "@type": "type.googleapis.com/google.rpc.ErrorInfo",<br /> "reason": "RATE_LIMIT_EXCEEDED",<br /> "domain": "googleapis.com",<br /> "metadata": {<br /> "quota_limit": "ReadRequestsPerMinutePerProject",<br /> "service": "sheets.googleapis.com",<br /> "consumer": "projects/project NR",<br /> "quota_location": "global",<br /> "quota_metric": "sheets.googleapis.com/read_requests",<br /> "quota_limit_value": "300"<br /> }<br /> },<br /> {<br /> "@type": "type.googleapis.com/google.rpc.Help",<br /> "links": [<br /> {<br /> "description": "Request a higher quota limit.",<br /> "url": "https://cloud.google.com/docs/quotas/help/request_increase"<br /> }<br /> ]<br /> }<br /> ]<br /> }<br /> }<br /> <br />

    The API is only triggered once or twice a day, so I’m really confused that the plugin is hitting read requests per minute limit. But it is only doing so intermittently – some entries go through without problem, but more often than not I get this error.

    How is the plugin generating these read requests, and is there something on my side I can do to decrease the amount of read requests?

    (edit for formatting)

    • This topic was modified 11 months, 2 weeks ago by ilarsf.
    • This topic was modified 11 months, 2 weeks ago by ilarsf.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Abdullah Kaludi

    (@abdullah17)

    Hello @ilarsf
    Thanks for getting in touch,

    The issue for missing entries will be faced only due to google quota limits only, here is the link in which explained in detail.
    https://www.gsheetconnector.com/how-to-fix-missing-entries-caused-by-google-quota-limits

    Thread Starter ilarsf

    (@ilarsf)

    Thank you for your reply. On the link you provided, I read that the issue arises because all automatic authentication (free) users use a shared quota. The solutions proposed are: manually setting the authentication API (pro function) or manually syncing the entries (also a pro feature).

    Could you therefore confirm to me that in order to address this issue, the only solution is to upgrade to the pro version of GSheet Connector? Or are there alternative solutions not included on the link you provided that I, as free user, can try?

    Thank you for letting me know!

    Plugin Author Abdullah Kaludi

    (@abdullah17)

    @ilarsf
    We’ll give an update in next release with New API details to avoid the issue of google quota!
    Hope this helps!!

    Thread Starter ilarsf

    (@ilarsf)

    Certainly, thanks so much for your time and quick responses! Have a nice day.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Error 429 for Google Sheets API’ is closed to new replies.