Smartsheet

Retrieves column mapping and sample data from a Smartsheet, providing detailed column metadata including types, validation rules, format specifications, and auto-number configurations.

Alias for get_column_map providing identical functionality, maintaining backward compatibility with existing integrations.

Writes new rows to Smartsheet with intelligent handling of system-managed columns, multi-select picklist values, and formula-based columns, appending new rows to the bottom of the sheet.

Updates existing rows in a Smartsheet with support for partial updates, data integrity validation, and consistent handling of multi-select fields.

Deletes rows from a Smartsheet with support for batch deletion, row existence validation, and permission checking.

Performs advanced search across sheets with support for text search with regex, exact value matching for PICKLIST columns, and case-sensitive/whole word options.

Adds new columns to a Smartsheet supporting all column types with configurable options including position index, validation rules, formula definitions, and picklist options.

Safely deletes columns with dependency checking, validating formula references before deletion and preventing deletion of columns used in formulas.

Renames columns while preserving relationships, updating formula references automatically and maintaining data integrity.

Performs conditional bulk updates based on rules with support for multiple operators, type-specific comparisons, and batch processing with configurable size.

Retrieves all row IDs from a Smartsheet, useful for batch operations and data analysis, supporting large sheets efficiently.

Processes entire sheets or selected rows with AI analysis supporting summarization, sentiment analysis, custom scoring, and research impact assessment.

Tracks batch analysis progress providing detailed job statistics including total rows, processed count, failed count, and processing timestamps.

Cancels running batch analysis jobs with graceful process termination while maintaining data consistency.

Lists all accessible workspaces returning workspace IDs, names, permalinks, and access level information.

Retrieves detailed workspace information including contained sheets, folders, reports, dashboards, and permission details.

Creates a new workspace with specified name, returning the new workspace ID and confirmation for programmatic organization.

Creates a new sheet directly in a workspace supporting all column types and configurations, returning the new sheet ID and details.

Lists all sheets in a specific workspace returning sheet IDs, names, permalinks, and creation/modification timestamps.

Uploads files to sheets, rows, or comments with support for multiple attachment types and file size validation.

Lists all attachments for a sheet or row returning comprehensive metadata including file URLs, sizes, and creator information.

Downloads specific attachments to the local filesystem, creating directories as needed and verifying downloads.

Removes attachments from sheets with permission validation and deletion status reporting.

Creates new discussion threads on sheets or rows with support for initial comments and optional titles.

Adds comments to existing discussions maintaining threaded conversation structure.

Lists all discussions for sheets or rows with optional inclusion of all comments and participant information.

Gets all comments in a specific discussion thread including attachment information and chronological history.

Deletes specific comments from discussions with permission validation and deletion confirmation.

Gets modification history for individual cells including user attribution, timestamps, and tracking of value changes, formulas, and formatting.

Gets change history for entire rows providing chronological tracking of modifications.