Skip to content
mcp/harbor
VS Code

Google Sheets for VS Code

io.github.domdomegg/google-sheets-mcp

Allow AI systems to read, write, and query spreadsheet data via Google Sheets.

client:VS Code transport:stdio runtime:npm

Install Google Sheets in VS Code

.vscode/mcp.json 

{
  "inputs": [
    {
      "type": "promptString",
      "id": "google-access-token",
      "description": "GOOGLE_ACCESS_TOKEN",
      "password": true
    }
  ],
  "servers": {
    "google-sheets-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "google-sheets-mcp"
      ],
      "env": {
        "GOOGLE_ACCESS_TOKEN": "${input:google-access-token}"
      }
    }
  }
}

VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs

Google Sheets in other clients

Google Sheets MCP server