Smartsheet
Project management and collaborative work management platform.
Categories: Project Management, Productivity
What you can ask
- List rows in the
Q2 Roadmapsheet where status isAt riskand the due date is within 7 days. - Add a row to the
Intakesheet for each new ticket from this morning. - Pull the rollup of completed tasks per workstream for last week.
Set up
Smartsheet connects with credentials from your Smartsheet account. Have these values ready:
- Access token
- Go to Organization > Connectors and find Smartsheet.
- Click Enable and choose which tools to allow.
- Each member enters their own values the first time they use it.
To use one account for the whole organization, turn on Share one connection with everyone. Every member's agents then act as that account, with exactly the access it has.
Tools
Smartsheet offers 63 tools. Admins choose which ones agents can use. See Tool permission groups.
Read (25)
View and search information without changing it.
| Tool | What it does |
|---|---|
get_attachment | Get attachment details including download URL for file attachments. |
get_column | Get a single column by ID. |
get_current_user | Get the current authenticated user's profile including email, name, locale, and account info. |
get_discussion | Get a discussion with all its comments. |
get_folder | Get a folder with its contents (sheets, subfolders, reports). |
get_group | Get a group with its members. |
get_row | Get a single row from a sheet by row ID. |
get_sheet | Get a sheet with its columns and rows. |
get_user | Get a user by ID. |
get_webhook | Get a webhook's details including status, events, and callback URL. |
get_workspace | Get a workspace with its contents (sheets, folders, reports, dashboards). |
list_attachments | List all attachments on a sheet with pagination. |
list_columns | List all columns in a sheet with pagination. |
list_discussions | List all discussions on a sheet with pagination. |
list_groups | List all groups in the organization with pagination. |
list_home_folders | List folders at the home level with pagination. |
list_reports | List all reports accessible to the user with pagination. |
list_sheet_shares | List all shares on a sheet with pagination. |
list_sheets | List all sheets accessible to the user with pagination. |
list_users | List all users in the organization with pagination. |
list_webhooks | List all webhooks for the authenticated user with pagination. |
list_workspaces | List all workspaces with pagination. |
search | Search across all sheets, rows, and other objects. |
search_sheet | Search within a specific sheet. |
validate_credential | Validate Smartsheet API credentials by fetching current user profile. |
Write (15)
Create or send data.
| Tool | What it does |
|---|---|
add_column | Add a column to a sheet. |
add_comment | Add a comment to an existing discussion. |
add_group_members | Add members to a group by email address. |
add_rows | Add rows to a sheet. |
attach_url | Attach a URL to a sheet. |
copy_rows | Copy rows from one sheet to another. |
copy_sheet | Copy a sheet to home, a workspace, or a folder. |
create_discussion | Create a discussion on a sheet with an initial comment. |
create_folder | Create a folder at home, inside another folder, or in a workspace. |
create_group | Create a new group with optional description and initial members (by email). |
create_row_discussion | Create a discussion on a specific row with an initial comment. |
create_sheet | Create a new sheet with specified columns. |
create_webhook | Create a webhook to receive callbacks when a sheet changes. |
create_workspace | Create a new workspace. |
share_sheet | Share a sheet with users by email. |
Delete or overwrite (23)
Remove or replace existing data.
| Tool | What it does |
|---|---|
delete_attachment | Delete an attachment from a sheet. |
delete_column | Delete a column from a sheet. |
delete_comment | Delete a comment. |
delete_discussion | Delete a discussion and all its comments. |
delete_folder | Permanently delete a folder and all its contents. |
delete_group | Delete a group. |
delete_rows | Delete rows from a sheet by row IDs. |
delete_share | Remove a share from a sheet. |
delete_sheet | Permanently delete a sheet. |
delete_webhook | Delete a webhook. |
delete_workspace | Permanently delete a workspace and all its contents. |
move_rows | Move rows from one sheet to another. |
remove_group_member | Remove a member from a group by user ID. |
sort_sheet | Sort a sheet by one or more columns. |
update_column | Update a column's title, type, or position. |
update_comment | Update a comment's text. |
update_folder | Update a folder name. |
update_group | Update a group's name or description. |
update_rows | Update existing rows in a sheet. |
update_share | Update a share's access level. |
update_sheet | Update sheet properties like name. |
update_webhook | Update a webhook's enabled status or event subscriptions. |
update_workspace | Update a workspace name. |