mcpField
G

Google Sheets

Local
github.comProductivity
Visit website

About Google Sheets

Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

mcp.json · Universal config
{
  "mcpServers": {
    "z-mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>",
        "GOOGLE_SERVICE_ACCOUNT_KEY_FILE": "<GOOGLE_SERVICE_ACCOUNT_KEY_FILE>",
        "AUTH_MODE": "<AUTH_MODE>",
        "HEADLESS": "<HEADLESS>",
        "REDIRECT_URI": "<REDIRECT_URI>",
        "RESOURCE_STORE_URI": "<RESOURCE_STORE_URI>",
        "PORT": "<PORT>",
        "BASE_URL": "<BASE_URL>",
        "LOG_LEVEL": "<LOG_LEVEL>",
        "DCR_MODE": "<DCR_MODE>",
        "DCR_VERIFY_URL": "<DCR_VERIFY_URL>",
        "DCR_STORE_URI": "<DCR_STORE_URI>"
      }
    }
  }
}
Run commandnpx -y @mcp-z/mcp-sheets
Environment variables to set
GOOGLE_CLIENT_IDGoogle OAuth client ID (required for OAuth authentication modes)
GOOGLE_CLIENT_SECRETSecretGoogle OAuth client secret (optional for public clients)
GOOGLE_SERVICE_ACCOUNT_KEY_FILESecretPath to service account JSON key file (required for service-account auth mode)
AUTH_MODESecretAuthentication mode
HEADLESSDisable browser auto-open, return auth URL instead (true/false)
REDIRECT_URIOAuth redirect URI (optional, default: ephemeral loopback)
RESOURCE_STORE_URIResource store URI for exported files (file://)
PORTHTTP server port (overrides --port)
BASE_URLBase URL for HTTP transport (used for OAuth/DCR endpoints and file links)
LOG_LEVELLogging level
DCR_MODEDynamic Client Registration mode
DCR_VERIFY_URLExternal verification endpoint URL (required for external DCR mode)
DCR_STORE_URIDCR client storage URI (for self-hosted DCR mode)

Local servers need a runtime on your machine (e.g. Node.js 18+). Config file locations differ by client; see your client’s docs.

Packages
npm@mcp-z/mcp-sheets2.4.2

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

The maintainer has not added details yet. Check the README in the repository.

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.