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 MCP Gateway for AI Agents

Expose Smartsheet tools to Claude Code, Cursor, Codex, and other MCP clients through the local KosmoKrator MCP gateway.

12 functions 7 read 5 write Bearer token auth

Submit Smartsheet feedback View package source

Smartsheet MCP Gateway

Expose Smartsheet to MCP clients with `kosmokrator mcp:serve --integration=smartsheet`.

If the client has never used KosmoKrator before, install it first, then register this integration as a stdio MCP server. The gateway exposes only the selected integration in the example below.

curl -fsSL https://raw.githubusercontent.com/OpenCompanyApp/kosmokrator/main/install.sh | bash

kosmokrator mcp:gateway:install --integration=smartsheet --write=deny --json

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

Serve Manually

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

MCP Tool Names

KosmoKrator exposes integration tools through the gateway with stable names:

MCP Tool Names (12 tools)

MCP tool	Source function	Type
`integration__smartsheet__smartsheet_list_sheets`	`smartsheet.smartsheet_list_sheets`	Read `read`
`integration__smartsheet__smartsheet_get_sheet`	`smartsheet.smartsheet_get_sheet`	Read `read`
`integration__smartsheet__smartsheet_create_sheet`	`smartsheet.smartsheet_create_sheet`	Write `write`
`integration__smartsheet__smartsheet_add_rows`	`smartsheet.smartsheet_add_rows`	Write `write`
`integration__smartsheet__smartsheet_update_rows`	`smartsheet.smartsheet_update_rows`	Write `write`
`integration__smartsheet__smartsheet_delete_rows`	`smartsheet.smartsheet_delete_rows`	Write `write`
`integration__smartsheet__smartsheet_list_columns`	`smartsheet.smartsheet_list_columns`	Read `read`
`integration__smartsheet__smartsheet_add_column`	`smartsheet.smartsheet_add_column`	Write `write`
`integration__smartsheet__smartsheet_list_workspaces`	`smartsheet.smartsheet_list_workspaces`	Read `read`
`integration__smartsheet__smartsheet_get_workspace`	`smartsheet.smartsheet_get_workspace`	Read `read`
`integration__smartsheet__smartsheet_search`	`smartsheet.smartsheet_search`	Read `read`
`integration__smartsheet__smartsheet_get_current_user`	`smartsheet.smartsheet_get_current_user`	Read `read`

Write Access

Start with --write=deny for read-only MCP clients. Use --write=ask or --write=allow only when the client and workspace are trusted.