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