Smartsheet MCP Server

smartsheet_bulk_update

Perform conditional bulk updates on a Smartsheet

Input Schema

NameRequiredDescriptionDefault
optionsNoUpdate options
rulesYesList of update rules
sheet_idYesSmartsheet sheet ID

Input Schema (JSON Schema)

{ "properties": { "options": { "description": "Update options", "properties": { "batchSize": { "default": 500, "description": "Number of rows per batch", "type": "number" }, "lenientMode": { "default": false, "description": "Allow partial success", "type": "boolean" } }, "type": "object" }, "rules": { "description": "List of update rules", "items": { "properties": { "conditions": { "description": "Conditions to evaluate (AND logic)", "items": { "properties": { "columnId": { "description": "Column ID to check", "type": "string" }, "operator": { "description": "Comparison operator", "enum": [ "equals", "contains", "greaterThan", "lessThan", "isEmpty", "isNotEmpty" ], "type": "string" }, "value": { "description": "Value to compare against (not needed for isEmpty/isNotEmpty)", "type": [ "string", "number", "boolean", "null" ] } }, "required": [ "columnId", "operator" ], "type": "object" }, "type": "array" }, "updates": { "description": "Updates to apply when conditions are met", "items": { "properties": { "columnId": { "description": "Column ID to update", "type": "string" }, "value": { "description": "New value to set", "type": [ "string", "number", "boolean", "null" ] } }, "required": [ "columnId", "value" ], "type": "object" }, "type": "array" } }, "required": [ "conditions", "updates" ], "type": "object" }, "type": "array" }, "sheet_id": { "description": "Smartsheet sheet ID", "type": "string" } }, "required": [ "sheet_id", "rules" ], "type": "object" }