Google Sheets MCP server

Google Sheets MCP

English | Русский

A1 Google Sheets MCP lets an AI app work with Google Sheets in plain language. Find a spreadsheet, read its data, write and append rows, shape sheets and formatting, build charts and share the result.

It uses the Google Sheets API with your Google account. It separates reading from writing, keeps destructive operations explicit and makes the limits of the Sheets API clear instead of implying that every spreadsheet task is possible.

• 26 tools. Search and create spreadsheets, read and write ranges, manage sheets, formatting, data validation, protected ranges, conditional formats, structured tables, charts and access.
• Connects from the conversation. Say "connect Google Sheets": the server walks you through the OAuth client, catches Google's redirect on 127.0.0.1 with PKCE and keeps the tokens itself — no config files, no restart.
• Writes are deliberate. A write is never replayed after an ambiguous failure — a replayed append would duplicate rows — and destructive tools are marked so your AI client can ask first.
• Sheets only. Drive is an internal dependency for spreadsheet search and sharing alone; there is no generic Drive tool, and raw_request cannot reach Drive.
• Minimal Google scopes. spreadsheets covers every Sheets tool; a Drive scope is needed only for spreadsheet search and sharing.

Start with a read-only question:

Find the quarterly budget spreadsheet and summarize what each of its sheets contains.

Connect the server · Explore use cases · Open technical documentation

See it work in a minute

You: Show me the structure of the sales report spreadsheet — its sheets, their sizes and frozen rows.

Assistant: Shows the sheets with their sizes, frozen headers and the objects on them. Nothing changes.

You: Prepare a “March” sheet as a copy of “February” and clear the numbers, keeping the layout.

Assistant: Shows the plan — duplicate the sheet, rename it and clear the data ranges — then asks for confirmation before changing anything.

You: Confirm.

Assistant: Duplicates the sheet and clears the values. Formatting, data validation and frozen rows stay.

Contents

• Quick start
• What you can ask it to do
• How a spreadsheet changes
• What can change
• Getting access
• Configuration
• Data, limits and background work
• Technical documentation
• Support

Quick start

You need Node.js 20+ and a Google account. Credentials are not required at install time — the server connects from the conversation.

1. Add the server to your AI app.
2. Say "connect Google Sheets": the assistant walks you through creating the OAuth client and approving access without editing config files.
3. Ask the read-only question above.

Codex

Shortened. The full README is on GitHub.