Model Context Protocol (MCP) server for Google Sheets API integration
MCP Gsheets becomes available to MCP clients through the MCP Gsheets. Model Context Protocol (MCP) server for Google Sheets API integration.
A Model Context Protocol (MCP) server for Google Sheets API integration. Enables reading, writing, and managing Google Sheets documents directly from your MCP client (e.g., Claude Code, Claude Desktop, Cursor, etc.).
Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.
Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.
| Tool | What it does |
|---|---|
| core | 11 |
| sheets | 9 |
| formatting | 15 |
| charts | 3 |
| tables | 4 |
| analysis | 2 |
| sheets_get_merged_cells | Return all merged cell ranges for a sheet, with A1 notation and raw GridRange coordinates |
| sheets_get_sheet_dimensions | Return column widths, row heights, frozen column/row counts, and hidden flags for every column and row |
| sheets_get_sheet_formatting | Read raw cell formatting (background colour, font, borders, alignment, number format) for a range without returning cell values |
| sheets_get_conditional_formatting | Read all conditional formatting rules and banded (alternating-colour) ranges defined on a sheet |
| sheets_get_sheet_structure | Lightweight structural metadata only — no per-cell data. Returns dimensions, frozen rows/cols, tab colour, column widths, row heights, hidden columns/rows, and all merges in A1 notation. Single fast API call |
| sheets_get_formatting_compact | Read cell formatting for a range and return it as compact A1Range→format pairs (run-length encoded). Identical adjacent cells are collapsed into rectangular ranges — reduces output by 90 %+ compared to per-cell data |
{
"mcpServers": {
"mcp-gsheets": {
"command": "npx",
"args": [
"-y",
"mcp-gsheets@latest"
],
"env": {
"GOOGLE_PROJECT_ID": "your-project-id",
"GOOGLE_APPLICATION_CREDENTIALS": "YOUR_GOOGLE_APPLICATION_CREDENTIALS"
}
}
}
}From the project documentation. Replace placeholders and example paths before connecting.
| Variable | Description | Required |
|---|---|---|
| GOOGLE_PROJECT_ID | Declared in the maintainer’s client configuration. | Optional |
| GOOGLE_APPLICATION_CREDENTIALS | Declared in the maintainer’s client configuration. | Check documentation |
Your assistant inside the workspace — read channels, search history, post messages and tame the noise.
Build a programmable telecommunications stack for connecting telephony services with the Internet via a cloud-based utility.
Inbox intelligence — search, read, draft and send Gmail through your assistant with OAuth auto-setup.
Read and write Jira, Confluence, Bitbucket, JSM and Compass from your AI client — with your own permissions.
Read and send Telegram messages through your assistant — chats, channels and history via the client API.
Enables Discord bot integration with Model Context Protocol (MCP) compatible applications like Claude Desktop.