Google Sheets Advanced Server

БесплатноНе проверен

Enables AI assistants to fully control Google Sheets, including charts, pivot tables, formulas, formatting, and analytics, beyond basic read/write operations.

автор: vic08

GitHub Embed

Описание

Enables AI assistants to fully control Google Sheets, including charts, pivot tables, formulas, formatting, and analytics, beyond basic read/write operations.

README

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

from github.com/vic08/mcp-google-sheets-advanced

Установить Google Sheets Advanced Server в Claude Desktop, Claude Code, Cursor

Рекомендуется · одна команда, все IDE

unyly install google-sheets-advanced-mcp-server

Ставит в Claude Desktop, Claude Code, Cursor и VS Code — сам разбирается с npx, uvx и сборкой из исходников.

Впервые? Поставь CLI: curl -fsSL https://unyly.org/install | sh

Или настроить вручную

Выполни в терминале:

claude mcp add google-sheets-advanced-mcp-server -- npx -y @vic08/mcp-google-sheets-advanced

FAQ