Smartsheet MCP Server

Smartsheet MCP Server

An MCP (Model Context Protocol) server that connects to your Smartsheet account, allowing Claude Code to browse workspaces, read sheets, and assist with documentation.

Available Tools

| Tool | Description | |------|-------------| | smartsheet_list_workspaces | List all workspaces you have access to | | smartsheet_get_workspace | Get workspace details including sheets and folders | | smartsheet_list_sheets | List all sheets across all workspaces | | smartsheet_get_sheet | Get full sheet data with columns and rows | | smartsheet_get_sheet_structure | Get only column definitions (no row data) | | smartsheet_search_sheets | Search sheets by name or content | | smartsheet_get_user | Get current authenticated user info | | smartsheet_generate_sheet_documentation | Generate markdown documentation for a sheet | | smartsheet_generate_workspace_documentation | Generate documentation for entire workspace |

Setup

1. Get Your Smartsheet API Key

1. Log in to Smartsheet
2. Click your profile icon (top right) → Apps & Integrations
3. Click API Access
4. Click Generate new access token
5. Copy the token (you won't see it again!)

2. Install Dependencies

cd smartsheet-mcp-server
npm install

3. Build the Server

npm run build

4. Configure Claude Code

Add this server to your Claude Code MCP configuration. Edit ~/.claude/settings.json:

{
  "mcpServers": {
    "smartsheet": {
      "command": "node",
      "args": ["/PROJECT_PATH_HERE/dist/index.js"],
      "env": {
        "SMARTSHEET_API_KEY": "YOUR_API_KEY_HERE"
      }
    }
  }
}

Or add to project-specific .claude/settings.json for project-scoped access.

5. Restart Claude Code

After adding the configuration, restart Claude Code to load the new MCP server.

Usage Examples

Once configured, you can ask Claude Code:

• "List all my Smartsheet workspaces"
• "Show me the structure of sheet ID 12345"
• "Generate documentation for my Project Tracker workspace"
• "Search for sheets related to 'budget'"

Development

Run in development mode (no build required):

SMARTSHEET_API_KEY=your_key npm run dev

Troubleshooting

"SMARTSHEET_API_KEY environment variable is required"

• Ensure the API key is set in your Claude Code MCP configuration

"Smartsheet API error (401)"

• Your API key is invalid or expired. Generate a new one in Smartsheet.

"Smartsheet API error (403)"

• You don't have permission to access the requested resource.