Smartsheet
Available Tools
List all attachments on a sheet with pagination. Includes file attachments and URL links.
Attach a URL to a sheet. Supported types: LINK, BOX_COM, DROPBOX, EGNYTE, EVERNOTE, GOOGLE_DRIVE, ONEDRIVE.
Get attachment details including download URL for file attachments. Use list_attachments to find IDs.
Delete an attachment from a sheet. This cannot be undone. Use list_attachments to find IDs.
List all columns in a sheet with pagination. Returns column IDs, titles, types, and indices.
Add a column to a sheet. Specify title, type, and optional index for position. Use PICKLIST type with options for…
Get a single column by ID. Returns column title, type, options, and other properties.
Update a column’s title, type, or position. Use list_columns to find column IDs.
Delete a column from a sheet. This cannot be undone. Cannot delete the primary column.
List all discussions on a sheet with pagination. Includes discussion titles and comment counts.
Create a discussion on a sheet with an initial comment. Optionally provide a title.
Create a discussion on a specific row with an initial comment. Use get_sheet to find row IDs.
Get a discussion with all its comments. Use list_discussions to find valid discussion IDs.
Delete a discussion and all its comments. This cannot be undone.
Add a comment to an existing discussion. Use list_discussions to find discussion IDs.
Update a comment’s text. Use get_discussion to find comment IDs.
Delete a comment. This cannot be undone. Use get_discussion to find comment IDs.
List folders at the home level with pagination. Does not include workspace folders.
Create a folder at home, inside another folder, or in a workspace. Set parent_folder_id for subfolder, workspace_id for…
Get a folder with its contents (sheets, subfolders, reports). Use list_home_folders to find valid IDs.
Update a folder name. Use list_home_folders or get_workspace to find folder IDs.
Permanently delete a folder and all its contents. This cannot be undone.
List all groups in the organization with pagination. Groups can be used for sharing sheets.
Create a new group with optional description and initial members (by email). Requires admin privileges.
Get a group with its members. Use list_groups to find valid group IDs.
Update a group’s name or description. Use list_groups to find valid group IDs.
Delete a group. This cannot be undone. Members are not deleted.
Add members to a group by email address. Use get_group to see current members.
Remove a member from a group by user ID. Use get_group to find member user IDs.
List all reports accessible to the user with pagination. Reports aggregate data from multiple sheets.
Add rows to a sheet. Each row has cells with column_id and value. Use to_top/to_bottom/parent_id/sibling_id for…
Get a single row from a sheet by row ID. Use include parameter for additional data like discussions and attachments.
Update existing rows in a sheet. Each row must have id and cells to update. Can also reposition rows with…
Delete rows from a sheet by row IDs. This cannot be undone.
Move rows from one sheet to another. Rows are removed from the source sheet. Use list_sheets to find sheet IDs.
Copy rows from one sheet to another. Original rows remain in the source sheet. Use list_sheets to find sheet IDs.
Search across all sheets, rows, and other objects. Returns matching items with context data and parent references.
Search within a specific sheet. Returns matching rows and cells with context. Use list_sheets to find sheet IDs.
List all shares on a sheet with pagination. Shows who has access and their access level.
Share a sheet with users by email. Set access_level to VIEWER, EDITOR, EDITOR_SHARE, ADMIN, or OWNER.
Update a share’s access level. Use list_sheet_shares to find share IDs.
Remove a share from a sheet. The user will lose access. Use list_sheet_shares to find share IDs.
List all sheets accessible to the user with pagination. Use page and page_size to navigate results.
Create a new sheet with specified columns. At least one column must have primary=true. Use TEXT_NUMBER type for general…
Get a sheet with its columns and rows. Use include parameter for attachments, discussions, etc. Supports pagination for…
Update sheet properties like name. Use list_sheets to find valid sheet IDs.
Permanently delete a sheet. This cannot be undone. Use list_sheets to find valid sheet IDs.
Copy a sheet to home, a workspace, or a folder. Specify destination_type and destination_id for non-home destinations.
Sort a sheet by one or more columns. Each criterion needs column_id and direction (ASCENDING or DESCENDING).
Get the current authenticated user’s profile including email, name, locale, and account info.
List all users in the organization with pagination. Requires admin privileges.
Get a user by ID. Requires admin privileges. Use list_users to find valid user IDs.
Validate Smartsheet API credentials by fetching current user profile. Returns {success, message}.
List all webhooks for the authenticated user with pagination.
Create a webhook to receive callbacks when a sheet changes. Use ’.’ for events to subscribe to all events.
Get a webhook’s details including status, events, and callback URL. Use list_webhooks to find valid IDs.
Update a webhook’s enabled status or event subscriptions. Use list_webhooks to find valid IDs.
Delete a webhook. It will stop receiving callbacks. This cannot be undone.
List all workspaces with pagination. Returns workspace IDs, names, and access levels.
Create a new workspace. Workspaces organize sheets, reports, and dashboards.
Get a workspace with its contents (sheets, folders, reports, dashboards). Use list_workspaces to find valid IDs.
Update a workspace name. Use list_workspaces to find valid IDs.
Permanently delete a workspace and all its contents. This cannot be undone.