A Model Context Protocol server
Smartsheet Server becomes available to MCP clients through the smartsheet server mcp server. A Model Context Protocol server.
A Model Context Protocol (MCP) server that provides seamless integration with Smartsheet, enabling automated operations on Smartsheet documents through a standardized interface. This server bridges the gap between AI-powered automation tools and Smartsheet's powerful collaboration platform.
The Smartsheet MCP Server is designed to facilitate intelligent interactions with Smartsheet, providing a robust set of tools for document management, data operations, and column customization. It serves as a critical component in automated workflows, enabling AI systems to programmatically interact with Smartsheet data while maintaining data integrity and enforcing business rules.
Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.
Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.
| Tool | What it does |
|---|---|
| Auto | number configurations |
| System | managed columns |
| Multi | select picklist values |
| Formula | based columns |
| Case | sensitive and whole word options |
| Column | specific search capabilities |
| Returns: | Matched row IDs (primary result) |
| TEXT_NUMBER | DATE |
| CHECKBOX | PICKLIST |
| CONTACT_LIST | Configurable options: |
| Features: | Automatic batch processing (3 rows per batch for optimal performance) |
| Token | aware content chunking for large text |
| Real | time status updates |
{
"mcpServers": {
"smartsheet": {
"command": "/Users/[username]/anaconda3/envs/cline_mcp_env/bin/node",
"args": [
"/path/to/smartsheet-server/build/index.js",
"--transport",
"stdio"
],
"env": {
"PYTHON_PATH": "/Users/[username]/anaconda3/envs/cline_mcp_env/bin/python3",
"SMARTSHEET_API_KEY": "YOUR_SMARTSHEET_API_KEY",
"AZURE_OPENAI_API_KEY": "YOUR_AZURE_OPENAI_API_KEY",
"AZURE_OPENAI_API_BASE": "your-azure-openai-endpoint",
"AZURE_OPENAI_API_VERSION": "your-api-version",
"AZURE_OPENAI_DEPLOYMENT": "your-deployment-name"
},
"disabled": false,
"autoApprove": [
"get_column_map",
"smartsheet_write",
"smartsheet_update",
"smartsheet_delete",
"smartsheet_search",
"smartsheet_add_column",
"smartsheet_delete_column",
"smartsheet_rename_column",
"smartsheet_bulk_update",
"start_batch_analysis",
"get_job_status",
"cancel_batch_analysis",
"get_all_row_ids",
"list_workspaces",
"get_workspace",
"create_workspace",
"create_sheet_in_workspace",
"list_workspace_sheets"
]
}
}
}From the project documentation. Replace placeholders and example paths before connecting.
| Variable | Description | Required |
|---|---|---|
| PYTHON_PATH | Declared in the maintainer’s client configuration. | Check documentation |
| SMARTSHEET_API_KEY | Declared in the maintainer’s client configuration. | Check documentation |
| AZURE_OPENAI_API_KEY | Declared in the maintainer’s client configuration. | Check documentation |
| AZURE_OPENAI_API_BASE | Declared in the maintainer’s client configuration. | Check documentation |
| AZURE_OPENAI_API_VERSION | Declared in the maintainer’s client configuration. | Check documentation |
| AZURE_OPENAI_DEPLOYMENT | Declared in the maintainer’s client configuration. | Check documentation |
Read, search and edit files inside allowed directories with the Model Context Protocol reference Filesystem server.
Retrieve version-aware library documentation and code examples with Context7 MCP, using resolve-library-id and query-docs.
AI debugging with 980+ verified fixes. Search the YanHui KB — never repeat a mistake.
Content Registry MCP server. Tools: register content, verify content, search registry. Built...
MCP Server for interfacing with tmux sessions
lu.ma events MCP server with draft+confirm safety, audit logging, and prompt-injection scrubbing.…