# Google Sheets

> Connect Google Sheets so your AI can read any spreadsheet you can open, from its link. Read-only. Offered once Google approves it.

Connect Google Sheets and your AI can read any spreadsheet you can open: give it the link and ask your question. Plugsight only reads: it never edits, adds or deletes cells, tabs or files.


> [!IMPORTANT]
> Google is still reviewing the Sheets permission. Until Google approves it, Google Sheets isn't offered to everyone and may not appear in your **Connector catalog**.


## What your AI can do

- **Spreadsheet details**: the title, the tabs (with their size) and named ranges.
- **Read a spreadsheet**: values as they're shown in Google Sheets (or the formulas, if you ask), from a whole tab, a range such as "Sales!A1:F200", or a named range. The names of the other tabs come back too, so your AI knows what else is there. The first row is used as column names, unless you say it isn't a header row.

Your AI reads a spreadsheet by its link (from your browser's address bar) or its id. It can't browse or search your Drive for spreadsheets.

### Example questions

- "Here's our budget: https://docs.google.com/spreadsheets/d/… Which categories are over budget this quarter?"
- "Read the Leads tab of this sheet and list everyone from London."
- "What tabs does this spreadsheet have, and how big is each?"
- "Total the Amount column in Sales!A1:F500 by month."

## What you need

- Any plan, once Google approves it. It's in **Docs & files**, not marketing, so it's on the Free plan too.
- A Google account that can open the spreadsheets.

## Connect Google Sheets

1. Open **Connections** and click **Add connection**.
2. Choose **Google Sheets**.
3. Read **What happens next** and click **Continue to Google**.
4. Choose the Google account that can open your spreadsheets.
5. If Google says **"Google hasn't verified this app"**, click **Advanced**, then **Go to Plugsight (unsafe)**.
6. Google asks: "See all your Google Sheets spreadsheets". Tick the box and continue.
7. You're back on **Connections**, with a message such as "Connected you@example.com: ready to read any spreadsheet you can open, by link."

Then add the connection to an MCP server and [refresh the tools list](https://docs.plugsight.app/ai-apps/refresh-tools.md) in your AI app.

## What it can and can't change

Google Sheets is **read-only**, and Google's permission is read-only too.

## Limits

- Up to 5,000 rows per read (500 by default). For bigger sheets, ask for a smaller range.
- Without a range, the first tab is read.
- If you have more than one Google Sheets connection in an MCP server, your AI needs to know which one to use.

## Troubleshooting

### That isn't a Google Sheets link or id. Paste the spreadsheet's link from the browser's address bar.

**What it means:** What you gave your AI doesn't look like a spreadsheet link.

**How to fix it:** Open the spreadsheet in your browser and copy the full address from the address bar.

### Google couldn't find that item. … / Google says this login isn't allowed to do that. …

**What it means:** The spreadsheet doesn't exist, or the Google account you connected can't open it.

**How to fix it:** Check the link, and that the connected Google account can open the spreadsheet. If someone else owns it, ask them to share it with that account.


### This Google service is coming soon.

**What it means:** Google hasn't finished reviewing the permission.

**How to fix it:** Nothing to do for now. It will appear in the **Connector catalog** once Google approves it.


### Google Sheets access wasn't granted. Tick the permission and try again.

**What it means:** The permission box on Google's screen wasn't ticked.

**How to fix it:** Connect again and tick the box.

## Related articles

- [Google Docs](https://docs.plugsight.app/connectors/google-docs.md)
- [Google Forms](https://docs.plugsight.app/connectors/google-forms.md)
- [Google Drive](https://docs.plugsight.app/connectors/google-drive.md)
- [Google Sheets tools](https://docs.plugsight.app/developers/sheets-tools.md)

---

Web version: https://docs.plugsight.app/connectors/google-sheets
