andykss

I’m having the same problem too. Client has noticed that not all form entries are being added to the sheet.

No logs were created in the backend
(Contact > Google Sheets > Debug Log > View)

Looking at the code in /wp-content/plugins/cf7-google-sheets-connector/lib/google-sheets.php > public function add_row($data), I notice that any Exception encountered by the catch block is not logged, it is simply discarded! 🤨

So I modified the code to log these exceptions to a file, and discovered this in the logs after a failure:

"errors": [
  {
    "message": "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute' of service 'sheets.googleapis.com' for consumer 'project_number:1075324102277'.",
    "domain": "global",
    "reason": "rateLimitExceeded"
  }
],
"status": "RESOURCE_EXHAUSTED"

And a little further down…

"links": [
  {
    "description": "Request a higher quota limit.",
    "url": "https://cloud.google.com/docs/quota#requesting_higher_quota"
  }
]

Is there a way around this? I didn’t set up a Google project for this, so is this particular project_number:1075324102277 shared between all free users, causing it to hit the rate limit? Would PRO allow us to use a dedicated project_number or one with no upper limit?

Thanks for your help. It’s a great plugin apart from this one issue! 😁