KosmoKrator

productivity

Smartsheet MCP Integration for CrewAI

Connect Smartsheet to CrewAI through the local KosmoKrator MCP gateway with scoped tools, credentials, and write policy.

12 functions 7 read 5 write Bearer token auth
Submit Smartsheet feedback View package source

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

Smartsheet MCP Config for CrewAI

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

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

Run the Gateway Manually

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

Why Use KosmoKrator Here

Scoped tools

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

Smartsheet Tools Visible to CrewAI

CrewAI sees stable MCP tool names generated from the Smartsheet integration catalog.

MCP toolSource functionTypeDescription
integration__smartsheet__smartsheet_list_sheets smartsheet.smartsheet_list_sheets Read List all sheets accessible to the authenticated Smartsheet user. Returns sheet names and IDs.
integration__smartsheet__smartsheet_get_sheet smartsheet.smartsheet_get_sheet Read Get a specific Smartsheet sheet by ID, including its rows and columns.
integration__smartsheet__smartsheet_create_sheet smartsheet.smartsheet_create_sheet Write Create a new Smartsheet sheet with a specified name and column definitions.
integration__smartsheet__smartsheet_add_rows smartsheet.smartsheet_add_rows Write Add one or more rows to a Smartsheet sheet. Each row should have a "cells" array with objects containing "columnId" and "value".
integration__smartsheet__smartsheet_update_rows smartsheet.smartsheet_update_rows Write Update one or more existing rows in a Smartsheet sheet. Each row must include its "id" field along with updated cell values.
integration__smartsheet__smartsheet_delete_rows smartsheet.smartsheet_delete_rows Write Delete one or more rows from a Smartsheet sheet by their row IDs.
integration__smartsheet__smartsheet_list_columns smartsheet.smartsheet_list_columns Read List all columns in a Smartsheet sheet, including their titles, types, and IDs.
integration__smartsheet__smartsheet_add_column smartsheet.smartsheet_add_column Write Add a new column to a Smartsheet sheet. Column types include TEXT_NUMBER, DATE, CHECKBOX, PICKLIST, CONTACT_LIST, DATETIME, DURATION, and AUTO_NUMBER.
integration__smartsheet__smartsheet_list_workspaces smartsheet.smartsheet_list_workspaces Read List all workspaces accessible to the authenticated Smartsheet user.
integration__smartsheet__smartsheet_get_workspace smartsheet.smartsheet_get_workspace Read Get a specific Smartsheet workspace by ID, including its sheets, reports, and other contents.
integration__smartsheet__smartsheet_search smartsheet.smartsheet_search Read Search across Smartsheet sheets, reports, and templates for matching content.
integration__smartsheet__smartsheet_get_current_user smartsheet.smartsheet_get_current_user Read Get the currently authenticated Smartsheet user's profile, including name and email.

Related Smartsheet Pages

Smartsheet CLIUse direct JSON commands instead of MCP discovery. Smartsheet MCPFull gateway reference and MCP tool names. KosmoKrator for CrewAIClient-level gateway setup.