Skip to main content

Smartsheet

Project management and collaborative work management platform.

Categories: Project Management, Productivity

What you can ask​

  • List rows in the Q2 Roadmap sheet where status is At risk and the due date is within 7 days.
  • Add a row to the Intake sheet 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
  1. Go to Organization > Connectors and find Smartsheet.
  2. Click Enable and choose which tools to allow.
  3. 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.

ToolWhat it does
get_attachmentGet attachment details including download URL for file attachments.
get_columnGet a single column by ID.
get_current_userGet the current authenticated user's profile including email, name, locale, and account info.
get_discussionGet a discussion with all its comments.
get_folderGet a folder with its contents (sheets, subfolders, reports).
get_groupGet a group with its members.
get_rowGet a single row from a sheet by row ID.
get_sheetGet a sheet with its columns and rows.
get_userGet a user by ID.
get_webhookGet a webhook's details including status, events, and callback URL.
get_workspaceGet a workspace with its contents (sheets, folders, reports, dashboards).
list_attachmentsList all attachments on a sheet with pagination.
list_columnsList all columns in a sheet with pagination.
list_discussionsList all discussions on a sheet with pagination.
list_groupsList all groups in the organization with pagination.
list_home_foldersList folders at the home level with pagination.
list_reportsList all reports accessible to the user with pagination.
list_sheet_sharesList all shares on a sheet with pagination.
list_sheetsList all sheets accessible to the user with pagination.
list_usersList all users in the organization with pagination.
list_webhooksList all webhooks for the authenticated user with pagination.
list_workspacesList all workspaces with pagination.
searchSearch across all sheets, rows, and other objects.
search_sheetSearch within a specific sheet.
validate_credentialValidate Smartsheet API credentials by fetching current user profile.

Write (15)​

Create or send data.

ToolWhat it does
add_columnAdd a column to a sheet.
add_commentAdd a comment to an existing discussion.
add_group_membersAdd members to a group by email address.
add_rowsAdd rows to a sheet.
attach_urlAttach a URL to a sheet.
copy_rowsCopy rows from one sheet to another.
copy_sheetCopy a sheet to home, a workspace, or a folder.
create_discussionCreate a discussion on a sheet with an initial comment.
create_folderCreate a folder at home, inside another folder, or in a workspace.
create_groupCreate a new group with optional description and initial members (by email).
create_row_discussionCreate a discussion on a specific row with an initial comment.
create_sheetCreate a new sheet with specified columns.
create_webhookCreate a webhook to receive callbacks when a sheet changes.
create_workspaceCreate a new workspace.
share_sheetShare a sheet with users by email.

Delete or overwrite (23)​

Remove or replace existing data.

ToolWhat it does
delete_attachmentDelete an attachment from a sheet.
delete_columnDelete a column from a sheet.
delete_commentDelete a comment.
delete_discussionDelete a discussion and all its comments.
delete_folderPermanently delete a folder and all its contents.
delete_groupDelete a group.
delete_rowsDelete rows from a sheet by row IDs.
delete_shareRemove a share from a sheet.
delete_sheetPermanently delete a sheet.
delete_webhookDelete a webhook.
delete_workspacePermanently delete a workspace and all its contents.
move_rowsMove rows from one sheet to another.
remove_group_memberRemove a member from a group by user ID.
sort_sheetSort a sheet by one or more columns.
update_columnUpdate a column's title, type, or position.
update_commentUpdate a comment's text.
update_folderUpdate a folder name.
update_groupUpdate a group's name or description.
update_rowsUpdate existing rows in a sheet.
update_shareUpdate a share's access level.
update_sheetUpdate sheet properties like name.
update_webhookUpdate a webhook's enabled status or event subscriptions.
update_workspaceUpdate a workspace name.
⌘J