Smartsheet Connector
Quickly build integrations connecting your B2B SaaS to Smartsheet.
About the Smartsheet Connector
Manage sheets, rows, and workspaces in the Smartsheet platform
Actions
Actions are tasks that you add to your workflow. One action might update records in a third-party API, while another action might fetch a list of records.
Jump to actions
Triggers
Triggers cause workflows to run. Some triggers run on a schedule. Others are invoked by a webhook request, or poll an API for new data. If a connector does not have a built-in trigger, you can use a generic scheduled or webhook trigger.
Jump to triggers
FAQs
Learn more about this connector and related integration functionality.
Jump to FAQs
Actions
| Action Name | Action Description |
|---|---|
| Get Contact | Retrieves a contact by its ID. |
| List Contacts | Lists all contacts for the authenticated user. |
| List Events | Lists events occurring in the Smartsheet organization account. |
| List Favorites | Lists all favorite items for the authenticated user. |
| Create Folder | Creates a new folder in a specified location. |
| Delete Folder | Deletes a folder by its ID. |
| Get Folder | Retrieves a folder by its ID. |
| List Folders | Lists folders, subfolders, or workspace folders. |
| Move Folder | Moves a folder to a specified destination. |
| Update Folder | Updates the name of a folder. |
| Get Group | Retrieves a group by its ID. |
| List Groups | Lists all groups in the organization. |
| List Home Contents | Lists all Home objects, including dashboards, folders, reports, sheets, templates, and workspaces. |
| Get Report | Retrieves a report including one page of rows, attachments, discussions, and source sheets. |
| List Reports | Lists all reports accessible to the authenticated user. |
| List Attachments on Row | Lists attachments on a row of a sheet. |
| Copy Rows | Copies rows to another sheet. |
| Delete Row | Deletes a row from a sheet. |
| Move Rows | Moves rows to another sheet. |
| Get Row | Retrieves the contents of a row by its ID. |
| Add/Update Row | Adds or updates a row on a sheet. |
| Search Sheets | Searches sheets for a specified phrase. |
| Get Sheet Attachment | Retrieves metadata for an attachment on a sheet. |
| List Attachments on Sheet | Lists all attachments on a sheet. |
| Delete Column | Deletes a column from a sheet. |
| Get Column | Retrieves a column by its ID. |
| Add Column to Sheet | Adds a column to a sheet. |
| List Columns | Lists all columns on a sheet. |
| Delete Comment | Deletes a comment by its ID. |
| Edit Comment | Edits a comment by its ID. |
| Get Comment | Retrieves a comment by its ID. |
| Add Comment | Adds a comment to a discussion. |
| Copy Sheet | Copies a sheet to a specified destination. |
| Create Sheet | Creates a new sheet with specified columns. |
| Delete Sheet | Deletes a sheet by its ID. |
| Delete Discussion | Deletes a discussion from a sheet or row. |
| Get Discussion | Retrieves a discussion by its ID. |
| List Discussion Attachments | Lists all attachments on a discussion. |
| Create Discussion | Creates a discussion on a sheet or row. |
| List Discussions | Lists discussions on a sheet or row. |
| Get Sheet | Retrieves a sheet by its ID. |
| Get Sheet Publish Status | Retrieves the publish status of a sheet. |
| Get Sheet Version | Retrieves the version number of a sheet. |
| List Sheets | Lists all sheets accessible to the authenticated user. |
| Move Sheet | Moves a sheet to a specified destination. |
| Set Sheet Publish Status | Sets the publish status of a sheet. |
| Send Sheet | Sends a sheet via email to specified recipients. |
| Update Sheet | Updates the properties of a sheet. |
| List User Templates | Lists user-created templates. |
| List Public Templates | Lists publicly available templates. |
| Get User | Retrieves a user by their ID. |
| List Users | Lists all users in the organization. |
| Create Webhook | Creates and enables a webhook for a specified resource. |
| Delete Instance Webhooks | Deletes all Smartsheet webhooks that point to a flow in this instance. |
| Delete Webhook | Deletes a webhook by its ID. |
| Get Webhook | Retrieves a webhook by its ID. |
| List Webhooks | Lists all webhooks owned by the authenticated user. |
| Create Workspace | Creates a new workspace. |
| Delete Workspace | Deletes a workspace by its ID. |
| Get Workspace | Retrieves a workspace by its ID. |
| List Workspaces | Lists all workspaces accessible to the authenticated user. |
| Update Workspace | Updates the properties of a workspace. |
| Raw Request | Sends a raw HTTP request to the Smartsheet API. |
Triggers
| Trigger Name | Trigger Description |
|---|---|
| Webhook | Receive and validate webhook requests from Smartsheet for manually configured webhook subscriptions. |
API Connectors
Integrate with customers' other SaaS apps, fast
Prismatic’s API connectors make it easy to integrate other SaaS apps – without reinventing the wheel. Triggers, actions, and auth are fully handled. And they work with all of Prismatic’s options for building integrations:
- Empower non-devs with a low-code designer
- Give devs freedom to build completely in code
- Let customers create their own workflows
