Smartsheet MCP Server

Smartsheet data operations and document management for AI-powered automated workflows.

Data last scanned yesterday · Reviewed last month

0 4 dangerous tools35 tools★ 12PythonMIT

Overview

The Smartsheet MCP Server provides a standardized interface for interacting with Smartsheet, enabling AI agents to perform document management, data operations, and column configurations. It is designed to bridge automation tools with Smartsheet, supporting tasks ranging from structure modifications to dynamic column management. Beyond general document operations, the server includes specialized capabilities for healthcare environments. These include clinical research analytics, resource utilization analysis, and various scoring frameworks tailored for research and hospital efficiency metrics.

Our verdict

This server carries a high risk level with a security score of 32/100, primarily because it is a community-maintained project rather than an official vendor release. With no independent editorial review of its authentication or read-only mode, users should exercise caution in production environments. It is better suited for experimental integrations or local research tasks where access controls can be strictly monitored.

Supports programmatic modification of sheet structures
Provides specialized logic for healthcare and clinical analytics
Contains only two direct dependencies
Licensed under the MIT license

Last commit was over 11 months ago
Not maintained or provided by Smartsheet officially
Authentication and read-only modes lack external review

Setup

Claude Desktop

{
  "mcpServers": {
    "smartsheet-server": {
      "args": [
        "-y",
        "@terilios/smartsheet-server"
      ],
      "command": "npx"
    }
  }
}

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows), then restart Claude Desktop. Some servers require API keys or tokens as environment variables — check the project's README and add an "env" object if needed.

No read-only mode — running this grants full read/write access.
No built-in authentication — anyone with access to this config can invoke every tool it exposes.

Tools

Tool	Description	Risk
get_column_map	Retrieves column mapping and sample data from a Smartsheet	low
get_sheet_info	Alias for get_column_map providing identical functionality	low
smartsheet_write	Writes new rows to Smartsheet with intelligent handling of system-managed columns, multi-select picklist values, and formula-based columns	medium
smartsheet_update	Updates existing rows in a Smartsheet	medium
smartsheet_delete	Deletes rows from a Smartsheet	high
smartsheet_search	Performs advanced search across sheets	low
smartsheet_add_column	Adds new columns to a Smartsheet	medium
smartsheet_delete_column	Safely deletes columns with dependency checking	high
smartsheet_rename_column	Renames columns while preserving relationships	medium
smartsheet_bulk_update	Performs conditional bulk updates based on rules	medium

Compatibility

Client	Local	Docker	Remote	Read-only
ChatGPT
Claude Desktop
Cursor
VS Code
Windsurf

Frequently asked questions

›Where are new rows added when using the smartsheet_write tool?

The smartsheet_write tool automatically appends new rows to the bottom of the sheet, following any existing entries.

›What is the maximum number of columns allowed per sheet when using the smartsheet_add_column tool?

The tool enforces a limit of 400 columns per sheet and includes validation to ensure this limit is maintained.

›Does the smartsheet_delete_column tool allow for deleting columns with existing dependencies?

No, the tool performs dependency checking and validates formula references before deletion to prevent issues with columns currently in use.

›What search capabilities are provided by the smartsheet_search tool?

The tool supports advanced search modes including regex text search, exact value matching for picklist columns, and options for case-sensitive or whole-word matching.