mcp-google-sheets

129

cloud_platforms databases developer_tools

The `mcp-google-sheets` project serves as a gateway to seamlessly integrate AI with Google Sheets using a Python-based MCP server. It allows users to automate and manage their spreadsheet data effectively, facilitating integration with MCP-compatible clients for enhanced data workflows.

uvx

{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": [
        "mcp-google-sheets"
      ],
      "env": {
        "SERVICE_ACCOUNT_PATH": "/full/path/to/your/service-account-key.json",
        "DRIVE_FOLDER_ID": "your_shared_folder_id_here"
      },
      "healthcheck_url": "http://localhost:8000/health"
    }
  }
}

uvx

{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": [
        "mcp-google-sheets"
      ],
      "env": {
        "CREDENTIALS_PATH": "/full/path/to/your/credentials.json",
        "TOKEN_PATH": "/full/path/to/your/token.json"
      },
      "healthcheck_url": "http://localhost:8000/health"
    }
  }
}

uvx

{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": [
        "mcp-google-sheets"
      ],
      "env": {
        "CREDENTIALS_CONFIG": "ewogICJ0eXBlIjogInNlcnZpY2VfYWNjb3VudCIsCiAgInByb2plY3RfaWQiOiAi...",
        "DRIVE_FOLDER_ID": "your_shared_folder_id_here"
      },
      "healthcheck_url": "http://localhost:8000/health"
    }
  }
}

{
  "mcpServers": {
    "mcp-google-sheets-dev": {
      "command": "uv",
      "args": [
        "run",
        "mcp-google-sheets"
      ],
      "cwd": "/full/path/to/cloned/mcp-google-sheets",
      "env": {
        "SERVICE_ACCOUNT_PATH": "/full/path/to/cloned/mcp-google-sheets/service-account-key.json",
        "DRIVE_FOLDER_ID": "your_shared_folder_id_here"
      },
      "healthcheck_url": "http://localhost:8000/health",
      "disabled": false
    }
  }
}