Skip to main content
Glama
vic08

Google Sheets Advanced MCP Server

by vic08
OverviewSchemaRelated ServersScoreDiscussions
TypeScript
Remote

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

Related MCP server: Google Sheets MCP Server

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

This server cannot be installed

A
license - permissive license
-
quality - not tested
D
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/vic08/mcp-google-sheets-advanced'

If you have feedback or need assistance with the MCP directory API, please join our Discord server