```

Features

Tools

get_column_map (Read)
Retrieves column mapping and sample data from a Smartsheet
Provides detailed column metadata including:
- Column types (system columns, formulas, picklists)
- Validation rules
- Format specifications
- Auto-number configurations
Returns sample data for context
Includes usage examples for writing data
smartsheet_write (Create)
Writes new rows to Smartsheet with intelligent handling of:
- System-managed columns
- Multi-select picklist values
- Formula-based columns
Implements automatic duplicate detection
Returns detailed operation results including row IDs
smartsheet_update (Update)
Updates existing rows in a Smartsheet
Supports partial updates (modify specific fields)
Maintains data integrity with validation
Handles multi-select fields consistently
Returns success/failure details per row
smartsheet_delete (Delete)
Deletes rows from a Smartsheet
Supports batch deletion of multiple rows
Validates row existence and permissions
Returns detailed operation results
smartsheet_add_column (Column Management)
Adds new columns to a Smartsheet
Supports all column types:
- TEXT_NUMBER
- DATE
- CHECKBOX
- PICKLIST
- CONTACT_LIST
Configurable options:
- Position index
- Validation rules
- Formula definitions
- Picklist options
Enforces column limit (400) with validation
Returns detailed column information
smartsheet_delete_column (Column Management)
Safely deletes columns with dependency checking
Validates formula references before deletion
Prevents deletion of columns used in formulas
Returns detailed dependency information
Supports force deletion option
smartsheet_rename_column (Column Management)
Renames columns while preserving relationships
Updates formula references automatically
Maintains data integrity
Validates name uniqueness
Returns detailed update information
smartsheet_bulk_update (Conditional Updates)
Performs conditional bulk updates based on rules
Supports complex condition evaluation:
- Multiple operators (equals, contains, greaterThan, etc.)
- Type-specific comparisons (text, dates, numbers)
- Empty/non-empty checks
Batch processing with configurable size
Comprehensive error handling and rollback
Detailed operation results tracking
start_batch_analysis (Healthcare Analytics)
Processes entire sheets or selected rows with AI analysis
Supports multiple analysis types:
- Summarization of clinical notes
- Sentiment analysis of patient feedback
- Custom scoring for healthcare initiatives
- Research impact assessment
Features:
- Automatic batch processing (50 rows per batch)
- Progress tracking and status monitoring
- Error handling with detailed reporting
- Customizable analysis goals
- Support for multiple source columns
get_job_status (Analysis Monitoring)
- Tracks batch analysis progress
- Provides detailed job statistics:
- Total rows to process
- Processed row count
- Failed row count
- Processing timestamps
- Real-ti

Categories

Current Category: batch-processing

smartsheet-server

firecrawl-mcp-server