Skip to content
VS Code

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

mcp gsheets in other clients