Smartsheet MCP Server

Name: Smartsheet MCP Server
Author: terilios

@terilios

Smartsheet MCP Server について

MCP server providing healthcare analytics capabilities for Smartsheet, including clinical note summarization, patient feedback analysis, and research impact assessment

#batch-processing #clinical-research #smartsheet #healthcare-analytics #medical-research #azure-openai #healthcare-automation #mcp-server #patient-feedback

基本情報

カテゴリ

データと分析

ライセンス

MIT

ランタイム

python

トランスポート

stdio

公開者

terilios

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "smartsheet-server": {
      "command": "node",
      "args": [
        "build/index.js"
      ],
      "env": {
        "PYTHON_PATH": "/Users/[username]/anaconda3/envs/cline_mcp_env/bin/python3",
        "SMARTSHEET_API_KEY": "your-api-key"
      }
    }
  }
}

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is Smartsheet MCP Server?

An MCP server that integrates with Smartsheet to enable automated operations on Smartsheet documents through a standardized interface, bridging AI-powered automation tools with Smartsheet's collaboration platform.

How to use Smartsheet MCP Server?

Install and configure the server using the provided setup scripts. The server communicates via the MCP protocol over stdio. Authentication requires a Smartsheet API token. Specific command-line invocation details are not described in the README.

Key features of Smartsheet MCP Server

34 tools for Smartsheet operations including read, write, update, delete, and search.
Column management: add, rename, and delete columns with dependency checking.
Batch analysis using Azure OpenAI for healthcare and research data.
Attachment, discussion, and comment management on sheets and rows.
Cell history and row audit trails with user attribution.
Cross-sheet reference analysis and formula dependency tracking.

Use cases of Smartsheet MCP Server

Clinical research analytics including protocol compliance scoring and patient data analysis.
Hospital operations such as resource utilization and quality metrics tracking.
Automated document management with dynamic column creation and validation.
Bulk data updates with integrity checks and duplicate detection.
AI-driven sheet customization and automated reporting workflows.

FAQ from Smartsheet MCP Server

What runtime dependencies does it require?

Node.js versions 16, 18, or 20, and Python versions 3.8, 3.9, 3.10, or 3.11 are supported.

How does it handle data integrity?

Enforces validation rules, maintains referential integrity, preserves formula references, and implements comprehensive error handling.

What transport method does it use?

It communicates via the MCP protocol over a stdio interface.

Does it support batch operations?

Yes, tools like smartsheet_bulk_update and start_batch_analysis support batch processing with configurable sizes and progress tracking.

Are there any column limits?

The server enforces a column limit of 400 per sheet with validation when adding columns.

「データと分析」の他のコンテンツ

Google Analytics MCP Server

surendranb

Google Analytics 4 data to AI agents, agentic workflows, and MCP clients. Give agents analysis-ready access to website traffic, user behavior, and performance data with schema discovery, server-side aggregation, and safe defaults that reduce data wrangling.

225