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.

12 functions 7 read 5 write Bearer token auth

Submit Smartsheet feedback View package source

Smartsheet CLI Setup

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

# 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 use the same stored profile from scripts, coding CLIs, Lua code mode, and the MCP gateway.

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

Call Smartsheet Headlessly

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

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

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

kosmo integrations:smartsheet smartsheet_list_sheets '{
  "limit": 1,
  "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 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

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

`smartsheet.smartsheet_list_sheets`

Read read

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

Parameters: limit, page

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

`smartsheet.smartsheet_get_sheet`

Read read

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

Parameters: sheet_id, level, page_size, page

Generic CLI call

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

Provider shortcut

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

`smartsheet.smartsheet_create_sheet`

Write write

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

Parameters: name, columns

Generic CLI call

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

Provider shortcut

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

`smartsheet.smartsheet_add_rows`

Write write

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

Parameters: sheet_id, rows

Generic CLI call

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

Provider shortcut

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

`smartsheet.smartsheet_update_rows`

Write write

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

Parameters: sheet_id, rows

Generic CLI call

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

Provider shortcut

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

`smartsheet.smartsheet_delete_rows`

Write write

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

Parameters: sheet_id, row_ids

Generic CLI call

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

Provider shortcut

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

`smartsheet.smartsheet_list_columns`

Read read

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

Parameters: sheet_id, limit, page

Generic CLI call

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

Provider shortcut

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

`smartsheet.smartsheet_add_column`

Write write

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

Parameters: sheet_id, title, type, options

Generic CLI call

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

Provider shortcut

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

`smartsheet.smartsheet_list_workspaces`

Read read

List all workspaces accessible to the authenticated Smartsheet user.

Parameters: limit, page

Generic CLI call

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

Provider shortcut

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

`smartsheet.smartsheet_get_workspace`

Read read

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

Parameters: workspace_id

Generic CLI call

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

Provider shortcut

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

`smartsheet.smartsheet_search`

Read read

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

Parameters: query, location, limit

Generic CLI call

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

Provider shortcut

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

`smartsheet.smartsheet_get_current_user`

Read read

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

Parameters: none

Generic CLI call

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

Provider 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`

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

Operation: Read read
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`

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

Operation: Read read
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`

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

Operation: Write write
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`

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

Operation: Write write
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`

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

Operation: Write write
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`

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

Operation: Write write
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`

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

Operation: Read read
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`

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

Operation: Write write
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`

List all workspaces accessible to the authenticated Smartsheet user.

Operation: Read read
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`

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

Operation: Read read
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`

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

Operation: Read read
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`

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

Operation: Read read
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.