freema/mcp-gsheets

Overview

Connects Claude Desktop to Google Sheets with a wide set of actions, reading, writing, inserting rows, creating new sheets, and more, so you can manage a spreadsheet by describing what you want instead of clicking through menus. It covers the operations most small businesses actually use a spreadsheet for: tracking data, building simple workflows, and keeping shared sheets current. A solid pick if you want more spreadsheet control than a bare read and write connector.

Best for

Best for
Small businesses that want fuller spreadsheet control through Claude

Use cases

• Add or update data in a shared spreadsheet from a plain-English request
• Create a new sheet or tab to track a new project
• Query spreadsheet data to inform a decision or answer a question
• Build a simple recurring workflow that reads from and writes to a sheet

How to use

Install

claude mcp add mcp-gsheets npx mcp-gsheets@latest

Tools exposed

• sheets_get_values
• sheets_batch_get_values
• sheets_get_metadata
• sheets_check_access
• sheets_update_values
• sheets_batch_update_values
• sheets_append_values
• sheets_clear_values
• sheets_insert_rows
• sheets_delete_columns
• sheets_delete_rows
• sheets_insert_link
• sheets_insert_date
• sheets_create_spreadsheet
• sheets_insert_sheet
• sheets_delete_sheet
• sheets_duplicate_sheet
• sheets_copy_to
• sheets_update_sheet_properties
• sheets_batch_delete_sheets

Tested with

Claude Desktop, Claude Code, Cursor, Cline

Example client config

{\n  "mcpServers": {\n    "mcp-gsheets": {\n      "command": "npx",\n      "args": ["-y", "mcp-gsheets@latest"],\n      "env": {\n        "GOOGLE_PROJECT_ID": "your-project-id",\n        "GOOGLE_APPLICATION_CREDENTIALS": "/absolute/path/to/service-account-key.json"\n      }\n    }\n  }\n}

Notes

An MCP server that lets Claude Desktop read, write, and manipulate Google Sheets. It uses TypeScript and exposes spreadsheet operations as tools for the AI assistant.

69 stars on GitHub. Last updated 2026-05-12. Licensed MIT.

Use cases

• Automating data entry and updates in Google Sheets from Claude conversations
• Querying spreadsheet data to inform AI responses or analysis
• Building simple workflows that read from or write to shared sheets

Pros

• Direct integration with Claude Desktop for spreadsheet tasks
• Open source with a permissive license for customization
• Lightweight and focused on a single, well-defined capability

Cons

• Limited to Google Sheets only, no other spreadsheet formats
• Requires Claude Desktop and MCP setup, not a standalone tool
• Relatively small community and few stars, may have limited support

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.