google-sheets-mcp

micahyee415/google-sheets-mcp
★ 0 stars TypeScript 🔒 Security Updated today
Model Context Protocol (MCP) server for Google Sheets (read + write) with per-user Google OAuth, a write allowlist, and audit logging.
View on GitHub → Try with Claude — $10 free →

Quick Install

Copy the config for your editor. Some servers may need additional setup — check the README.

Add to claude_desktop_config.json:

{
  "mcpServers": {
    "google-sheets-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "micahyee415/google-sheets-mcp"
      ]
    }
  }
}

README Excerpt

> A Model Context Protocol (MCP) server for Google Sheets (read + write), deployed on Google Cloud Run. --- `gsheets-mcp` exposes Google Sheets and Google Drive as MCP tools so an AI assistant (e.g. Claude.ai) can read, write, search, and compare spreadsheets on behalf of authenticated users. Key design decisions:

Tools (20)

ALLOWED_DOMAINBULK_WRITE_ALERT_USER_IDBULK_WRITE_THRESHOLD_ROWSGOOGLE_CLIENT_IDGOOGLE_CLIENT_SECRETPORTSERVER_URLSLACK_BOT_TOKENadd_columnsadd_rowsappend_rowsbatch_update_cellscompare_sheetscreate_sheetcreate_spreadsheetfind_in_spreadsheetget_multiple_sheet_dataget_multiple_spreadsheet_summaryget_sheet_dataget_sheet_formulas

Topics

cloud-rungoogle-oauthgoogle-sheetsmcpmodel-context-protocoltypescript