Smartsheet MCP Server

Name: Smartsheet MCP Server
Author: terilios

terilios

Works with Smartsheet and adds healthcare analytics such as clinical note summarization, patient feedback analysis and research impact assessment.

Setup

Choose your client, copy the config, then fill in any required environment variables.

Add to Cursor Add to VS Code

claude mcp add smartsheet-server-terilios --env PYTHON_PATH='<PYTHON_PATH>' --env SMARTSHEET_API_KEY='<SMARTSHEET_API_KEY>' --env AZURE_OPENAI_API_BASE='<AZURE_OPENAI_API_BASE>' --env AZURE_OPENAI_API_KEY='<AZURE_OPENAI_API_KEY>' --env AZURE_OPENAI_API_VERSION='<AZURE_OPENAI_API_VERSION>' --env AZURE_OPENAI_DEPLOYMENT='<AZURE_OPENAI_DEPLOYMENT>' -- node build/index.js

~/.codex/config.toml

[mcp_servers.smartsheet-server-terilios]
command = "node"
args = ["build/index.js"]
env = { PYTHON_PATH = "<PYTHON_PATH>", SMARTSHEET_API_KEY = "<SMARTSHEET_API_KEY>", AZURE_OPENAI_API_BASE = "<AZURE_OPENAI_API_BASE>", AZURE_OPENAI_API_KEY = "<AZURE_OPENAI_API_KEY>", AZURE_OPENAI_API_VERSION = "<AZURE_OPENAI_API_VERSION>", AZURE_OPENAI_DEPLOYMENT = "<AZURE_OPENAI_DEPLOYMENT>" }

# codex mcp add smartsheet-server-terilios --env PYTHON_PATH='<PYTHON_PATH>' --env SMARTSHEET_API_KEY='<SMARTSHEET_API_KEY>' --env AZURE_OPENAI_API_BASE='<AZURE_OPENAI_API_BASE>' --env AZURE_OPENAI_API_KEY='<AZURE_OPENAI_API_KEY>' --env AZURE_OPENAI_API_VERSION='<AZURE_OPENAI_API_VERSION>' --env AZURE_OPENAI_DEPLOYMENT='<AZURE_OPENAI_DEPLOYMENT>' -- node build/index.js

~/.cursor/mcp.json

{
  "mcpServers": {
    "smartsheet-server-terilios": {
      "command": "node",
      "args": [
        "build/index.js"
      ],
      "env": {
        "PYTHON_PATH": "<PYTHON_PATH>",
        "SMARTSHEET_API_KEY": "<SMARTSHEET_API_KEY>",
        "AZURE_OPENAI_API_BASE": "<AZURE_OPENAI_API_BASE>",
        "AZURE_OPENAI_API_KEY": "<AZURE_OPENAI_API_KEY>",
        "AZURE_OPENAI_API_VERSION": "<AZURE_OPENAI_API_VERSION>",
        "AZURE_OPENAI_DEPLOYMENT": "<AZURE_OPENAI_DEPLOYMENT>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "smartsheet-server-terilios": {
      "type": "stdio",
      "command": "node",
      "args": [
        "build/index.js"
      ],
      "env": {
        "PYTHON_PATH": "<PYTHON_PATH>",
        "SMARTSHEET_API_KEY": "<SMARTSHEET_API_KEY>",
        "AZURE_OPENAI_API_BASE": "<AZURE_OPENAI_API_BASE>",
        "AZURE_OPENAI_API_KEY": "<AZURE_OPENAI_API_KEY>",
        "AZURE_OPENAI_API_VERSION": "<AZURE_OPENAI_API_VERSION>",
        "AZURE_OPENAI_DEPLOYMENT": "<AZURE_OPENAI_DEPLOYMENT>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "smartsheet-server-terilios": {
      "command": "node",
      "args": [
        "build/index.js"
      ],
      "env": {
        "PYTHON_PATH": "<PYTHON_PATH>",
        "SMARTSHEET_API_KEY": "<SMARTSHEET_API_KEY>",
        "AZURE_OPENAI_API_BASE": "<AZURE_OPENAI_API_BASE>",
        "AZURE_OPENAI_API_KEY": "<AZURE_OPENAI_API_KEY>",
        "AZURE_OPENAI_API_VERSION": "<AZURE_OPENAI_API_VERSION>",
        "AZURE_OPENAI_DEPLOYMENT": "<AZURE_OPENAI_DEPLOYMENT>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "smartsheet-server-terilios": {
      "command": "node",
      "args": [
        "build/index.js"
      ],
      "env": {
        "PYTHON_PATH": "<PYTHON_PATH>",
        "SMARTSHEET_API_KEY": "<SMARTSHEET_API_KEY>",
        "AZURE_OPENAI_API_BASE": "<AZURE_OPENAI_API_BASE>",
        "AZURE_OPENAI_API_KEY": "<AZURE_OPENAI_API_KEY>",
        "AZURE_OPENAI_API_VERSION": "<AZURE_OPENAI_API_VERSION>",
        "AZURE_OPENAI_DEPLOYMENT": "<AZURE_OPENAI_DEPLOYMENT>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "smartsheet-server-terilios": {
      "command": "node",
      "args": [
        "build/index.js"
      ],
      "env": {
        "PYTHON_PATH": "<PYTHON_PATH>",
        "SMARTSHEET_API_KEY": "<SMARTSHEET_API_KEY>",
        "AZURE_OPENAI_API_BASE": "<AZURE_OPENAI_API_BASE>",
        "AZURE_OPENAI_API_KEY": "<AZURE_OPENAI_API_KEY>",
        "AZURE_OPENAI_API_VERSION": "<AZURE_OPENAI_API_VERSION>",
        "AZURE_OPENAI_DEPLOYMENT": "<AZURE_OPENAI_DEPLOYMENT>"
      }
    }
  }
}

Environment variables

PYTHON_PATH
SMARTSHEET_API_KEY
AZURE_OPENAI_API_BASE
AZURE_OPENAI_API_KEY
AZURE_OPENAI_API_VERSION
AZURE_OPENAI_DEPLOYMENT

Replace the placeholders with your own credentials and keep them out of version control.

Setup

Environment variables

Related