Google Sheets MCP for VS Code
io.github.a1-x-tech/mcp-google-sheets
MCP server for the Google Sheets API: read and write ranges, sheets, formatting, charts, sharing.
client:VS Code
transport:stdio
runtime:npm
Install Google Sheets MCP in VS Code
.vscode/mcp.json
{
"inputs": [
{
"type": "promptString",
"id": "google-sheets-client-id",
"description": "GOOGLE_SHEETS_CLIENT_ID",
"password": true
},
{
"type": "promptString",
"id": "google-sheets-client-secret",
"description": "GOOGLE_SHEETS_CLIENT_SECRET",
"password": true
},
{
"type": "promptString",
"id": "google-sheets-refresh-token",
"description": "GOOGLE_SHEETS_REFRESH_TOKEN",
"password": true
},
{
"type": "promptString",
"id": "google-sheets-access-token",
"description": "GOOGLE_SHEETS_ACCESS_TOKEN",
"password": true
},
{
"type": "promptString",
"id": "google-sheets-oauth-port",
"description": "GOOGLE_SHEETS_OAUTH_PORT",
"password": true
},
{
"type": "promptString",
"id": "google-sheets-api-base",
"description": "GOOGLE_SHEETS_API_BASE",
"password": true
},
{
"type": "promptString",
"id": "google-sheets-timeout-ms",
"description": "GOOGLE_SHEETS_TIMEOUT_MS",
"password": true
},
{
"type": "promptString",
"id": "google-sheets-max-retries",
"description": "GOOGLE_SHEETS_MAX_RETRIES",
"password": true
}
],
"servers": {
"mcp-google-sheets": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@a1-x-tech/mcp-google-sheets"
],
"env": {
"GOOGLE_SHEETS_CLIENT_ID": "${input:google-sheets-client-id}",
"GOOGLE_SHEETS_CLIENT_SECRET": "${input:google-sheets-client-secret}",
"GOOGLE_SHEETS_REFRESH_TOKEN": "${input:google-sheets-refresh-token}",
"GOOGLE_SHEETS_ACCESS_TOKEN": "${input:google-sheets-access-token}",
"GOOGLE_SHEETS_OAUTH_PORT": "${input:google-sheets-oauth-port}",
"GOOGLE_SHEETS_API_BASE": "${input:google-sheets-api-base}",
"GOOGLE_SHEETS_TIMEOUT_MS": "${input:google-sheets-timeout-ms}",
"GOOGLE_SHEETS_MAX_RETRIES": "${input:google-sheets-max-retries}"
}
}
}
}
VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs