KosmoKrator

productivity

Google Sheets MCP Gateway for AI Agents

Expose Google Sheets tools to Claude Code, Cursor, Codex, and other MCP clients through the local KosmoKrator MCP gateway.

20 functions 13 read 7 write OAuth browser flow auth
Submit Google Sheets feedback View package source

Google Sheets MCP Gateway

Expose Google Sheets to MCP clients with `kosmokrator mcp:serve --integration=google_sheets`.

If the client has never used KosmoKrator before, install it first, then register this integration as a stdio MCP server. The gateway exposes only the selected integration in the example below. 

curl -fsSL https://raw.githubusercontent.com/OpenCompanyApp/kosmokrator/main/install.sh | bash
kosmokrator mcp:gateway:install --integration=google_sheets --write=deny --json
{
  "mcpServers": {
    "kosmokrator-google_sheets": {
      "type": "stdio",
      "command": "kosmo",
      "args": [
        "mcp:serve",
        "--integration=google_sheets",
        "--write=deny"
      ]
    }
  }
}

Serve Manually

kosmokrator mcp:serve --integration=google_sheets --write=deny

MCP Tool Names

KosmoKrator exposes integration tools through the gateway with stable names:

MCP Tool Names (20 tools)
MCP toolSource functionType
integration__google_sheets__google_sheets_add_filter google_sheets.google_sheets_add_filter Write write
integration__google_sheets__google_sheets_add_sheet google_sheets.google_sheets_add_sheet Write write
integration__google_sheets__google_sheets_append google_sheets.google_sheets_append Read read
integration__google_sheets__google_sheets_batch_read google_sheets.google_sheets_batch_read Read read
integration__google_sheets__google_sheets_batch_write google_sheets.google_sheets_batch_write Read read
integration__google_sheets__google_sheets_clear google_sheets.google_sheets_clear Read read
integration__google_sheets__google_sheets_create google_sheets.google_sheets_create Read read
integration__google_sheets__google_sheets_delete_columns google_sheets.google_sheets_delete_columns Write write
integration__google_sheets__google_sheets_delete_rows google_sheets.google_sheets_delete_rows Write write
integration__google_sheets__google_sheets_delete_sheet google_sheets.google_sheets_delete_sheet Write write
integration__google_sheets__google_sheets_duplicate_sheet google_sheets.google_sheets_duplicate_sheet Write write
integration__google_sheets__google_sheets_find google_sheets.google_sheets_find Read read
integration__google_sheets__google_sheets_get_metadata google_sheets.google_sheets_get_metadata Read read
integration__google_sheets__google_sheets_insert_columns google_sheets.google_sheets_insert_columns Read read
integration__google_sheets__google_sheets_insert_rows google_sheets.google_sheets_insert_rows Read read
integration__google_sheets__google_sheets_read_range google_sheets.google_sheets_read_range Read read
integration__google_sheets__google_sheets_remove_filter google_sheets.google_sheets_remove_filter Write write
integration__google_sheets__google_sheets_rename_sheet google_sheets.google_sheets_rename_sheet Read read
integration__google_sheets__google_sheets_sort_range google_sheets.google_sheets_sort_range Read read
integration__google_sheets__google_sheets_write_range google_sheets.google_sheets_write_range Read read

Write Access

Start with --write=deny for read-only MCP clients. Use --write=ask or --write=allow only when the client and workspace are trusted.