Google Sheets MCP Server

Connect your account, then chat with AI to run tools.

Pull live ranges, update rows, build new workbooks, and reconcile tab data from chat — sign in with Google once in MCPBundles.

Best forOperationsFinance AnalystsRevOpsProject Coordinators

Try this workflow

Weekly pipeline pull

Open the Harbor Legal Q2 pipeline sheet, read the Deals tab through column H, and summarize stage counts plus any deals stuck more than 14 days.

Start chatting

Managed

16 tools

Agent guide included

Opens MCPBundles Studio with this server selected. After sign-in, chat and run tools from the same thread.

Browse all tools

What you can do with Google Sheets

Built for

Operations Teams, Finance Analysts, RevOps, Project Coordinators, Agency Account Managers

Example workflows

Weekly pipeline pull

Typical ops workflow: named workbook, targeted range, actionable summary.

Try this

Open the Harbor Legal Q2 pipeline sheet, read the Deals tab through column H, and summarize stage counts plus any deals stuck more than 14 days.

Refresh a tracker

Read-update pattern for recurring operational spreadsheets.

Try this

Find my Bright Smile Co campaign tracker, append this week's spend and lead counts on the Weekly tab, and flag rows where cost per lead jumped more than 20%.

Build a new workbook

Create-and-seed flow for new team trackers without manual setup.

Try this

Create a spreadsheet called Acme Dental Onboarding with tabs for Clients, Tasks, and Notes — add headers and drop in the first three sample rows so the team can start editing.

Resolve comment threads

Collaboration cleanup when finance and ops work in the same file.

Try this

List open comments on the Riverside Dental budget sheet, summarize what each thread is asking for, and mark resolved the ones that only needed a number check.

Context to know first

What is Google Sheets MCP?

Google Sheets MCP connects your spreadsheets to AI assistants in Cursor, Claude, or ChatGPT so you can read ranges, update cells, create workbooks, and manage comments from chat after you sign in with Google in MCPBundles.

Who is this for?

Operators and analysts who live in shared trackers — pipeline lists, budgets, campaign logs, and client workbooks — and want answers or updates without copying blocks between tabs.

Can an agent edit my spreadsheets?

Yes, when your connection includes edit access. You choose the permission level during Google sign-in — read-only for reporting, or read and write when you want the assistant to append rows, clear ranges, or create new sheets.

Related editorial

Google Sheets Spreadsheet Workflows with AI

How AI agents can read live ranges, append rows, seed workbooks, and reconcile tab data in shared trackers without copying blocks between tabs.

Read article

AI Skill
SKILL.md

Domain knowledge for Google Sheets — workflow patterns, data models, and gotchas for your AI agent.

Google Sheets

Google Sheets API for reading spreadsheets and cell ranges. Read/write cells, formulas.

Data Model

Spreadsheets — grid metadata: sheet ids, row/column counts, protected ranges.
Cell values — bulk read/write through A1 ranges spanning one or many tabs.
Discovery — find spreadsheets with Drive search on the Google Sheets MIME type.

Gotchas

spreadsheet_id: From Drive or URL.
A1 notation: Sheet1!A1:B2 for ranges.

Tools in this Server (16)

Google Sheets Clear Values

Clear (delete) values in a spreadsheet range (Sheets API spreadsheets.values.clear).

Google Sheets Create Cond Format

Create a conditional formatting rule in a Google Sheet.

Google Sheets Create Sheet

Add a new sheet (tab) to an existing Google Spreadsheet.

Google Sheets Create Spreadsheet

Create a new Google Spreadsheet with specified title and sheet count.

Google Sheets Create Spreadsheet Comment

Create a comment on a Google Spreadsheet (Drive comments.create).

Google Sheets Delete Cond Format

Delete a conditional formatting rule from a Google Sheet.

Google Sheets Format Range

Apply cell formatting (colors, fonts, borders, etc.) to a range in Google Sheets.

Google Sheets Get Spreadsheet

Fetch a spreadsheet by ID (Sheets API spreadsheets.get).

Google Sheets Get Values

Read a range of cells from a spreadsheet (Sheets API spreadsheets.values.get).

Google Sheets List Spreadsheets

List Google Sheets spreadsheets accessible to the authenticated user (via Drive files.list).

Google Sheets Read Spreadsheet Comments

List comments on a Google Spreadsheet (Drive comments.list).

Google Sheets Reply To Spreadsheet Comment

Reply to a spreadsheet comment (Drive replies.create).

Google Sheets Resolve Spreadsheet Comment

Resolve (or unresolve) a spreadsheet comment (Drive comments.update).

Google Sheets Update Cond Format

Update an existing conditional formatting rule in a Google Sheet.

Google Sheets Update Values

Update cell values in a Google Sheet range. The number of rows in `values` must match the row span of `range` (e.g. range Sheet1!A1:C3 expects exactly...

Google Sheets Validate Token

Validate the Google Sheets OAuth token and confirm required scopes are granted.

Frequently Asked Questions

What is Google Sheets MCP?

Who is this for?

Operators and analysts who live in shared trackers — pipeline lists, budgets, campaign logs, and client workbooks — and want answers or updates without copying blocks between tabs.

Can an agent edit my spreadsheets?

How does the assistant find the right file?

Name the spreadsheet in chat, paste its link, or ask for a list of recent workbooks. With broader Drive access enabled at connect time, the assistant can search your Google Drive for matching titles.

How do I connect?

Open the Google Sheets skill page in MCPBundles, choose your permission level, and sign in with Google. Pick Standard for known spreadsheet IDs or picker-selected files; choose Full Access when you need to search all spreadsheets or manage comments.

How do I connect Google Sheets to my AI agent?

Add the MCPBundles server URL to your MCP client configuration (Claude Desktop, Cursor, VS Code, etc.). The URL format is: https://mcp.mcpbundles.com/bundle/google-sheets. Authentication is handled automatically.

How many tools does Google Sheets provide?

Google Sheets provides 16 tools that can be called by AI agents, along with a SKILL.md that gives your AI agent domain knowledge about when and how to use them.

What authentication does Google Sheets require?

Google Sheets uses One-click sign in. Google Sheets requires credentials. Connect via MCPBundles and authentication is handled automatically.

Setup Instructions

Connect Google Sheets to any MCP client in minutes

MCP URL

https://mcp.mcpbundles.com/bundle/google-sheets

Claude.ai Cursor VS Code VS Code Insiders Goose LM Studio Cherry Studio ChatGPT

One-click install:

Install on Claude.ai Install for organization (admins)

The link prefills the Add custom connector dialog — you still review the values and click Add, then Connect to complete OAuth.

Or add manually

Open claude.ai → Settings → Connectors.
Click the + button and choose Add custom connector.
Set Name to Google Sheets and paste the MCP URL into Remote MCP server URL.
Click Add. Google Sheets will appear under Not connected — select it and click Connect to complete OAuth.