Google Sheets Advanced Server

FreeNot checked

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

by vic08

GitHub Embed

About

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

Install Google Sheets Advanced Server in Claude Desktop, Claude Code & Cursor

Recommended · one command, every IDE

unyly install google-sheets-advanced-mcp-server

Installs into Claude Desktop, Claude Code, Cursor & VS Code — handles npx, uvx and build-from-source repos for you.

First time? Get the CLI: curl -fsSL https://unyly.org/install | sh

Or configure manually

Run in your terminal:

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

FAQ

Is Google Sheets Advanced Server MCP free?

Yes, Google Sheets Advanced Server MCP is free — one-click install via Unyly at no cost.

Does Google Sheets Advanced Server need an API key?

No, Google Sheets Advanced Server runs without API keys or environment variables.

Is Google Sheets Advanced Server hosted or self-hosted?

A hosted option is available: Unyly runs the server in the cloud, no local setup required.

How do I install Google Sheets Advanced Server in Claude Desktop, Claude Code or Cursor?

Open Google Sheets Advanced Server on unyly.org, pick your client tab (Claude Desktop, Claude Code, Cursor) and press Install — the config is generated automatically, no JSON editing.

Related MCPs

Fetch

Web content fetching and conversion for efficient LLM usage.

by Community

AWS KB Retrieval

Retrieval from AWS Knowledge Base using Bedrock Agent Runtime.

by modelcontextprotocol

Spring AI MCP Server

Provides auto-configuration for setting up an MCP server in Spring Boot applications.