KosmoKrator

productivity

Zoho Sheet MCP Integration for CrewAI

Connect Zoho Sheet to CrewAI 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 CrewAI

Expose KosmoKrator integrations to CrewAI workers as scoped local tools.

Wrap kosmo integrations:call for specific tasks or connect workers to a local MCP gateway. The gateway is local, scoped to this integration, and starts with --write=deny so CrewAI can inspect read-capable tools without receiving write access by default.

Zoho Sheet MCP Config for CrewAI

Use per-worker integration scopes to avoid giving every worker every tool.

{
  "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 CrewAI

CrewAI 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 CrewAIClient-level gateway setup.