How to Use the Google Sheets MCP in Claude

Q: How do I connect Google Sheets to my Claude Desktop app?

Open your local claudedesktopconfig.json file and add the Google Sheets server configuration under the mcpServers key. Once you restart Claude Desktop, the Google Sheets tools will appear as a hammer icon in your chat window.

Q: Can Claude Desktop update multiple Google Sheets tabs at the same time?

Yes, Claude Desktop uses the batchupdatespreadsheet tool to apply structural changes across multiple Google Sheets tabs simultaneously. You just tell Claude Desktop what to modify, and it handles the Google Sheets batch payload in one go.

Let Claude Desktop read, write, and edit your Google Sheets directly from your local desktop chat window without leaving the app.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect Google Sheets MCP to Claude Desktop

Create your Vinkius account to connect Google Sheets to Claude Desktop and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup Google Sheets with Claude Desktop

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Populate spreadsheets directly from Claude Desktop

Using the `append_sheet_values` tool lets Claude Desktop parse a messy wall of chat text and write clean rows to your Google Sheets tracking sheet instantly. This setup eliminates the need to manually copy text from your Claude Desktop chat window and paste it into Google Sheets rows.

Run bulk updates using this MCP Server

This MCP Server exposes `batch_update_spreadsheet` to let Claude Desktop modify Google Sheets formatting, rename tabs, and restructure columns in a single local call. Your Claude Desktop chat agent can run these complex Google Sheets structural edits without lagging your local system.

Clean up sheet data through chat commands

The `clear_sheet_values` tool lets Claude Desktop wipe specific Google Sheets zones or remove entire tabs based on your verbal chat instructions. You can instruct Claude Desktop to clean up messy Google Sheets tables using simple chat window commands.

Setup guide

Set up Google Sheets MCP in Claude Web or Desktop

1

Open Claude Settings

Go to claude.ai, click your profile icon, then navigate to Customize → Connectors.
2

Add Custom Connector

Click the "+" button and select Add custom connector. Paste your Vinkius endpoint URL: https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com. For OAuth-protected servers, expand Advanced settings to add credentials.
3

Start a conversation

Open a new chat. The Google Sheets MCP tools are available immediately — no restart needed.

Endpoint URL

https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp

No configuration file needed — paste the URL directly in the Claude web interface.

Available on Free (1 connector), Pro, Max, Team, and Enterprise plans.

Prerequisites

Claude Desktop installed (macOS or Windows)
Active Vinkius subscription with a valid endpoint token

1

Open Claude Desktop Settings

Click the menu icon at the top-left corner, go to Settings → Developer → Edit Config. This opens claude_desktop_config.json in your default text editor.
2

Paste the Google Sheets MCP configuration

Copy the JSON snippet on the right into the mcpServers object. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Restart Claude Desktop

Close and reopen the application. Claude needs a full restart to load new MCPs — refreshing a conversation is not enough.
4

Verify the connection

Open a new conversation. Click the 🔌 icon at the bottom of the message input. You should see tools listed under google-sheets-mcp.

json

{
  "mcpServers": {
    "google-sheets-mcp": {
      "url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    }
  }
}

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Google Sheets. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect Google Sheets now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about Google Sheets MCP in Claude Desktop

Open your local `claude_desktop_config.json` file and add the Google Sheets server configuration under the `mcpServers` key. Once you restart Claude Desktop, the Google Sheets tools will appear as a hammer icon in your chat window.

Yes, Claude Desktop uses the `batch_update_spreadsheet` tool to apply structural changes across multiple Google Sheets tabs simultaneously. You just tell Claude Desktop what to modify, and it handles the Google Sheets batch payload in one go.

The MCP Server passes Google Sheets API rate limit errors directly back to Claude Desktop. If you hit a Google Sheets quota block, your Claude Desktop agent will notify you in the chat.

Yes, once you share the target Google Sheets file with your credentials, Claude Desktop can read any cell range you specify using `get_sheet_values`. This allows Claude Desktop to pull private spreadsheet values directly into your chat.

Your Google Sheets cell values and metadata are processed through Claude Desktop using an ephemeral, zero-trust sandbox. The integration only accesses the specific Google Sheets files you explicitly share, keeping your spreadsheet data secure.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript