Smartsheet MCP Server

About

## Smartsheet MCP Server: Work Management The **Smartsheet MCP Server** integrates Smartsheet's enterprise work management platform into Google Antigravity, enabling developers to manage projects, automate workflows, and collaborate through AI-assisted productivity. ### Why Smartsheet MCP? - **Flexible Views**: Grid, Gantt, calendar, and card views - **Automations**: No-code workflow automation - **Resource Management**: Track team capacity and allocation - **Forms**: Collect data with customizable forms - **Reports**: Build cross-sheet reports and dashboards ### Key Features #### 1. Sheet and Row Operations ```javascript // Create sheet from template const sheet = await smartsheet.createSheetFromTemplate({ name: "Q1 Project Plan", templateId: "template_123", folderId: "folder_456" }); // Add rows await smartsheet.addRows({ sheetId: sheet.id, rows: [ { toBottom: true, cells: [ { columnId: col1Id, value: "Implement API" }, { columnId: col2Id, value: "In Progress" }, { columnId: col3Id, value: "2024-12-20" } ] } ] }); // Update row await smartsheet.updateRow({ sheetId: sheet.id, rowId: row.id, cells: [ { columnId: statusColId, value: "Complete" } ] }); // Search sheets const results = await smartsheet.search({ query: "project plan Q1" }); ``` #### 2. Reports and Automation ```javascript // Create report const report = await smartsheet.createReport({ name: "Active Projects", sourceSheets: [sheet1Id, sheet2Id], filter: { operator: "AND", criteria: [ { columnId: statusColId, operator: "NOT_EQUAL", values: ["Complete"] } ] } }); // Get report data const reportData = await smartsheet.getReport({ reportId: report.id }); // Create automation rule await smartsheet.createAutomation({ sheetId: sheet.id, name: "Notify on Due Date", trigger: { type: "DATE_REACHED", columnId: dueDateColId }, action: { type: "NOTIFY", recipients: ["team@company.com"] } }); ``` ### Configuration ```json { "mcpServers": { "smartsheet": { "command": "npx", "args": ["-y", "@anthropic/mcp-smartsheet"], "env": { "SMARTSHEET_ACCESS_TOKEN": "your-access-token" } } } } ``` ### Use Cases **Project Management**: Manage complex projects with dependencies and resources. **Portfolio Tracking**: Track multiple projects in unified dashboards. **Process Automation**: Automate repetitive workflows and notifications. The Smartsheet MCP Server brings enterprise work management to your workflow.

Installation

{
  "mcpServers": {
    "smartsheet": {
      "mcpServers": {
        "smartsheet": {
          "env": {
            "SMARTSHEET_ACCESS_TOKEN": "your-access-token"
          },
          "args": [
            "-y",
            "smartsheet-mcp-server"
          ],
          "command": "npx"
        }
      }
    }
  }
}

How to Use

1. 1Generate Smartsheet access token
2. 2Configure API
3. 3Manage sheets