Provides full control over Google Sheets—read/write, charts, pivot tables, formulas, formatting, and analytics via the Google Sheets API.
Click on "Install 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 installed
Unclaimed servers have limited discoverability.
If you are the server author, to access and configure the admin panel.
SEO research, audits, backlinks, GSC, and content workflow tools for AI agents.
Provide AI assistants with real-time access to official SEC EDGAR filings and financial data. Enab…
Connect AI assistants to GitHub - manage repos, issues, PRs, and workflows through natural language.
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