If you encounter an error “Too many requests” when loading Google Sheet linked tables, this error occurs when the Google API request limit is exceeded.
When the auto-update cache option is enabled while using the Google Sheets API method, our plugin makes a couple of API calls each time the cron job runs.
It does this for each individual table connected to retrieve the latest data from the source spreadsheet.
Due to Google's API quota limits, if you have many tables connected to Google Sheets, these frequent calls can exceed the allowed quota, resulting in the "Too Many Requests" error.
You can find more details about Google’s API quota here.
Possible Solutions:
Disable the "Auto Update Cache" option
This is a viable option if you don’t update your source spreadsheet frequently.
Instead of automatic updates, you’ll need to manually refresh the data by going to the table settings in the back-end and clicking "Save Changes" whenever you make updates to the sheet.
However, if you have many tables that require frequent updates, this might not be ideal.
Increase the Google API quota
Google allows users to request a quota increase, but this comes with an additional cost.
More information on this can be found under the "Request a quota increase" section on the page linked above.
We understand that this is not an ideal situation, and we are actively working on finding a better solution to reduce API calls and prevent this issue in the future. If we implement an improvement, it will be mentioned in our ChangeLog during an update.