MCP Gsheets runs on your own machine — the client starts it, so there is no endpoint to ping. 6 236 installs a week from npm. Last commit 25 Oct 2026.
MCP server for Google Sheets API — read, write, format, batch operations.
Nothing serious here today
Today is the operative word: we check MCP Gsheets every 15 minutes and re-read its code on every release. Watch it and you find out the day that stops being true.
Connect this server
This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.
claude mcp add mcp-gsheets -e 'GOOGLE_PROJECT_ID=<GOOGLE_PROJECT_ID>' -- npx -y mcp-gsheets{
"mcpServers": {
"mcp-gsheets": {
"command": "npx",
"args": [
"-y",
"mcp-gsheets"
],
"env": {
"GOOGLE_PROJECT_ID": "<GOOGLE_PROJECT_ID>"
}
}
}
}[mcp_servers.mcp-gsheets]
command = "npx"
args = ["-y", "mcp-gsheets"]
env = { GOOGLE_PROJECT_ID = "<GOOGLE_PROJECT_ID>" }{
"mcpServers": {
"mcp-gsheets": {
"command": "npx",
"args": [
"-y",
"mcp-gsheets"
],
"env": {
"GOOGLE_PROJECT_ID": "<GOOGLE_PROJECT_ID>"
}
}
}
}{
"servers": {
"mcp-gsheets": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"mcp-gsheets"
],
"env": {
"GOOGLE_PROJECT_ID": "<GOOGLE_PROJECT_ID>"
}
}
}
}Put your own value in place of
<GOOGLE_PROJECT_ID> (Google Cloud project ID).
The author’s registry entry marks it as required.
Optional settings from the registry entry, left out of the block above:
GOOGLE_APPLICATION_CREDENTIALS (Path to service account key JSON file (auth method 1)), GOOGLE_SERVICE_ACCOUNT_KEY (Service account key as JSON string (auth method 2)), GOOGLE_PRIVATE_KEY (Service account private key in PEM format (auth method 3)), GOOGLE_CLIENT_EMAIL (Service account email (auth method 3)).
Alternatives to MCP Gsheets
same job, measured the same wayMCP server for the Google Sheets API: read and write ranges, sheets, formatting, charts, sharing.
Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting
MCP server for the Google Forms API: create forms, manage questions, read responses and watches.
MCP server for web search operations
MCP server for remote filesystem operations on cloud storage (Google Cloud Storage).
MCP server for Google search results via SERP API
Google Keep-style notes app with an MCP server for AI agents to read/write notes.
Google Search Console MCP server: 20 read tools, no write tools.
MCP Gsheets — questions
Answers built from our own checks of this server.