Turn Claude Desktop into Your Google Sheets Power User

Stop switching between Claude and Google Sheets. This MCP server brings full spreadsheet manipulation directly into your Claude Desktop conversation—no more copy-pasting data or writing one-off scripts.

The Problem with Sheet Workflows

You're analyzing data in Claude, then manually copying results back to Google Sheets. Or writing custom scripts every time you need to update a report. Or worse—asking Claude to generate formulas that you then manually paste into cells.

Meanwhile, your spreadsheets sit disconnected from your AI workflow, creating friction every time you need to move data between analysis and storage.

What You Get Instead

Complete Google Sheets integration that lets Claude read, write, format, and manage your spreadsheets directly. Think of it as giving Claude hands to manipulate your data where it lives.

The full toolkit:

• Data Operations: Read ranges, batch updates, append rows, clear sections
• Sheet Management: Create/delete/duplicate sheets, copy between spreadsheets
• Visual Formatting: Cell colors, fonts, alignment, number formats, borders
• Advanced Features: Merge cells, conditional formatting rules, metadata access

Real Scenarios Where This Shines

Financial Reporting: "Claude, update our monthly P&L sheet with this new data, format the variance column to highlight negative values in red, and add a summary row at the bottom."

Data Analysis Workflows: Process a CSV in Claude, then directly write the cleaned results to your master spreadsheet with proper formatting—all in one conversation.

Report Generation: "Take this week's sales data, create a new sheet called 'Weekly Analysis', and build a formatted table with conditional formatting for performance indicators."

Bulk Operations: Update hundreds of rows across multiple sheets based on complex logic without writing a single script.

Setup That Actually Works

The interactive setup script handles the tedious parts automatically:

• Detects your Node.js installation (even with nvm)
• Finds your Claude Desktop config location
• Walks you through Google Cloud service account setup
• Creates proper JSON configuration

npm run setup

That's it. No hunting through documentation or debugging config paths.

Integration Points

This slots directly into your existing data workflows:

For Analysis: Pull sheet data into Claude conversations, analyze it, then write results back with formatting For Automation: Set up recurring data updates without cron jobs or cloud functions
For Reporting: Generate formatted reports that live-update in shared spreadsheets For Data Cleaning: Process messy data in Claude, then store clean versions with proper structure

Why This Beats Alternatives

Instead of managing Google Apps Script, Zapier workflows, or custom API integrations, you get spreadsheet manipulation as a natural part of your Claude conversations. No context switching, no separate tools to maintain.

The comprehensive API coverage means you're not limited to basic read/write operations. Need conditional formatting? Cell merging? Multi-sheet operations? It's all available through natural language requests to Claude.

Getting Started

1. Install: git clone and npm install, or grab from npm
2. Google Setup: Enable Sheets API, create service account, download JSON key
3. Configure: Run npm run setup for guided configuration
4. Test: Share a spreadsheet with your service account email and start manipulating it through Claude

The repository includes comprehensive troubleshooting docs for common authentication and permission issues—because nobody wants to debug Google Cloud IAM when they're trying to update a spreadsheet.

Ready to eliminate the friction between your AI workflows and your data storage? Your spreadsheets are about to become a lot more intelligent.