Provides full control over Google Sheets—read/write, charts, pivot tables, formulas, formatting, and analytics via the Google Sheets API.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type @ followed by the MCP server name and your instructions, e.g., "@Google Sheets Advanced MCP Server Create a bar chart from sales data in Sheet1"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
An MCP server that gives AI assistants full control over Google Sheets — not just read/write, but charts, pivot tables, formulas, formatting, and analytics.
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
npx mcp-google-sheets-advancedOr install globally:
pnpm add -g mcp-google-sheets-advancedAdd 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.
Tool | Description |
| List accessible spreadsheets |
| Get spreadsheet metadata |
| Read cell values from a range |
| Batch read multiple ranges |
| Get formulas from a range |
| Get sheet properties |
| List named ranges |
| List charts |
| List filter views |
Tool | Description |
| Write values to a range |
| Batch write to multiple ranges |
| Append rows to a table |
| Clear values from a range |
| Add a new sheet |
| Delete a sheet |
| Create charts (15 types) |
| Modify existing charts |
| Remove charts |
| Create pivot tables |
| Add conditional formatting |
| Set data validation rules |
| Format cells (fonts, colors, borders) |
| Compute summary statistics |
| Find duplicate values |
| Analyze trends with linear regression |
| Create named ranges |
| Sort data |
| Apply/clear filters |
| Protect ranges |
| Find and replace |
Variable | Description |
| OAuth client ID from Google Cloud Console |
| OAuth client secret |
Variable | Description | Default |
| Path to store OAuth tokens |
|
# 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 inspectMIT
This server cannot be deployed
Connect AI assistants to Google Sheets through controlled tools for reading and updating rows.
Multiple Gmail accounts, editable Google Sheets & Docs for AI agents. Deny-by-default access rules.
AI access to Quadratic spreadsheets: open files, run Python/SQL, query connected databases.
Create and manage documents, spreadsheets, and presentations from your AI assistant.
