KosmoKrator

productivity

Zoho Sheet MCP Integration for Claude Agent SDK

Connect Zoho Sheet to Claude Agent SDK through the local KosmoKrator MCP gateway with scoped tools, credentials, and write policy.

7 functions 6 read 1 write Manual OAuth token auth
Submit Zoho Sheet feedback View package source

Connect Zoho Sheet to Claude Agent SDK

Give Claude Agent SDK workflows access to KosmoKrator integrations through a local MCP server.

Add a KosmoKrator stdio MCP server to the Claude Agent SDK options. The gateway is local, scoped to this integration, and starts with --write=deny so Claude Agent SDK can inspect read-capable tools without receiving write access by default.

Zoho Sheet MCP Config for Claude Agent SDK

Use a narrow integration list so the agent does not load unrelated tools.

{
  "mcpServers": {
    "kosmokrator-zoho_sheet": {
      "type": "stdio",
      "command": "kosmo",
      "args": [
        "mcp:serve",
        "--integration=zoho_sheet",
        "--write=deny"
      ]
    }
  }
}

Run the Gateway Manually

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

Why Use KosmoKrator Here

Scoped tools

Expose only Zoho Sheet instead of a broad multi-service tool list.

Local credentials

Reuse credentials already configured for the KosmoKrator CLI and Lua runtime.

Write policy

Start read-only, then opt into ask or allow for trusted workspaces.

Zoho Sheet Tools Visible to Claude Agent SDK

Claude Agent SDK sees stable MCP tool names generated from the Zoho Sheet integration catalog.

MCP toolSource functionTypeDescription
integration__zoho_sheet__zoho_sheet_list_spreadsheets zoho_sheet.zoho_sheet_list_spreadsheets Read List all spreadsheets accessible to the authenticated Zoho Sheet user. Returns spreadsheet names, IDs, and metadata. Use this to discover available spreadsheets before querying worksheets or rows.
integration__zoho_sheet__zoho_sheet_get_spreadsheet zoho_sheet.zoho_sheet_get_spreadsheet Read Get details of a specific Zoho Sheet spreadsheet by its ID. Returns spreadsheet metadata including name, description, and associated worksheets.
integration__zoho_sheet__zoho_sheet_list_worksheets zoho_sheet.zoho_sheet_list_worksheets Read List all worksheets within a Zoho Sheet spreadsheet. Returns worksheet names, IDs, and metadata like row/column counts. Use this to discover worksheets before reading or writing row data.
integration__zoho_sheet__zoho_sheet_get_worksheet zoho_sheet.zoho_sheet_get_worksheet Read Get details of a specific worksheet within a Zoho Sheet spreadsheet. Returns worksheet metadata including name, row/column counts, and header information.
integration__zoho_sheet__zoho_sheet_list_rows zoho_sheet.zoho_sheet_list_rows Read List rows in a Zoho Sheet worksheet with pagination. Returns row data as key-value pairs using column headers as keys. Use this to read data from a specific worksheet.
integration__zoho_sheet__zoho_sheet_create_row zoho_sheet.zoho_sheet_create_row Write Create a new row in a Zoho Sheet worksheet. Provide column header names as keys and their values. The row will be appended to the end of the worksheet.
integration__zoho_sheet__zoho_sheet_get_current_user zoho_sheet.zoho_sheet_get_current_user Read Get the authenticated Zoho Sheet user's profile information. Returns display name, email, and account details. Useful for verifying which account is connected.

Related Zoho Sheet Pages

Zoho Sheet CLIUse direct JSON commands instead of MCP discovery. Zoho Sheet MCPFull gateway reference and MCP tool names. KosmoKrator for Claude Agent SDKClient-level gateway setup.