@renzo.johnson/google-sheets-mcp
v26.11.15
Published
Google Sheets MCP server for Claude Code, Cursor and any MCP client. Read and edit Google Sheets. mcprush.com-3fd3e1ed9b412b32b4e5e888
Maintainers
Readme
Google Sheets MCP
Google Sheets MCP server for Claude Code, Cursor and any MCP client. Read and edit Google Sheets.
npx -y @renzo.johnson/google-sheets-mcpThe server speaks MCP over stdio. It needs Node.js 22 or newer. Prefer VS Code? Install the Google Sheets MCP extension: it signs you in with a wizard and registers the server with 8 AI agents.
Sign in
The server uses the first credential it finds:
- An OAuth user: set
GOOGLE_OAUTH_CLIENT_ID,GOOGLE_OAUTH_CLIENT_SECRETandGOOGLE_OAUTH_REFRESH_TOKEN. Set all three or none; a partial set stops the server with an error naming what is missing. GOOGLE_APPLICATION_CREDENTIALS: path to a service-account key or anauthorized_userJSON file.- Application Default Credentials from the gcloud CLI:
gcloud auth application-default login --scopes=https://www.googleapis.com/auth/spreadsheets,https://www.googleapis.com/auth/spreadsheets.readonlyThe OAuth refresh token (or service account) needs these scopes:
https://www.googleapis.com/auth/spreadsheetshttps://www.googleapis.com/auth/spreadsheets.readonly
Claude Code
Add it from the command line:
claude mcp add google-sheets-mcp -- npx -y @renzo.johnson/google-sheets-mcpOr add it to .mcp.json in your project (or ~/.claude.json for every project).
Cursor
Add it to ~/.cursor/mcp.json (or .cursor/mcp.json in a project).
Configuration
Claude Code and Cursor use the same JSON shape:
With Application Default Credentials (gcloud):
{
"mcpServers": {
"google-sheets-mcp": {
"command": "npx",
"args": [
"-y",
"@renzo.johnson/google-sheets-mcp"
]
}
}
}With an OAuth user:
{
"mcpServers": {
"google-sheets-mcp": {
"command": "npx",
"args": [
"-y",
"@renzo.johnson/google-sheets-mcp"
],
"env": {
"GOOGLE_OAUTH_CLIENT_ID": "your-client-id.apps.googleusercontent.com",
"GOOGLE_OAUTH_CLIENT_SECRET": "your-client-secret",
"GOOGLE_OAUTH_REFRESH_TOKEN": "your-refresh-token"
}
}
}
}With a service-account key:
{
"mcpServers": {
"google-sheets-mcp": {
"command": "npx",
"args": [
"-y",
"@renzo.johnson/google-sheets-mcp"
],
"env": {
"GOOGLE_APPLICATION_CREDENTIALS": "/path/to/service-account.json"
}
}
}
}Available Tools (3)
Sheets (1 tool)
| Tool | What It Does | Example Prompt |
|------|-------------|----------------|
| sheets_read | Read cell data or sheet metadata | "Show me the data in Sheet1!A1:D10" |
Sheets Admin (mega-tool)
| Action | Description |
|--------|-------------|
| create | Create a new spreadsheet |
| append_rows | Add rows to a sheet |
| update_cells | Update cell values |
| add_sheet | Add a new sheet tab |
| delete_sheet | Delete a sheet tab (requires confirm) |
| clear_range | Clear a cell range (requires confirm) |
Safety
Destructive actions (delete, trash, clear) require confirm: true to execute. The AI agent will be warned and must explicitly confirm before proceeding.
Privacy
The server sends no telemetry. It talks only to Google APIs, with your own credentials.
Links
By Renzo Johnson | MIT License
