Summary
Sheet edits that respect the sheet.
Smartsheet is not a spreadsheet you can safely write to blindly: column types and formula references make some writes valid and others destructive. Reading the structure first and validating against it is what makes an automated update survivable.
What it is
An MCP server for Smartsheet covering document management, data operations and column customisation. It validates against column types, preserves and updates formula references as rows change, and adds batch processing and custom scoring for larger analytical workloads.
What you get
- A sheet's structure and metadata read before anything is changed (get_sheet_info)
- A column map of the sheet, so updates address the right columns (get_column_map)
- Create, update and delete across rows and columns, validated against the column types
- Formula references preserved and updated automatically as the sheet changes
- Batch processing for large datasets
- Custom scoring systems applied to sheet data
- Error handling and validation at each layer, with referential integrity maintained across operations
Requirements
Both runtimes installed: the server pairs a Node MCP layer with the smartsheet_ops Python package, so it needs Node.js and Python — plus Smartsheet access for the sheets you intend to touch.