Smartsheet
Smartsheet is a collaborative work management platform for organizing projects, sheets, reports, dashboards, workflows, and teams.
180 actionsSign in with Smartsheet
What your bot can do in Smartsheet
Looks up
- Check FavoriteChecks whether a specific Smartsheet item is a favorite.
- Get Alternate EmailGet one alternate email.
- Get Asset ShareRetrieves a specific share for a Smartsheet asset.
- Get AttachmentFetch attachment metadata and, for files, a temporary download URL and its lifetime.
- Get Automation RuleReturns an automation rule, including its action values.
- Get ColumnGets the definition of a sheet column.
- Get CommentGets the comment specified by comment ID.
- Get ContactGet a specified Smartsheet contact by contact ID.
- Get Cross Sheet ReferenceGets a cross-sheet reference by ID.
- Get Current UserGet the connected Smartsheet user's profile.
Show 65 more
- Get DashboardGets a specified Smartsheet dashboard and its widgets.
- Get Dashboard PathGets the hierarchical folder and workspace path of a dashboard.
- Get Dashboard Publish StatusGets the publish settings for a Smartsheet dashboard.
- Get DiscussionGets the discussion specified by discussion ID.
- Get Folder MetadataGets the metadata of a Smartsheet folder.
- Get Folder PathGets the hierarchical path of a folder within its workspace.
- Get GroupGets a group and its members.
- Get Image URLsGenerate temporary read URLs for specified Smartsheet cell images.
- Get ProofGets a proof, optionally including attachments or discussions.
- Get ReportGet one report as a paged JSON object or an offloaded Excel or CSV file.
- Get Report ColumnGet one report column by its virtual ID.
- Get Report DefinitionGet a report's filters, grouping, summarizing, and sorting definition.
- Get Report PathGet the report's hierarchical folder and workspace path.
- Get Report Publish StatusGet a report's publishing settings.
- Get RowGet a Smartsheet row by sheet and row ID, with optional related row data.
- Get Sent Update RequestGets the specified sent update request on the sheet.
- Get Server InfoGet Smartsheet application constants, formats, and supported locales.
- Get SheetGets a sheet in the format specified, based on the sheet Id.
- Get Sheet PathGets the hierarchical path of the sheet, showing its location within folders and workspace, if workspace-level access is provided.
- Get Sheet Publish StatusGets the sheet's 'Publish' settings.
- Get Sheet SummaryReturns all summary fields defined on a sheet, including requested format or writer details.
- Get Sheet VersionGets the sheet version without loading the entire sheet.
- Get Update RequestGets an update request that has a future delivery schedule.
- Get UserGet a Smartsheet user by ID.
- Get WebhookGets a webhook owned by the connected API-token user, including its configured event patterns.
- Get Workspace MetadataGets metadata for a specified Smartsheet workspace.
- List Alternate EmailsList a user's alternate email addresses.
- List Asset SharesRetrieves one page of users and groups an asset is shared with and their access levels.
- List Attachment VersionsGet one page of an attachment's versions, ordered from newest to oldest.
- List Automation RulesReturns one page of automation rules associated with a sheet.
- List Cell HistoryReturn one page of cell modification history.
- List ColumnsGets one page of columns belonging to a sheet.
- List ContactsGet one page of the connected user's Smartsheet contacts and return a continuation cursor.
- List Cross Sheet ReferencesLists one page of cross-sheet references for a sheet.
- List DashboardsGets one page of dashboards the connected user can access.
- List Discussion AttachmentsGet one page of attachments in a Smartsheet discussion.
- List EventsFetch Smartsheet organization events for a System Admin.
- List FavoritesGets the user's favorites and returns one page with a continuation cursor.
- List Filtered EventsFetch events related to selected Smartsheet sheets and workspaces for a non-admin user.
- List Folder ChildrenReturns one page of immediate resources inside a Smartsheet folder.
- List Org GroupsGets one page of all groups in an organization account, with a continuation cursor.
- List Org SheetsGets a summarized list of all sheets owned by the members of the organization account.
- List Proof AttachmentsGets one page of non-discussion attachments in a proof.
- List Proof DiscussionsGets one page of discussions in a proof.
- List Proof Request ActionsGets one page of summarized request actions for a proof.
- List Proof VersionsGets one page of proof versions from newest to oldest.
- List ProofsGets one page of proofs for a sheet.
- List Report ColumnsList one page of columns for a report.
- List Report ScopeList one page of source sheets and workspaces in a report's scope.
- List ReportsList all reports accessible to the connected user.
- List Row AttachmentsGet one page of row- and row-discussion-level attachments on a Smartsheet row.
- List Row DiscussionsGets one page of discussions associated with a row.
- List Sent Update RequestsLists summarized sent update requests on the sheet.
- List Sheet AttachmentsGet one page of sheet-, row-, and discussion-level attachments on a sheet.
- List Sheet DiscussionsGets one page of discussions associated with a sheet.
- List SheetsGets a list of all sheets that the user has access to.
- List Summary FieldsReturns one page of sheet summary fields and a continuation cursor.
- List Update RequestsGets one page of update requests with future schedules and a continuation cursor.
- List User PlansList one token-paginated page of plans to which a user belongs.
- List UsersList organization users with optional email, plan, and seat filters.
- List WebhooksGets one page of webhooks owned by the connected API-token user.
- List Workspace ChildrenRetrieves one page of immediate child resources from a specified Smartsheet workspace.
- List WorkspacesRetrieves one page of workspace metadata for workspaces the connected user can access.
- Search EverythingSearches all sheets that the user can access, for the specified text.
- Search SheetGets a list of the user's search results in a sheet, based on a query.
Takes action
- Add Alternate EmailsAdd one or more alternate email addresses for a user.
- Add Attachment VersionUpload a new binary or multipart version of an existing sheet or row file attachment.
- Add Cell ImageUpload image bytes to a specific Smartsheet cell using the binary file marker contract.
- Add ColumnsInserts one or more columns into a sheet.
- Add FavoritesAdds one or more items to the user's Smartsheet favorites.
- Add GroupCreates a new organization group.
- Add Group MembersAdds one or more members to a group asynchronously.
- Add Report ColumnsAdd columns to a report.
- Add Report ScopeAdd source sheets to a report by sheet or parent workspace.
- Add RowsInsert one row or a batch of up to 500 rows, preserving Smartsheet location specifiers for top, bottom, parent, and sibling placement.
Show 95 more
- Add Summary Field ImageUploads raw image bytes to a sheet summary field.
- Add Summary FieldsCreates one or more summary fields on a sheet.
- Add UserAdd a user to the organization account.
- Attach To CommentAttach a file or supported provider URL to a comment.
- Attach To ProofAttaches a file of up to 30 MB to a proof.
- Attach To RowAttach a file or supported provider URL to a row.
- Attach To SheetAttach a file or supported provider URL to a sheet.
- Copy DashboardCreates a copy of a specified Smartsheet dashboard.
- Copy FolderCopies a Smartsheet folder.
- Copy Rows To Another SheetCopy selected rows to the bottom of another Smartsheet sheet.
- Copy SheetCreates a copy of the specified sheet.
- Copy WorkspaceCopies a Smartsheet workspace.
- Create Cross Sheet ReferencesCreates a cross-sheet reference and defines its source range.
- Create Discussion CommentAdds a comment to a discussion using JSON or multipart upload.
- Create Folder In FolderCreates a new folder inside an existing Smartsheet folder.
- Create Folder In WorkspaceCreates a new folder at the top level of a Smartsheet workspace.
- Create ProofCreates a proof on a row from an application/octet-stream file upload.
- Create Proof DiscussionCreates a discussion on a proof using exactly application/json or multipart/form-data.
- Create Proof RequestCreates and sends a proof request.
- Create Proof VersionCreates a proof version from a binary file upload.
- Create ReportCreate a report from a scope, columns, definition, and destination.
- Create Row DiscussionCreates a discussion on a row using JSON or multipart upload.
- Create Sheet DiscussionCreates a discussion on a sheet using JSON or multipart upload.
- Create Sheet In FolderCreates a sheet from scratch or from the specified template in the specified folder.
- Create Sheet In WorkspaceCreates a sheet from scratch or from the specified template at the top-level of the specified workspace.
- Create Update RequestCreates an update request and sends or schedules its email notification.
- Create WebhookCreates an inactive webhook owned by the connected API-token user.
- Create WorkspaceCreates a new Smartsheet workspace.
- Deactivate UserDeactivate a user in the current plan, blocking all Smartsheet use without changing existing item permissions.
- Delete Alternate EmailDelete an alternate email.
- Delete Asset ShareDeletes a share for a Smartsheet asset.
- Delete AttachmentDelete an attachment from a Smartsheet sheet.
- Delete Attachment VersionsDelete every version of an attachment, effectively removing a multi-version attachment from its parent object.
- Delete Automation RuleDeletes an automation rule from a sheet.
- Delete ColumnDeletes a column from a sheet.
- Delete CommentDeletes the specified comment.
- Delete DashboardDeletes a specified Smartsheet dashboard.
- Delete DiscussionDeletes the specified discussion.
- Delete FavoriteRemoves one item from the user's Smartsheet favorites.
- Delete FolderDeletes a Smartsheet folder.
- Delete GroupDeletes a group asynchronously.
- Delete Group MembersRemoves a member from a group asynchronously.
- Delete Multiple FavoritesRemoves multiple favorites of one type.
- Delete ProofDeletes an original proof and all its versions.
- Delete Proof RequestsDeletes all requests in a proof.
- Delete Proof VersionDeletes the current proof version identified by proof ID.
- Delete ReportDelete a report by ID.
- Delete Report ColumnDelete a column from a report.
- Delete RowsDelete one or more rows from a Smartsheet sheet.
- Delete Sent Update RequestDeletes a sent update request only while it is pending.
- Delete SheetDeletes the sheet specified in the URL.
- Delete Summary FieldsDeletes one or more summary fields from a sheet.
- Delete Update RequestTerminates future scheduled delivery of an update request.
- Delete WebhookPermanently deletes a webhook owned by the connected API-token user.
- Delete WorkspacePermanently deletes a Smartsheet workspace.
- Downgrade UserIrreversibly downgrade a user's seat in a specified plan.
- Edit CommentUpdates comment text.
- Import Sheet Into FolderImports CSV or XLSX data into a new sheet in the specified folder.
- Import Sheet Into WorkspaceImports CSV or XLSX data into a new sheet in the specified workspace.
- Make Alternate Email PrimaryMake a confirmed alternate address the user's primary email.
- Move DashboardMoves a specified Smartsheet dashboard to another container.
- Move FolderMoves a Smartsheet folder to another container.
- Move Rows To Another SheetMove selected rows to the bottom of another Smartsheet sheet.
- Move SheetMoves the specified sheet to a new location.
- Reactivate UserReactivate a user deactivated less than 30 days ago.
- Remove Report ScopeRemove source sheets from a report by sheet or parent workspace.
- Remove User From OrganizationRemove a user from the organization, optionally removing shares or transferring assets.
- Remove User From PlanDeactivate a user's membership in a plan while preserving ownership and read-only access.
- Reset Webhook Shared SecretIrreversibly rotates a webhook secret owned by the connected API-token user after explicit confirmation.
- Send Report By EmailSend a report attachment by email.
- Send Rows By EmailSend selected Smartsheet rows by email.
- Send Sheet By EmailSends the sheet as a PDF attachment via email to the designated recipients.
- Set Dashboard Publish StatusPublishes or unpublishes a Smartsheet dashboard.
- Set Report Publish StatusSet report publishing status and return the resulting public URL when enabled.
- Set Sheet Publish StatusSets the publish status of the sheet and returns the new status, including the URLs of any enabled publishings.
- Share AssetShares a Smartsheet asset with specified users or groups.
- Sort Rows In SheetSort all rows in a Smartsheet sheet by one or more prioritized column criteria.
- Update Asset ShareUpdates the access level of a share for a Smartsheet asset.
- Update Automation RuleUpdates an existing automation rule.
- Update ColumnUpdates, moves, or renames a sheet column.
- Update DashboardRenames a specified Smartsheet dashboard.
- Update FolderUpdates a Smartsheet folder.
- Update GroupUpdates a group.
- Update Proof StatusSets a proof as complete or incomplete.
- Update Report ColumnUpdate a report column's title, position, visibility, or width.
- Update Report DefinitionCreate or entirely replace a report definition.
- Update RowsUpdate one row or a batch of up to 500 rows, including cells and location operations such as moving, indenting, or outdenting.
- Update SheetUpdates the sheet specified in the URL.
- Update Summary FieldsUpdates summary fields on a sheet.
- Update Update RequestChanges an update request that still has a future scheduled delivery.
- Update UserUpdate user attributes.
- Update User Profile ImageUpload a GIF, JPG, or PNG profile image using the provider's binary, multipart, or JSON URL form.
- Update WebhookUpdates a webhook owned by the connected API-token user.
- Update WorkspaceUpdates a Smartsheet workspace.
- Upgrade UserIrreversibly upgrade a user's seat in a specified plan.