Install Google Sheets MCP Server in Goose

What you need first

• Goose, installed.
• Nothing else: the server runs on its publisher's machines and Goose connects to it.
• Your own values for YOUR_AUTHORIZATION,YOUR_X_GOOGLE_SERVICE_ACCOUNT_KEY.

Steps

1. Open ~/.config/goose/config.yaml. On Windows it is %APPDATA%\Block\goose\config\config.yaml.
2. Add this entry. If the file already has extensions, add only the entry inside it.

extensions:
  "google-sheets-mcp":
    type: streamable_http
    name: "google-sheets-mcp"
    enabled: true
    uri: "https://oldjard--google-sheets-mcp.apify.actor/mcp"
    headers: { "Authorization": "YOUR_AUTHORIZATION", "X-Google-Service-Account-Key": "YOUR_X_GOOGLE_SERVICE_ACCOUNT_KEY" }
    env_keys: []
    envs: {}
    timeout: 300

3. Replace YOUR_AUTHORIZATION,YOUR_X_GOOGLE_SERVICE_ACCOUNT_KEY with your own values.
4. Save the file and start a new Goose session.

Check it worked

Ask Goose: List the tools of google-sheets-mcp.

If it does not start

401 Unauthorized

The endpoint wants a sign-in or a key. Sign in when Goose asks, or check the value in place of the placeholder.

The server starts, but its tools fail

A YOUR_… placeholder is still in the config, or its value is wrong.

Nothing changes after a restart

The file is not valid YAML any more. Check that the entry is indented like the lines around it.