I have followed the instructions on your website to connect a table to a private google spreadsheet via the Google Spreadsheet API Settings. I have approximately 18 tables connected to a single google sheet (each table corresponds to a separate tab in the spreadhsheet). I am getting a "Too Many Requests" error when I try to view that table in the wordpress admin or on the website using the shortcode. Please advise. Thanks
After exploring this issue we found that the Google Sheets API has a quota limit. It's limited to 500 requests per 100 seconds per project, and 100 requests per 100 seconds per user.
That quota can be increased, but that requires additional charge in Google (increasing the quota is not free). Another way would be to use the old method without the API.
Our developers are working on this, and we'll try to come up with a better solution for one of our updates, without the need to pay Google for increasing the quota.
I have followed the instructions on your website to connect a table to a private google spreadsheet via the Google Spreadsheet API Settings. I have approximately 18 tables connected to a single google sheet (each table corresponds to a separate tab in the spreadhsheet). I am getting a "Too Many Requests" error when I try to view that table in the wordpress admin or on the website using the shortcode. Please advise. Thanks
Hi Jon
Thank you for reaching out to us.
After exploring this issue we found that the Google Sheets API has a quota limit. It's limited to 500 requests per 100 seconds per project, and 100 requests per 100 seconds per user.
https://developers.google.com/sheets/api/limits
That quota can be increased, but that requires additional charge in Google (increasing the quota is not free). Another way would be to use the old method without the API.
Our developers are working on this, and we'll try to come up with a better solution for one of our updates, without the need to pay Google for increasing the quota.