x=hub

your toolset

    build deployment
    sign in

    Google Sheets

    mcpkey · package no repo
    io.github.mcp-z/mcp-sheets · v2.4.2
    deploy just this

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

    run it

    on your own machines, one way per deploy method
    generated from the record, not tested yet
    #!/usr/bin/env bash
# sheets (io.github.mcp-z/mcp-sheets), recipe baremetal (generated).
# Generated by Hub for toolset "my-agent"; started by mcp-my-agent-sheets.service.
set -euo pipefail
export HOST=127.0.0.1 PORT=8101
exec npx -y supergateway@4 --stdio 'npx -y @mcp-z/[email protected]' --outputTransport streamableHttp --stateful --host 127.0.0.1 --port 8101 --streamableHttpPath /mcp --healthEndpoint /healthz

[Unit]
Description=MCP server sheets (toolset my-agent), generated by Hub
After=network-online.target
Wants=network-online.target

[Service]
Type=simple
User=mcp
Group=mcp
EnvironmentFile=/etc/mcp/my-agent.env
Environment=HOME=/var/lib/mcp/sheets
WorkingDirectory=/var/lib/mcp/sheets
ExecStart=/opt/mcp/my-agent/bin/sheets.sh
Restart=on-failure
RestartSec=5
NoNewPrivileges=true
ProtectSystem=strict
ProtectHome=true
PrivateTmp=true
ReadWritePaths=/var/lib/mcp/sheets

[Install]
WantedBy=multi-user.target
    generated from the record, not tested yet
    docker run --rm -p 127.0.0.1:8101:8000 -e GOOGLE_CLIENT_ID -e GOOGLE_CLIENT_SECRET -e GOOGLE_SERVICE_ACCOUNT_KEY_FILE -e AUTH_MODE -e HEADLESS -e REDIRECT_URI -e RESOURCE_STORE_URI -e PORT -e BASE_URL -e LOG_LEVEL node:22-alpine sh -c 'npx -y supergateway@4 --stdio '"'"'npx -y @mcp-z/[email protected]'"'"' --outputTransport streamableHttp --stateful --host 0.0.0.0 --port 8000 --streamableHttpPath /mcp --healthEndpoint /healthz'
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-18T12:15:16+00:00).
# Each package server runs behind a stdio->HTTP bridge and listens on localhost only.
#   cp .env.example .env    # fill the ${VAR}s
#   docker compose up -d && bash smoke.sh
# Remote servers are not here: clients reach them directly (see clients/).
name: mcp-my-agent
services:
  sheets:
    image: node:22-alpine
    command:
    - sh
    - -c
    - npx -y supergateway@4 --stdio 'npx -y @mcp-z/[email protected]' --outputTransport streamableHttp
      --stateful --host 0.0.0.0 --port 8000 --streamableHttpPath /mcp --healthEndpoint /healthz
    ports:
    - 127.0.0.1:8101:8000
    volumes:
    - npm-cache:/root/.npm
    healthcheck:
      test:
      - CMD-SHELL
      - wget -qO- http://127.0.0.1:8000/healthz || exit 1
      interval: 30s
      timeout: 5s
      retries: 5
      start_period: 2m
    restart: unless-stopped
    environment:
      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}
volumes:
  npm-cache: {}
  uv-cache: {}
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-18T12:15:16+00:00).
#   kubectl create namespace mcp
#   kubectl -n mcp create secret generic mcp-credentials --from-env-file=.env
#   kubectl apply -f kubernetes.yaml
# Services are cluster-internal: <name>.mcp.svc.cluster.local:8000/mcp. Put an ingress
# with auth in front before exposing any of them.
apiVersion: v1
kind: Namespace
metadata:
  name: mcp
---
apiVersion: apps/v1
kind: Deployment
metadata:
  name: sheets
  namespace: mcp
  labels: &id001
    app: sheets
spec:
  replicas: 1
  selector:
    matchLabels: *id001
  template:
    metadata:
      labels: *id001
    spec:
      containers:
      - name: sheets
        image: node:22-alpine
        ports:
        - containerPort: 8000
          name: http
        env:
        - name: GOOGLE_CLIENT_ID
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: GOOGLE_CLIENT_ID
        - name: GOOGLE_CLIENT_SECRET
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: GOOGLE_CLIENT_SECRET
        - name: GOOGLE_SERVICE_ACCOUNT_KEY_FILE
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: GOOGLE_SERVICE_ACCOUNT_KEY_FILE
        - name: AUTH_MODE
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: AUTH_MODE
        - name: HEADLESS
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: HEADLESS
        - name: REDIRECT_URI
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: REDIRECT_URI
        - name: RESOURCE_STORE_URI
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: RESOURCE_STORE_URI
        - name: PORT
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: PORT
        - name: BASE_URL
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: BASE_URL
        - name: LOG_LEVEL
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: LOG_LEVEL
        command:
        - sh
        - -c
        - npx -y supergateway@4 --stdio 'npx -y @mcp-z/[email protected]' --outputTransport streamableHttp
          --stateful --host 0.0.0.0 --port 8000 --streamableHttpPath /mcp --healthEndpoint /healthz
        readinessProbe:
          httpGet:
            path: /healthz
            port: http
          initialDelaySeconds: 10
---
apiVersion: v1
kind: Service
metadata:
  name: sheets
  namespace: mcp
spec:
  selector:
    app: sheets
  ports:
  - port: 8000
    targetPort: http
    name: http
    generated from the record, not tested yet
    # Generated by Hub for toolset "my-agent" (2026-10-18T12:15:16+00:00).
# Credentials come from the Secret 'mcp-credentials' (kubectl create secret generic ... --from-env-file=.env).
# Each server under `servers` is one Deployment + Service; the keys after it configure
# upstream charts a worker verified.
servers:
  sheets:
    enabled: true
    replicas: 1
    port: 8000
    path: /mcp
    container:
      name: sheets
      image: node:22-alpine
      ports:
      - containerPort: 8000
        name: http
      env:
      - name: GOOGLE_CLIENT_ID
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: GOOGLE_CLIENT_ID
      - name: GOOGLE_CLIENT_SECRET
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: GOOGLE_CLIENT_SECRET
      - name: GOOGLE_SERVICE_ACCOUNT_KEY_FILE
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: GOOGLE_SERVICE_ACCOUNT_KEY_FILE
      - name: AUTH_MODE
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: AUTH_MODE
      - name: HEADLESS
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: HEADLESS
      - name: REDIRECT_URI
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: REDIRECT_URI
      - name: RESOURCE_STORE_URI
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: RESOURCE_STORE_URI
      - name: PORT
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: PORT
      - name: BASE_URL
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: BASE_URL
      - name: LOG_LEVEL
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: LOG_LEVEL
      command:
      - sh
      - -c
      - npx -y supergateway@4 --stdio 'npx -y @mcp-z/[email protected]' --outputTransport streamableHttp
        --stateful --host 0.0.0.0 --port 8000 --streamableHttpPath /mcp --healthEndpoint /healthz
      readinessProbe:
        httpGet:
          path: /healthz
          port: http
        initialDelaySeconds: 10

# helm install my-agent helm/my-agent -n mcp

    in the cloud

    one click: the provider's deploy form opens filled in, in your own account
    koyeb
    deploy to koyeb

    The form opens with CHANGE_ME for each value you supply: GOOGLE_CLIENT_ID, GOOGLE_CLIENT_SECRET, GOOGLE_SERVICE_ACCOUNT_KEY_FILE, AUTH_MODE, HEADLESS, REDIRECT_URI, RESOURCE_STORE_URI, PORT, BASE_URL, LOG_LEVEL. Fill them in before you deploy.

    Clients connect to the service's https://…koyeb.app address plus /mcp.

    azure
    deploy to azuretemplate

    A Container Apps environment with one app per server, each with HTTPS ingress and one replica. The portal asks for each value you supply as a secure parameter; the deployment's outputs list the endpoints.

    connect to it

    copy what your client needs
    npx -y @mcp-z/[email protected]
# env: GOOGLE_CLIENT_ID, GOOGLE_CLIENT_SECRET, GOOGLE_SERVICE_ACCOUNT_KEY_FILE, AUTH_MODE, HEADLESS, REDIRECT_URI, RESOURCE_STORE_URI, PORT, BASE_URL, LOG_LEVEL
    {
  "mcpServers": {
    "sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/[email protected]"
      ],
      "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}"
      }
    }
  }
}
    #!/usr/bin/env bash
# Registers every server with Claude Code (run once; `claude mcp list` to check).
set -euo pipefail
set -a; [ -f .env ] && source .env; set +a
claude mcp add sheets -e "GOOGLE_CLIENT_ID=${GOOGLE_CLIENT_ID}" -e "GOOGLE_CLIENT_SECRET=${GOOGLE_CLIENT_SECRET}" -e "GOOGLE_SERVICE_ACCOUNT_KEY_FILE=${GOOGLE_SERVICE_ACCOUNT_KEY_FILE}" -e "AUTH_MODE=${AUTH_MODE}" -e "HEADLESS=${HEADLESS}" -e "REDIRECT_URI=${REDIRECT_URI}" -e "RESOURCE_STORE_URI=${RESOURCE_STORE_URI}" -e "PORT=${PORT}" -e "BASE_URL=${BASE_URL}" -e "LOG_LEVEL=${LOG_LEVEL}" -- npx -y @mcp-z/[email protected]

    {
  "mcpServers": {
    "sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/[email protected]"
      ],
      "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}"
      }
    }
  }
}
    {
  "servers": {
    "sheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/[email protected]"
      ],
      "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}"
      }
    }
  }
}
    name: my-agent
target: local
servers:
- hub: io.github.mcp-z/mcp-sheets
    • trust flag: no_repo
    • not probed yet: tools unpinned, ingest lists them

    tools

    Not probed yetThe tools appear once the hub or its worker has listed this entry. Running it still works: your client lists them on first start.