mcp gsheets for VS Code
io.github.freema/mcp-gsheets
MCP server for Google Sheets API — read, write, format, batch operations.
client:VS Code
transport:stdio
runtime:npm
Install mcp gsheets in VS Code
.vscode/mcp.json
{
"inputs": [
{
"type": "promptString",
"id": "google-project-id",
"description": "GOOGLE_PROJECT_ID",
"password": true
},
{
"type": "promptString",
"id": "google-application-credentials",
"description": "GOOGLE_APPLICATION_CREDENTIALS",
"password": true
},
{
"type": "promptString",
"id": "google-service-account-key",
"description": "GOOGLE_SERVICE_ACCOUNT_KEY",
"password": true
},
{
"type": "promptString",
"id": "google-private-key",
"description": "GOOGLE_PRIVATE_KEY",
"password": true
},
{
"type": "promptString",
"id": "google-client-email",
"description": "GOOGLE_CLIENT_EMAIL",
"password": true
}
],
"servers": {
"mcp-gsheets": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"mcp-gsheets"
],
"env": {
"GOOGLE_PROJECT_ID": "${input:google-project-id}",
"GOOGLE_APPLICATION_CREDENTIALS": "${input:google-application-credentials}",
"GOOGLE_SERVICE_ACCOUNT_KEY": "${input:google-service-account-key}",
"GOOGLE_PRIVATE_KEY": "${input:google-private-key}",
"GOOGLE_CLIENT_EMAIL": "${input:google-client-email}"
}
}
}
}
VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs