# 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

```bash
cd smartsheet-mcp-server
npm install
```

### 3. Build the Server

```bash
npm run build
```

### 4. Configure Claude Code

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

```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):

```bash
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.