Google Sheets MCP MCP Server
io.github.A1-x-Tech/mcp-google-sheets
What this kind of tool is for
- Query, inspect, or seed a database without writing a one-off script.
- Let your agent look up schema details before it writes migration code.
- Move a small dataset between tools without leaving the terminal.
How to compare servers like this
- Engine match:
- Confirm it speaks your exact database and version, not just the family.
- Access scope:
- Read-only connections are the safe default — start there before granting writes.
- Safety rails:
- Check whether destructive statements need an explicit confirmation before they run.
- Maintenance signal:
- Database drivers change; a recently updated tool is less likely to break mid-query.
This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.
What is the Google Sheets MCP MCP server?
MCP server for the Google Sheets API: read and write ranges, sheets, formatting, charts, sharing.
How to install Google Sheets MCP
Copy-paste configuration for popular MCP clients.
GOOGLE_SHEETS_CLIENT_IDGoogle OAuth2 client id (refresh-token flow).
GOOGLE_SHEETS_CLIENT_SECRETsecretGoogle OAuth2 client secret (refresh-token flow). Treat it as a secret.
GOOGLE_SHEETS_REFRESH_TOKENsecretGoogle OAuth2 refresh token, exchanged for access tokens automatically. Treat it as a secret.
GOOGLE_SHEETS_ACCESS_TOKENsecretStatic OAuth2 access token (~1h lifetime) — alternative to the refresh-token trio, mostly for testing.
GOOGLE_SHEETS_OAUTH_PORTFixed port for the loopback listener of the in-chat login (127.0.0.1 + PKCE). Set it when the client runs over SSH port forwarding; otherwise a free port is picked per login.
GOOGLE_SHEETS_API_BASESheets API root override.
GOOGLE_SHEETS_TIMEOUT_MSPer-request timeout in milliseconds.
GOOGLE_SHEETS_MAX_RETRIESRetries on transient errors (429 always; 5xx/network for reads).
{
"mcpServers": {
"mcp-google-sheets": {
"command": "npx",
"args": [
"-y",
"@a1-x-tech/mcp-google-sheets"
],
"env": {
"GOOGLE_SHEETS_CLIENT_ID": "<YOUR_GOOGLE_SHEETS_CLIENT_ID>",
"GOOGLE_SHEETS_CLIENT_SECRET": "<YOUR_GOOGLE_SHEETS_CLIENT_SECRET>",
"GOOGLE_SHEETS_REFRESH_TOKEN": "<YOUR_GOOGLE_SHEETS_REFRESH_TOKEN>",
"GOOGLE_SHEETS_ACCESS_TOKEN": "<YOUR_GOOGLE_SHEETS_ACCESS_TOKEN>",
"GOOGLE_SHEETS_OAUTH_PORT": "<YOUR_GOOGLE_SHEETS_OAUTH_PORT>",
"GOOGLE_SHEETS_API_BASE": "<YOUR_GOOGLE_SHEETS_API_BASE>",
"GOOGLE_SHEETS_TIMEOUT_MS": "<YOUR_GOOGLE_SHEETS_TIMEOUT_MS>",
"GOOGLE_SHEETS_MAX_RETRIES": "<YOUR_GOOGLE_SHEETS_MAX_RETRIES>"
}
}
}
}Related MCP servers

Google Slides MCP
MCP server for the Google Slides API: presentations, slides, text, shapes, images and tables.

Google Tag Manager MCP
MCP server for the Google Tag Manager API v2: containers, workspaces, tags, triggers, publishing.
MCP server for the Google Tasks API: task lists, subtasks, due dates, complete and move tasks.
View repository →
Shopify Admin MCP
MCP server for the Shopify Admin API: products, orders, customers, inventory, discounts.

Yandex Audience MCP
MCP server for Yandex Audience API: segments (CRM, lookalike, pixel), pixels, grants.

Yandex Delivery MCP
MCP server for the Yandex Delivery B2B API: express claims, tracking, NDD/pickup-point orders.