Google Sheets MCP Server

Google Sheets API for reading spreadsheets and cell ranges.

16 tools

SKILL.md

Start chatting with Google Sheets tools

Open Studio to chat with 16 Google Sheets tools right now — the skill is included automatically.

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.

Google Sheets Validate Token

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

Integration Details

Authentication

One-click sign in

Official Website

Frequently Asked Questions

What is the Google Sheets MCP server?

Google Sheets API for reading spreadsheets and cell ranges. It provides 16 tools that AI agents can use through the Model Context Protocol (MCP).

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

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

What is MCP?

Model Context Protocol lets AI tools call external capabilities securely through a single URL. This bundle groups tools behind an MCP endpoint that many clients can use.