Smartsheet

Tools · 30

• get_column_map Retrieves column mapping and sample data from a Smartsheet, providing detailed column metadata including types, validation rules, format specifications, and auto-number configurations.
• get_sheet_info Alias for get_column_map providing identical functionality, maintaining backward compatibility with existing integrations.
• smartsheet_write 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.
• smartsheet_update Updates existing rows in a Smartsheet with support for partial updates, data integrity validation, and consistent handling of multi-select fields.
• smartsheet_delete Deletes rows from a Smartsheet with support for batch deletion, row existence validation, and permission checking.
• smartsheet_search Performs advanced search across sheets with support for text search with regex, exact value matching for PICKLIST columns, and case-sensitive/whole word options.
• smartsheet_add_column Adds new columns to a Smartsheet supporting all column types with configurable options including position index, validation rules, formula definitions, and picklist options.
• smartsheet_delete_column Safely deletes columns with dependency checking, validating formula references before deletion and preventing deletion of columns used in formulas.
• smartsheet_rename_column Renames columns while preserving relationships, updating formula references automatically and maintaining data integrity.
• smartsheet_bulk_update Performs conditional bulk updates based on rules with support for multiple operators, type-specific comparisons, and batch processing with configurable size.
• get_all_row_ids Retrieves all row IDs from a Smartsheet, useful for batch operations and data analysis, supporting large sheets efficiently.
• start_batch_analysis Processes entire sheets or selected rows with AI analysis supporting summarization, sentiment analysis, custom scoring, and research impact assessment.
• get_job_status Tracks batch analysis progress providing detailed job statistics including total rows, processed count, failed count, and processing timestamps.
• cancel_batch_analysis Cancels running batch analysis jobs with graceful process termination while maintaining data consistency.
• list_workspaces Lists all accessible workspaces returning workspace IDs, names, permalinks, and access level information.
• get_workspace Retrieves detailed workspace information including contained sheets, folders, reports, dashboards, and permission details.
• create_workspace Creates a new workspace with specified name, returning the new workspace ID and confirmation for programmatic organization.
• create_sheet_in_workspace Creates a new sheet directly in a workspace supporting all column types and configurations, returning the new sheet ID and details.
• list_workspace_sheets Lists all sheets in a specific workspace returning sheet IDs, names, permalinks, and creation/modification timestamps.
• smartsheet_upload_attachment Uploads files to sheets, rows, or comments with support for multiple attachment types and file size validation.
• smartsheet_get_attachments Lists all attachments for a sheet or row returning comprehensive metadata including file URLs, sizes, and creator information.
• smartsheet_download_attachment Downloads specific attachments to the local filesystem, creating directories as needed and verifying downloads.
• smartsheet_delete_attachment Removes attachments from sheets with permission validation and deletion status reporting.
• smartsheet_create_discussion Creates new discussion threads on sheets or rows with support for initial comments and optional titles.
• smartsheet_add_comment Adds comments to existing discussions maintaining threaded conversation structure.
• smartsheet_get_discussions Lists all discussions for sheets or rows with optional inclusion of all comments and participant information.
• smartsheet_get_comments Gets all comments in a specific discussion thread including attachment information and chronological history.
• smartsheet_delete_comment Deletes specific comments from discussions with permission validation and deletion confirmation.
• smartsheet_get_cell_history Gets modification history for individual cells including user attribution, timestamps, and tracking of value changes, formulas, and formatting.
• smartsheet_get_row_history Gets change history for entire rows providing chronological tracking of modifications.