Can I use Smartsheet as a CLI?

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

Can I expose Smartsheet through MCP?

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

Where are Smartsheet credentials stored?

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

Can I deny write access for Smartsheet MCP tools?

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

productivity

Smartsheet CLI for AI Agents

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

Smartsheet CLI Setup

Smartsheet can be configured headlessly with `kosmokrator integrations:configure smartsheet`.

Install, configure, and verify

# 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 smartsheet --set 0="$SMARTSHEET_0" --enable --read allow --write ask --json
kosmokrator integrations:doctor smartsheet --json
kosmokrator integrations:status --json

Credentials

Authentication type: Bearer token bearer_token. Configure credentials once, then reuse the same stored profile from scripts, coding CLIs, Lua, and MCP.

Key	Env var	Type	Required	Label
`0`	`SMARTSHEET_0`	Secret `secret`	yes	access_token

Command Patterns

The generic command is stable across every integration. The provider shortcut is shorter for humans.

Generic CLI call

kosmo integrations:call smartsheet.smartsheet_list_sheets '{"limit":1,"page":1}' --json

Provider shortcut

kosmo integrations:smartsheet smartsheet_list_sheets '{"limit":1,"page":1}' --json

Discovery

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

Discovery commands

kosmo integrations:docs smartsheet --json
kosmo integrations:docs smartsheet.smartsheet_list_sheets --json
kosmo integrations:schema smartsheet.smartsheet_list_sheets --json
kosmo integrations:search "Smartsheet" --json
kosmo integrations:list --json

Automation Contexts

The same configured command surface works in these environments. The command does not change unless the host wrapper, credentials, or permissions change.

CI Run integration calls from CI jobs with JSON output, explicit credentials, and predictable exit status. Cron Jobs Schedule repeatable integration workflows from cron while keeping credentials in KosmoKrator config. Shell Scripts Call integration functions from shell scripts with stable JSON input and output. Headless Automation Use KosmoKrator as a non-interactive integration runtime for local automations and wrappers. Coding Agents Let coding agents discover schemas and execute integration functions through CLI commands or MCP.

CLI Functions

Every function below can be called headlessly. Commands are highlighted, copyable, and scroll horizontally when payloads are long.

`smartsheet.smartsheet_list_sheets`

List all sheets accessible to the authenticated Smartsheet user. Returns sheet names and IDs.

Read read

Parameters: limit, page

Generic call

kosmo integrations:call smartsheet.smartsheet_list_sheets '{"limit":1,"page":1}' --json

Shortcut

kosmo integrations:smartsheet smartsheet_list_sheets '{"limit":1,"page":1}' --json

`smartsheet.smartsheet_get_sheet`

Get a specific Smartsheet sheet by ID, including its rows and columns.

Read read

Parameters: sheet_id, level, page_size, page

Generic call

kosmo integrations:call smartsheet.smartsheet_get_sheet '{"sheet_id":1,"level":1,"page_size":1,"page":1}' --json

Shortcut

kosmo integrations:smartsheet smartsheet_get_sheet '{"sheet_id":1,"level":1,"page_size":1,"page":1}' --json

`smartsheet.smartsheet_create_sheet`

Create a new Smartsheet sheet with a specified name and column definitions.

Write write

Parameters: name, columns

Generic call

kosmo integrations:call smartsheet.smartsheet_create_sheet '{"name":"example_name","columns":"example_columns"}' --json

Shortcut

kosmo integrations:smartsheet smartsheet_create_sheet '{"name":"example_name","columns":"example_columns"}' --json

`smartsheet.smartsheet_add_rows`

Add one or more rows to a Smartsheet sheet. Each row should have a "cells" array with objects containing "columnId" and "value".

Write write

Parameters: sheet_id, rows

Generic call

kosmo integrations:call smartsheet.smartsheet_add_rows '{"sheet_id":1,"rows":"example_rows"}' --json

Shortcut

kosmo integrations:smartsheet smartsheet_add_rows '{"sheet_id":1,"rows":"example_rows"}' --json

`smartsheet.smartsheet_update_rows`

Update one or more existing rows in a Smartsheet sheet. Each row must include its "id" field along with updated cell values.

Write write

Parameters: sheet_id, rows

Generic call

kosmo integrations:call smartsheet.smartsheet_update_rows '{"sheet_id":1,"rows":"example_rows"}' --json

Shortcut

kosmo integrations:smartsheet smartsheet_update_rows '{"sheet_id":1,"rows":"example_rows"}' --json

`smartsheet.smartsheet_delete_rows`

Delete one or more rows from a Smartsheet sheet by their row IDs.

Write write

Parameters: sheet_id, row_ids

Generic call

kosmo integrations:call smartsheet.smartsheet_delete_rows '{"sheet_id":1,"row_ids":"example_row_ids"}' --json

Shortcut

kosmo integrations:smartsheet smartsheet_delete_rows '{"sheet_id":1,"row_ids":"example_row_ids"}' --json

`smartsheet.smartsheet_list_columns`

List all columns in a Smartsheet sheet, including their titles, types, and IDs.

Read read

Parameters: sheet_id, limit, page

Generic call

kosmo integrations:call smartsheet.smartsheet_list_columns '{"sheet_id":1,"limit":1,"page":1}' --json

Shortcut

kosmo integrations:smartsheet smartsheet_list_columns '{"sheet_id":1,"limit":1,"page":1}' --json

`smartsheet.smartsheet_add_column`

Add a new column to a Smartsheet sheet. Column types include TEXT_NUMBER, DATE, CHECKBOX, PICKLIST, CONTACT_LIST, DATETIME, DURATION, and AUTO_NUMBER.

Write write

Parameters: sheet_id, title, type, options

Generic call

kosmo integrations:call smartsheet.smartsheet_add_column '{"sheet_id":1,"title":"example_title","type":"example_type","options":"example_options"}' --json

Shortcut

kosmo integrations:smartsheet smartsheet_add_column '{"sheet_id":1,"title":"example_title","type":"example_type","options":"example_options"}' --json

`smartsheet.smartsheet_list_workspaces`

List all workspaces accessible to the authenticated Smartsheet user.

Read read

Parameters: limit, page

Generic call

kosmo integrations:call smartsheet.smartsheet_list_workspaces '{"limit":1,"page":1}' --json

Shortcut

kosmo integrations:smartsheet smartsheet_list_workspaces '{"limit":1,"page":1}' --json

`smartsheet.smartsheet_get_workspace`

Get a specific Smartsheet workspace by ID, including its sheets, reports, and other contents.

Read read

Parameters: workspace_id

Generic call

kosmo integrations:call smartsheet.smartsheet_get_workspace '{"workspace_id":1}' --json

Shortcut

kosmo integrations:smartsheet smartsheet_get_workspace '{"workspace_id":1}' --json

`smartsheet.smartsheet_search`

Search across Smartsheet sheets, reports, and templates for matching content.

Read read

Parameters: query, location, limit

Generic call

kosmo integrations:call smartsheet.smartsheet_search '{"query":"example_query","location":"example_location","limit":1}' --json

Shortcut

kosmo integrations:smartsheet smartsheet_search '{"query":"example_query","location":"example_location","limit":1}' --json

`smartsheet.smartsheet_get_current_user`

Get the currently authenticated Smartsheet user's profile, including name and email.

Read read

Parameters: none

Generic call

kosmo integrations:call smartsheet.smartsheet_get_current_user '{}' --json

Shortcut

kosmo integrations:smartsheet smartsheet_get_current_user '{}' --json

Function Schemas

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

smartsheet.smartsheet_list_sheets 2 parameters

Schema command

kosmo integrations:schema smartsheet.smartsheet_list_sheets --json

Parameter	Type	Required	Description
`limit`	integer	no	Maximum number of sheets to return (default 100, max 100).
`page`	integer	no	Page number for pagination (1-based).

smartsheet.smartsheet_get_sheet 4 parameters

Schema command

kosmo integrations:schema smartsheet.smartsheet_get_sheet --json

Parameter	Type	Required	Description
`sheet_id`	integer	yes	The unique identifier of the sheet to retrieve.
`level`	integer	no	The nesting level for the response (0–2). Default is 0.
`page_size`	integer	no	Number of rows per page. Default is 100.
`page`	integer	no	Page number for pagination (1-based).

smartsheet.smartsheet_create_sheet 2 parameters

Schema command

kosmo integrations:schema smartsheet.smartsheet_create_sheet --json

Parameter	Type	Required	Description
`name`	string	yes	The name for the new sheet.
`columns`	array	yes	Array of column definitions. Each column must have "title" and "type". Supported types: TEXT_NUMBER, DATE, CHECKBOX, PICKLIST, CONTACT_LIST, DATETIME, DURATION, MULTI_CONTACT_LIST, AUTO_NUMBER.

smartsheet.smartsheet_add_rows 2 parameters

Schema command

kosmo integrations:schema smartsheet.smartsheet_add_rows --json

Parameter	Type	Required	Description
`sheet_id`	integer	yes	The unique identifier of the sheet to add rows to.
`rows`	array	yes	Array of row objects. Each row must have a "cells" array with {"columnId": int, "value": mixed}. Optionally include "toTop": true or "toBottom": true.

smartsheet.smartsheet_update_rows 2 parameters

Schema command

kosmo integrations:schema smartsheet.smartsheet_update_rows --json

Parameter	Type	Required	Description
`sheet_id`	integer	yes	The unique identifier of the sheet containing the rows to update.
`rows`	array	yes	Array of row objects to update. Each row must have "id" and a "cells" array with {"columnId": int, "value": mixed}.

smartsheet.smartsheet_delete_rows 2 parameters

Schema command

kosmo integrations:schema smartsheet.smartsheet_delete_rows --json

Parameter	Type	Required	Description
`sheet_id`	integer	yes	The unique identifier of the sheet containing the rows to delete.
`row_ids`	array	yes	Array of row IDs to delete.

smartsheet.smartsheet_list_columns 3 parameters

Schema command

kosmo integrations:schema smartsheet.smartsheet_list_columns --json

Parameter	Type	Required	Description
`sheet_id`	integer	yes	The unique identifier of the sheet.
`limit`	integer	no	Maximum number of columns to return (default 100).
`page`	integer	no	Page number for pagination (1-based).

smartsheet.smartsheet_add_column 4 parameters

Schema command

kosmo integrations:schema smartsheet.smartsheet_add_column --json

Parameter	Type	Required	Description
`sheet_id`	integer	yes	The unique identifier of the sheet to add the column to.
`title`	string	yes	The title for the new column.
`type`	string	yes	The column type. Supported: TEXT_NUMBER, DATE, CHECKBOX, PICKLIST, CONTACT_LIST, DATETIME, DURATION, ABSTRACT_DATETIME, MULTI_CONTACT_LIST, AUTO_NUMBER.
`options`	array	no	Optional additional column options. For PICKLIST columns, include "options" (array of string values) and optionally "option" (e.g., "options": ["Yes","No"]). Other options include "symbol", "width", "format", etc.

smartsheet.smartsheet_list_workspaces 2 parameters

Schema command

kosmo integrations:schema smartsheet.smartsheet_list_workspaces --json

Parameter	Type	Required	Description
`limit`	integer	no	Maximum number of workspaces to return (default 100).
`page`	integer	no	Page number for pagination (1-based).

smartsheet.smartsheet_get_workspace 1 parameters

Schema command

kosmo integrations:schema smartsheet.smartsheet_get_workspace --json

Parameter	Type	Required	Description
`workspace_id`	integer	yes	The unique identifier of the workspace to retrieve.

smartsheet.smartsheet_search 3 parameters

Schema command

kosmo integrations:schema smartsheet.smartsheet_search --json

Parameter	Type	Required	Description
`query`	string	yes	The search query string.
`location`	string	no	Optional location scope for the search (e.g., "sheet", "workspace").
`limit`	integer	no	Maximum number of search results to return (default 100).

smartsheet.smartsheet_get_current_user 0 parameters

Schema command

kosmo integrations:schema smartsheet.smartsheet_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.