Smartsheet MCP Server
by terilios
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| PYTHON_PATH | Yes | Path to the Python executable in your conda environment | |
| SMARTSHEET_API_KEY | Yes | Your Smartsheet API access token | |
| AZURE_OPENAI_API_KEY | No | Your Azure OpenAI API key for healthcare analytics features | |
| AZURE_OPENAI_API_BASE | No | Your Azure OpenAI endpoint URL | |
| AZURE_OPENAI_DEPLOYMENT | No | Your Azure OpenAI deployment name | |
| AZURE_OPENAI_API_VERSION | No | The Azure OpenAI API version to use |
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| smartsheet_add_column | Add a new column to a Smartsheet |
| smartsheet_delete_column | Delete a column from a Smartsheet |
| smartsheet_rename_column | Rename a column in a Smartsheet |
| get_column_map | Get column mapping and sample data from a Smartsheet |
| smartsheet_write | Write data to a Smartsheet |
| smartsheet_update | Update existing rows in a Smartsheet |
| smartsheet_delete | Delete rows from a Smartsheet |
| smartsheet_search | Search for content in a Smartsheet |
| start_batch_analysis | Start a batch analysis job using Azure OpenAI |
| cancel_batch_analysis | Cancel a running batch analysis job |
| get_job_status | Get the status of a batch analysis job |
| smartsheet_bulk_update | Perform conditional bulk updates on a Smartsheet |