Google Sheets Advanced MCP Server

An MCP server that gives AI assistants full control over Google Sheets — not just read/write, but charts, pivot tables, formulas, formatting, and analytics.

What Makes This Different

Existing Google Sheets MCP servers only support basic CRUD (read cells, write cells). This server exposes the full Google Sheets API:

• 15 chart types — bar, line, pie, scatter, histogram, waterfall, and more
• Pivot tables — group, aggregate, cross-tabulate
• Conditional formatting — color scales, value-based rules, custom formulas
• Data validation — dropdowns, number constraints, checkboxes
• Server-side analytics — summary stats, trend analysis, duplicate detection
• 30 tools total — 9 free, 21 pro

Installation

npx mcp-google-sheets-advanced

Or install globally:

pnpm add -g mcp-google-sheets-advanced

Quick Start

Claude Desktop

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "google-sheets-advanced": {
      "command": "npx",
      "args": ["-y", "mcp-google-sheets-advanced"],
      "env": {
        "GOOGLE_CLIENT_ID": "your-client-id",
        "GOOGLE_CLIENT_SECRET": "your-secret"
      }
    }
  }
}

On first run, a browser window opens for Google OAuth authentication.

Available Tools

Free Tier (Read Operations)

| Tool | Description | | ----------------------------- | ----------------------------- | | sheets_list_spreadsheets | List accessible spreadsheets | | sheets_get_spreadsheet_info | Get spreadsheet metadata | | sheets_read_range | Read cell values from a range | | sheets_read_multiple_ranges | Batch read multiple ranges | | sheets_get_formulas | Get formulas from a range | | sheets_get_sheet_metadata | Get sheet properties | | sheets_list_named_ranges | List named ranges | | sheets_list_charts | List charts | | sheets_list_filter_views | List filter views |

Pro Tier ($16/mo)

| Tool | Description | | ----------------------------------- | ------------------------------------- | | sheets_write_range | Write values to a range | | sheets_write_multiple_ranges | Batch write to multiple ranges | | sheets_append_rows | Append rows to a table | | sheets_clear_range | Clear values from a range | | sheets_create_sheet | Add a new sheet | | sheets_delete_sheet | Delete a sheet | | sheets_create_chart | Create charts (15 types) | | sheets_update_chart | Modify existing charts | | sheets_delete_chart | Remove charts | | sheets_create_pivot_table | Create pivot tables | | sheets_add_conditional_formatting | Add conditional formatting | | sheets_set_data_validation | Set data validation rules | | sheets_format_cells | Format cells (fonts, colors, borders) | | sheets_summarize_range | Compute summary statistics | | sheets_find_duplicates | Find duplicate values | | sheets_analyze_trends | Analyze trends with linear regression | | sheets_create_named_range | Create named ranges | | sheets_sort_range | Sort data | | sheets_set_basic_filter | Apply/clear filters | | sheets_protect_range | Protect ranges | | sheets_find_replace | Find and replace |

Configuration

Required Environment Variables

| Variable | Description | | ---------------------- | ----------------------------------------- | | GOOGLE_CLIENT_ID | OAuth client ID from Google Cloud Console | | GOOGLE_CLIENT_SECRET | OAuth client secret |

Optional

| Variable | Description | Default | | ------------------- | -------------------------- | ----------------------------------- | | GOOGLE_TOKEN_PATH | Path to store OAuth tokens | ~/.config/mcp-gsheets/tokens.json |

Development

# Install dependencies
pnpm install

# Run in development mode
pnpm dev

# Build
pnpm build

# Run tests
pnpm test

# Type check
pnpm typecheck

# Test with MCP Inspector
pnpm inspect

License

MIT