---
title: "How to fix \"Bad Request\" error when connecting Google Sheets via Google API in wpDataTables?"
description: "Why am I getting a 'Bad Request' error when using a Google Sheet as a table source?"
url: https://help.wpdatatables.com/en/articles/28-how-to-fix-bad-request-error-when-connecting-google-sheets-via-google-api-in-wpdatatables
collection: "Technical issues"
updated: 2026-09-21
language: en
---

# How to fix "Bad Request" error when connecting Google Sheets via Google API in wpDataTables?

Why am I getting a 'Bad Request' error when using a Google Sheet as a table source?

* * *

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:

1.  **Ensure you are using the latest wpDataTables version**  
    Check the latest version here:  
    [Changelog – What’s New in wpDataTables](https://wpdatatables.com/help/whats-new-changelog/)
    
2.  **Update the plugin if needed**  
    Follow our update guide here:  
    [How to Update wpDataTables](https://help.wpdatatables.com/en/articles/1-how-to-update-wpdatatables.md)
    
3.  **Verify your Google Sheets table setup**  
    Make sure you followed all steps from our guide:  
    [Creating wpDataTables from Google Spreadsheets](https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-google-spreadsheets/)
    
4.  **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](https://wpdatatables.com/documentation/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**.

* * *

### Still seeing the 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.