If you’re encountering a "Bad Request" error when using a Google Sheets table with the Google API connection, this typically means something is missing or misconfigured in your API or sheet sharing setup.
Steps to resolve the issue:Ensure you are using the latest wpDataTables version
Check the latest version here:
Changelog – What’s New in wpDataTables
Update the plugin if needed
Follow our update guide here:
How to Update wpDataTables
Verify your Google Sheets table setup
Make sure you followed all steps from our guide:
Creating wpDataTables from Google Spreadsheets
Double-check your Google API connection setup
Make sure the service account and API setup are configured correctly:
Connect WordPress Tables with Google Sheets API
Important for Private Sheets:If your sheet is private, it does not need to be published to the web, but you must share it with your API service account email that you used to set up the connection.
Otherwise, you will encounter an Unauthorized or Bad Request error.
If the issue persists after carefully following the above steps, feel free to reach out to our support team.
You can contact us directly via the chat box in the bottom-right corner of our website — we’ll be happy to assist further.
