Google Apps Script MCP for VS Code

io.github.a1-x-tech/mcp-google-apps-script

MCP server for the Google Apps Script API: projects, code, versions, deployments and executions.

client:VS Code transport:stdio runtime:npm

Install Google Apps Script MCP in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "google-apps-script-client-id",
      "description": "GOOGLE_APPS_SCRIPT_CLIENT_ID",
      "password": true
    },
    {
      "type": "promptString",
      "id": "google-apps-script-client-secret",
      "description": "GOOGLE_APPS_SCRIPT_CLIENT_SECRET",
      "password": true
    },
    {
      "type": "promptString",
      "id": "google-apps-script-refresh-token",
      "description": "GOOGLE_APPS_SCRIPT_REFRESH_TOKEN",
      "password": true
    },
    {
      "type": "promptString",
      "id": "google-apps-script-access-token",
      "description": "GOOGLE_APPS_SCRIPT_ACCESS_TOKEN",
      "password": true
    },
    {
      "type": "promptString",
      "id": "google-apps-script-oauth-port",
      "description": "GOOGLE_APPS_SCRIPT_OAUTH_PORT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "google-apps-script-api-base",
      "description": "GOOGLE_APPS_SCRIPT_API_BASE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "google-apps-script-timeout-ms",
      "description": "GOOGLE_APPS_SCRIPT_TIMEOUT_MS",
      "password": true
    },
    {
      "type": "promptString",
      "id": "google-apps-script-max-retries",
      "description": "GOOGLE_APPS_SCRIPT_MAX_RETRIES",
      "password": true
    }
  ],
  "servers": {
    "mcp-google-apps-script": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-google-apps-script"
      ],
      "env": {
        "GOOGLE_APPS_SCRIPT_CLIENT_ID": "${input:google-apps-script-client-id}",
        "GOOGLE_APPS_SCRIPT_CLIENT_SECRET": "${input:google-apps-script-client-secret}",
        "GOOGLE_APPS_SCRIPT_REFRESH_TOKEN": "${input:google-apps-script-refresh-token}",
        "GOOGLE_APPS_SCRIPT_ACCESS_TOKEN": "${input:google-apps-script-access-token}",
        "GOOGLE_APPS_SCRIPT_OAUTH_PORT": "${input:google-apps-script-oauth-port}",
        "GOOGLE_APPS_SCRIPT_API_BASE": "${input:google-apps-script-api-base}",
        "GOOGLE_APPS_SCRIPT_TIMEOUT_MS": "${input:google-apps-script-timeout-ms}",
        "GOOGLE_APPS_SCRIPT_MAX_RETRIES": "${input:google-apps-script-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

Google Apps Script MCP in other clients

Google Apps Script MCP MCP server