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.
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, from a whole tab, a range such as "Sales!A1:F200", or a named range. 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. Google Sheets is in Docs & files, not marketing, so it's on the Free plan too.
- A Google account that can open the spreadsheets.
Connect Google Sheets
- Open Connections and click Add connection.
- Choose Google Sheets.
- Read What happens next and click Continue to Google.
- Choose the Google account that can open your spreadsheets.
- If Google says "Google hasn't verified this app", click Advanced, then Go to Plugsight (unsafe).
- Google asks: "See all your Google Sheets spreadsheets". Tick the box and continue.
- 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 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.