Can I use Zoho Sheet as a CLI?

Yes. KosmoKrator exposes a Zoho Sheet CLI through kosmo integrations:call and the provider shortcut command. Commands can return JSON for scripts, CI, and coding agents.

Can I expose Zoho Sheet through MCP?

Yes. The KosmoKrator MCP gateway can expose selected Zoho Sheet tools to clients such as Claude Code, Cursor, Codex, and other MCP-compatible tools.

Where are Zoho Sheet credentials stored?

Zoho Sheet credentials are configured in KosmoKrator's local integration settings and reused by CLI, Lua, and MCP gateway surfaces.

Can I deny write access for Zoho Sheet MCP tools?

Yes. Start the gateway with --write=deny for read-only clients, or use ask/allow only for trusted workspaces.

productivity

Zoho Sheet CLI for AI Agents

Use the Zoho Sheet CLI from KosmoKrator to call Zoho Sheet tools headlessly, return JSON, inspect schemas, and automate workflows from coding agents, scripts, and CI.

7 functions 6 read 1 write Manual OAuth token auth

Submit Zoho Sheet feedback View package source

Zoho Sheet CLI Setup

Zoho Sheet can be configured headlessly with `kosmokrator integrations:configure zoho_sheet`.

# Install KosmoKrator first if it is not available on PATH.
curl -fsSL https://raw.githubusercontent.com/OpenCompanyApp/kosmokrator/main/install.sh | bash

# Configure and verify this integration.
kosmokrator integrations:configure zoho_sheet --set access_token="$ZOHO_SHEET_ACCESS_TOKEN" --enable --read allow --write ask --json
kosmokrator integrations:doctor zoho_sheet --json
kosmokrator integrations:status --json

Credentials

Authentication type: Manual OAuth token oauth2_manual_token. Configure credentials once, then use the same stored profile from scripts, coding CLIs, Lua code mode, and the MCP gateway.

Key	Env var	Type	Required	Label
`access_token`	`ZOHO_SHEET_ACCESS_TOKEN`	Secret `secret`	yes	Access Token
`url`	`ZOHO_SHEET_URL`	URL `url`	no	API Base URL

Call Zoho Sheet Headlessly

Use the generic call form when another coding CLI or script needs a stable universal interface.

kosmo integrations:call zoho_sheet.zoho_sheet_list_spreadsheets '{
  "page": 1,
  "per_page": 1
}' --json

Use the provider shortcut form for shorter human-facing commands.

kosmo integrations:zoho_sheet zoho_sheet_list_spreadsheets '{
  "page": 1,
  "per_page": 1
}' --json

Agent Discovery Commands

These commands return structured output for coding agents that need to inspect capabilities before choosing a function.

kosmo integrations:docs zoho_sheet --json
kosmo integrations:docs zoho_sheet.zoho_sheet_list_spreadsheets --json
kosmo integrations:schema zoho_sheet.zoho_sheet_list_spreadsheets --json
kosmo integrations:search "Zoho Sheet" --json
kosmo integrations:list --json

All CLI Functions

Every function below can be called headlessly. The generic form is stable across all integrations; the provider shortcut is shorter but specific to Zoho Sheet.

`zoho_sheet.zoho_sheet_list_spreadsheets`

Read 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.

Parameters: page, per_page

Generic CLI call

kosmo integrations:call zoho_sheet.zoho_sheet_list_spreadsheets '{"page":1,"per_page":1}' --json

Provider shortcut

kosmo integrations:zoho_sheet zoho_sheet_list_spreadsheets '{"page":1,"per_page":1}' --json

`zoho_sheet.zoho_sheet_get_spreadsheet`

Read read

Get details of a specific Zoho Sheet spreadsheet by its ID. Returns spreadsheet metadata including name, description, and associated worksheets.

Parameters: id

Generic CLI call

kosmo integrations:call zoho_sheet.zoho_sheet_get_spreadsheet '{"id":"example_id"}' --json

Provider shortcut

kosmo integrations:zoho_sheet zoho_sheet_get_spreadsheet '{"id":"example_id"}' --json

`zoho_sheet.zoho_sheet_list_worksheets`

Read 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.

Parameters: id

Generic CLI call

kosmo integrations:call zoho_sheet.zoho_sheet_list_worksheets '{"id":"example_id"}' --json

Provider shortcut

kosmo integrations:zoho_sheet zoho_sheet_list_worksheets '{"id":"example_id"}' --json

`zoho_sheet.zoho_sheet_get_worksheet`

Read read

Get details of a specific worksheet within a Zoho Sheet spreadsheet. Returns worksheet metadata including name, row/column counts, and header information.

Parameters: id, worksheet_id

Generic CLI call

kosmo integrations:call zoho_sheet.zoho_sheet_get_worksheet '{"id":"example_id","worksheet_id":"example_worksheet_id"}' --json

Provider shortcut

kosmo integrations:zoho_sheet zoho_sheet_get_worksheet '{"id":"example_id","worksheet_id":"example_worksheet_id"}' --json

`zoho_sheet.zoho_sheet_list_rows`

Read 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.

Parameters: id, worksheet_id, page, per_page

Generic CLI call

kosmo integrations:call zoho_sheet.zoho_sheet_list_rows '{"id":"example_id","worksheet_id":"example_worksheet_id","page":1,"per_page":1}' --json

Provider shortcut

kosmo integrations:zoho_sheet zoho_sheet_list_rows '{"id":"example_id","worksheet_id":"example_worksheet_id","page":1,"per_page":1}' --json

`zoho_sheet.zoho_sheet_create_row`

Write 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.

Parameters: id, worksheet_id, data

Generic CLI call

kosmo integrations:call zoho_sheet.zoho_sheet_create_row '{"id":"example_id","worksheet_id":"example_worksheet_id","data":"example_data"}' --json

Provider shortcut

kosmo integrations:zoho_sheet zoho_sheet_create_row '{"id":"example_id","worksheet_id":"example_worksheet_id","data":"example_data"}' --json

`zoho_sheet.zoho_sheet_get_current_user`

Read read

Get the authenticated Zoho Sheet user's profile information. Returns display name, email, and account details. Useful for verifying which account is connected.

Parameters: none

Generic CLI call

kosmo integrations:call zoho_sheet.zoho_sheet_get_current_user '{}' --json

Provider shortcut

kosmo integrations:zoho_sheet zoho_sheet_get_current_user '{}' --json

Function Schemas

Use these parameter tables when building CLI payloads without calling integrations:schema first.

`zoho_sheet.zoho_sheet_list_spreadsheets`

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.

Operation: Read read
Schema command: kosmo integrations:schema zoho_sheet.zoho_sheet_list_spreadsheets --json

Parameter	Type	Required	Description
`page`	integer	no	Page number for pagination (default: 1).
`per_page`	integer	no	Number of spreadsheets per page (default: 25, max: 100).

`zoho_sheet.zoho_sheet_get_spreadsheet`

Get details of a specific Zoho Sheet spreadsheet by its ID. Returns spreadsheet metadata including name, description, and associated worksheets.

Operation: Read read
Schema command: kosmo integrations:schema zoho_sheet.zoho_sheet_get_spreadsheet --json

Parameter	Type	Required	Description
`id`	string	yes	The spreadsheet resource ID.

`zoho_sheet.zoho_sheet_list_worksheets`

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.

Operation: Read read
Schema command: kosmo integrations:schema zoho_sheet.zoho_sheet_list_worksheets --json

Parameter	Type	Required	Description
`id`	string	yes	The spreadsheet resource ID.

`zoho_sheet.zoho_sheet_get_worksheet`

Get details of a specific worksheet within a Zoho Sheet spreadsheet. Returns worksheet metadata including name, row/column counts, and header information.

Operation: Read read
Schema command: kosmo integrations:schema zoho_sheet.zoho_sheet_get_worksheet --json

Parameter	Type	Required	Description
`id`	string	yes	The spreadsheet resource ID.
`worksheet_id`	string	yes	The worksheet resource ID.

`zoho_sheet.zoho_sheet_list_rows`

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.

Operation: Read read
Schema command: kosmo integrations:schema zoho_sheet.zoho_sheet_list_rows --json

Parameter	Type	Required	Description
`id`	string	yes	The spreadsheet resource ID.
`worksheet_id`	string	yes	The worksheet resource ID.
`page`	integer	no	Page number for pagination (default: 1).
`per_page`	integer	no	Number of rows per page (default: 25, max: 100).

`zoho_sheet.zoho_sheet_create_row`

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.

Operation: Write write
Schema command: kosmo integrations:schema zoho_sheet.zoho_sheet_create_row --json

Parameter	Type	Required	Description
`id`	string	yes	The spreadsheet resource ID.
`worksheet_id`	string	yes	The worksheet resource ID.
`data`	object	yes	Row data as key-value pairs. Keys must match column headers in the worksheet (e.g., {"Name": "John", "Email": "[email protected]", "Age": 30}).

`zoho_sheet.zoho_sheet_get_current_user`

Get the authenticated Zoho Sheet user's profile information. Returns display name, email, and account details. Useful for verifying which account is connected.

Operation: Read read
Schema command: kosmo integrations:schema zoho_sheet.zoho_sheet_get_current_user --json

Parameter	Type	Required	Description
No parameters.

Permissions

Headless calls still follow the integration read/write permission policy. Configure read/write defaults with integrations:configure. Add --force only for trusted automation that should bypass that policy.