Smartsheet Connector
Smartsheet is a software as a service offering for collaboration and work management, developed and marketed by Smartsheet Inc.
This component allows managing and interacting with Smartsheet sheets.
API Documentation
This component was built using the Smartsheet API Documentation
Connections
API Key
Authenticate requests using an API key.
API keys can be used for development purposes, though an OAuth 2.0 connection is recommended for production integrations.
Refer to the Smartsheet API key documentation for instructions on generating an API key.
Configure the Connection
Create a connection of type API Key and configure the following fields:
- Base URL: Select the Smartsheet API base URL. Most applications use the commercial endpoint. Government entities should select the government endpoint.
- API Key: Enter the API key generated from the Smartsheet account settings.
| Input | Comments | Default |
|---|---|---|
| Base URL | Most applications use Smartsheet commercial. Government entities should select the government endpoint. | https://api.smartsheet.com/2.0/ |
| API Key | The API key generated from the Smartsheet account settings. |
OAuth 2.0
Authenticate requests using OAuth 2.0.
To authenticate with Smartsheet through OAuth 2.0, create and configure an app within the Smartsheet account.
Prerequisites
- A Smartsheet account with access to Developer Tools
- A developer profile created in Smartsheet
Setup Steps
- Log in to Smartsheet
- Navigate to the profile icon (bottom left) and select Developer Tools
- Create a developer profile if one does not already exist
- Click Create New App
- Configure the app:
- App Name: Enter the application name
- App Description: Add a brief description
- App Logo: Optional
- Publish App: Leave unchecked (not required)
- App Redirect URL: Enter
https://oauth2.integrations.acme.com/callback
- Save the app and note the generated credentials:
- App Client ID
- App Secret
Configure the Connection
Create a connection of type OAuth 2.0 and configure the following fields:
- API Domain: Select the Smartsheet API domain. Most applications use the commercial domain (
api.smartsheet.com). Government entities should select the government endpoint (api.smartsheetgov.com). - App Domain: Select the Smartsheet application domain. This should match the API domain selection.
- Scopes: A space-separated list of permissions to request. Remove any permissions not needed. Refer to the available scopes documentation for details.
- App Client ID: Enter the client ID generated from the Smartsheet app.
- App Secret: Enter the client secret generated from the Smartsheet app.
This connection uses OAuth 2.0, a common authentication mechanism for integrations. Read about how OAuth 2.0 works here.
| Input | Comments | Default |
|---|---|---|
| API Domain | Select the Smartsheet API domain. Most applications use commercial, but government entities should use the government endpoint. | api.smartsheet.com |
| App Domain | Select the Smartsheet application domain. This should match the API domain selection. | app.smartsheet.com |
| Scopes | A space-separated list of permissions to request. Remove any permissions not needed. See available scopes for details. | ADMIN_SHEETS ADMIN_SIGHTS ADMIN_USERS ADMIN_WEBHOOKS ADMIN_WORKSPACES CREATE_SHEETS CREATE_SIGHTS DELETE_SHEETS DELETE_SIGHTS READ_CONTACTS READ_EVENTS READ_SHEETS READ_SIGHTS READ_USERS SHARE_SHEETS SHARE_SIGHTS WRITE_SHEETS |
| App Client ID | The client ID generated when creating an app within Smartsheet's Developer Tools. | |
| App Secret | The client secret generated when creating an app within Smartsheet's Developer Tools. |
OAuth 2.0 (Deprecated)
Authenticate requests using OAuth 2.0. Deprecated in favor of the templated OAuth 2.0 connection.
Deprecation Notice
This connection type is deprecated. Use the OAuth 2.0 connection instead, which provides a simplified configuration with templated URLs.
To authenticate with Smartsheet through OAuth 2.0, create and configure an app within the Smartsheet account.
Prerequisites
- A Smartsheet account with access to Developer Tools
- A developer profile created in Smartsheet
Setup Steps
- Log in to Smartsheet
- Navigate to the profile icon (bottom left) and select Developer Tools
- Create a developer profile if one does not already exist
- Click Create New App
- Configure the app:
- App Name: Enter the application name
- App Description: Add a brief description
- App Logo: Optional
- Publish App: Leave unchecked (not required)
- App Redirect URL: Enter
https://oauth2.integrations.acme.com/callback
- Save the app and note the generated credentials:
- App Client ID
- App Secret
Configure the Connection
Create a connection of type OAuth 2.0 (Deprecated) and configure the following fields:
- Base URL: Select the Smartsheet API base URL. Most applications use the commercial endpoint. Government entities should select the government endpoint.
- Authorization URL: Select the OAuth 2.0 authorization endpoint for Smartsheet.
- Token URL: Select the OAuth 2.0 token exchange endpoint for Smartsheet.
- Scopes: A space-separated list of permissions to request. Remove any permissions not needed. Refer to the available scopes documentation for details.
- App Client ID: Enter the client ID generated from the Smartsheet app.
- App Secret: Enter the client secret generated from the Smartsheet app.
This connection uses OAuth 2.0, a common authentication mechanism for integrations. Read about how OAuth 2.0 works here.
| Input | Comments | Default |
|---|---|---|
| Base URL | Most applications use Smartsheet commercial. Government entities should select the government endpoint. | https://api.smartsheet.com/2.0/ |
| Authorization URL | The OAuth 2.0 authorization endpoint for Smartsheet. | https://app.smartsheet.com/b/authorize |
| Token URL | The OAuth 2.0 token exchange endpoint for Smartsheet. | https://api.smartsheet.com/2.0/token |
| Scopes | A space-separated list of permissions to request. Remove any permissions not needed. See available scopes for details. | ADMIN_SHEETS ADMIN_SIGHTS ADMIN_USERS ADMIN_WEBHOOKS ADMIN_WORKSPACES CREATE_SHEETS CREATE_SIGHTS DELETE_SHEETS DELETE_SIGHTS READ_CONTACTS READ_EVENTS READ_SHEETS READ_SIGHTS READ_USERS SHARE_SHEETS SHARE_SIGHTS WRITE_SHEETS |
| App Client ID | The client ID generated when creating an app within Smartsheet's Developer Tools. | |
| App Secret | The client secret generated when creating an app within Smartsheet's Developer Tools. |
Triggers
Webhook
Receive and validate webhook requests from Smartsheet for manually configured webhook subscriptions.
Actions
Add Column to Sheet
Adds a column to a sheet.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Title | The display name for the column header. | |
| Type | The data type for the column. Determines how cell values are displayed and validated. | |
| Formula | The formula for a column. | |
| Hidden | When true, the column is hidden from view in the sheet. | false |
| Position Index | The 0-based position where the column should be inserted in the sheet. | 0 |
| Description | Additional context or instructions displayed below the column header. | |
| Locked | When true, the column is locked and cannot be edited by users without appropriate permissions. | false |
| Options | A JSON array of selectable values for picklist or multi-picklist columns. | |
| Validation | When true, cell value validation rules are enforced for the column. | false |
| Width | Display width of the column in pixels. |
Add Comment
Adds a comment to a discussion.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Discussion ID | The unique identifier for the discussion. | |
| Text | The text content of the comment. |
Add/Update Row
Adds or updates a row on a sheet.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Row ID (Optional) | The unique identifier of an existing row to update. Omit to add a new row instead. | |
| Dynamic Columns Values | A JSON array of objects mapping column titles to cell values for the row. Use this when column titles are easier to reference than column IDs. | |
| Column Values | A list of column names mapped to the values to write into them. | |
| Row Position (for new rows) | The position where new rows are added to the sheet. | toBottom |
| Allow Partial Success | When true, allows the bulk operation to partially succeed if some rows fail validation rather than failing the entire request. | false |
| Override Validation | When true, allows cell values outside of the validation limits defined on the column. | false |
Copy Rows
Copies rows to another sheet.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Source Sheet ID | The unique identifier of the sheet to copy or move rows from. | |
| Row IDs | The unique identifiers of the rows to move or copy from the source sheet. | |
| Destination Sheet ID | The unique identifier of the sheet to move or copy rows into. |
Copy Sheet
Copies a sheet to a specified destination.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Destination ID | The ID of the destination container (when copying or moving a sheet or a folder). | |
| Destination Type | The type of container to copy or move the resource into. | home |
| New Name | The display name to assign to the copied resource. |
Create Discussion
Creates a discussion on a sheet or row.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Row ID (Optional) | The unique identifier for the row. Leave empty to apply to the sheet level. | |
| Comment | The text content to post as a new discussion comment. |
Create Folder
Creates a new folder in a specified location.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Folder ID | The unique identifier of the parent folder to create a subfolder within. Omit to create a top-level home folder. | |
| Workspace ID (Optional) | The unique identifier of the workspace to create the folder in. Omit to create the folder outside of a workspace. | |
| Folder Name | The display name for the folder. |
Create Sheet
Creates a new sheet with specified columns.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Folder ID | The unique identifier of the folder to create the sheet in. Omit to create a top-level sheet. | |
| Workspace ID (Optional) | The unique identifier for the workspace. Leave empty to use the default context. | |
| Sheet Name | The display name for the new sheet. | |
| Columns | See Smartsheet API documentation for additional information about column types. | |
Create Webhook
Creates and enables a webhook for a specified resource.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Callback URL | The URL that Smartsheet sends webhook notifications to. This is usually a reference to another flow's webhook URL. | |
| Webhook Name | A descriptive label to identify the webhook in the dashboard. | |
| Sheet ID | The unique identifier for the sheet. | |
| Subscope Column IDs | When provided, the webhook only fires when these specific columns are modified. Leave empty to trigger on any change to the sheet. Use the List Columns action to find column IDs for a sheet. | |
| Allow Duplicates? | By default this action checks if a webhook with this callback and sheet ID already exists. If it does, this action does not configure a new webhook. Toggle this to true to allow the creation of duplicate webhooks. | false |
Create Workspace
Creates a new workspace.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Workspace Name | The display name for the workspace. |
Delete Column
Deletes a column from a sheet.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Column ID | The unique identifier for the column. |
Delete Comment
Deletes a comment by its ID.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Comment ID | The unique identifier for the comment. |
Delete Discussion
Deletes a discussion from a sheet or row.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Discussion ID | The unique identifier for the discussion. |
Delete Folder
Deletes a folder by its ID.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Folder ID | The unique identifier for the folder. Folders can contain sheets, sights, reports, templates, and other folders. |
Delete Instance Webhooks
Deletes all Smartsheet webhooks that point to a flow in this instance.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. |
Delete Row
Deletes a row from a sheet.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Row ID | The unique identifier for the row. |
Delete Sheet
Deletes a sheet by its ID.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. |
Delete Webhook
Deletes a webhook by its ID.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Webhook ID | The unique identifier for the webhook. |
Delete Workspace
Deletes a workspace by its ID.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Workspace ID | The unique identifier for the workspace. |
Edit Comment
Edits a comment by its ID.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Comment ID | The unique identifier for the comment. | |
| Text | The text content of the comment. |
Get Column
Retrieves a column by its ID.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Column ID | The unique identifier for the column. |
Get Comment
Retrieves a comment by its ID.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Comment ID | The unique identifier for the comment. |
Get Contact
Retrieves a contact by its ID.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Contact ID | The unique identifier for the contact. |
Get Discussion
Retrieves a discussion by its ID.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Discussion ID | The unique identifier for the discussion. |
Get Folder
Retrieves a folder by its ID.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Folder ID | The unique identifier for the folder. Folders can contain sheets, sights, reports, templates, and other folders. |
Get Group
Retrieves a group by its ID.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Group ID | The unique identifier for the group. |
Get Report
Retrieves a report including one page of rows, attachments, discussions, and source sheets.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Report ID | The unique identifier for the report. | |
| Pagination Page Size (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | |
| Pagination Page (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | 1 |
Get Row
Retrieves the contents of a row by its ID.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Row ID | The unique identifier for the row. |
Get Sheet
Retrieves a sheet by its ID.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Pagination Page Size (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | |
| Pagination Page (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | 1 |
Get Sheet Attachment
Retrieves metadata for an attachment on a sheet.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Attachment ID | The unique identifier for the attachment. |
Get Sheet Publish Status
Retrieves the publish status of a sheet.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. |
Get Sheet Version
Retrieves the version number of a sheet.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. |
Get User
Retrieves a user by their ID.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| User ID | The unique identifier of the user to fetch. Enter "me" to retrieve the currently authenticated user. |
Get Webhook
Retrieves a webhook by its ID.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Webhook ID | The unique identifier for the webhook. |
Get Workspace
Retrieves a workspace by its ID.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Workspace ID | The unique identifier for the workspace. | |
| Load All | Preserved for backward compatibility. Smartsheet's redesigned API no longer supports recursive nested expansion of folders/contents in a single response; this input has no effect on the migrated action. | false |
List Attachments on Row
Lists attachments on a row of a sheet.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Row ID | The unique identifier for the row. | |
| Pagination Page (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | 1 |
| Pagination Page Size (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | |
| Fetch All (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | false |
List Attachments on Sheet
Lists all attachments on a sheet.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Pagination Page (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | 1 |
| Pagination Page Size (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | |
| Fetch All (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | false |
List Columns
Lists all columns on a sheet.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Pagination Page (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | 1 |
| Pagination Page Size (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | |
| Fetch All (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | false |
List Contacts
Lists all contacts for the authenticated user.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Fetch All (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | false |
| Pagination Page (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | 1 |
| Pagination Page Size (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. |
List Discussion Attachments
Lists all attachments on a discussion.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Discussion ID | The unique identifier for the discussion. | |
| Pagination Page (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | 1 |
| Pagination Page Size (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | |
| Fetch All (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | false |
List Discussions
Lists discussions on a sheet or row.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Row ID (Optional) | The unique identifier for the row. Leave empty to apply to the sheet level. | |
| Pagination Page (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | 1 |
| Pagination Page Size (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | |
| Fetch All (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | false |
List Events
Lists events occurring in the Smartsheet organization account.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Since | The starting timestamp for events to return. Format: ISO 8601 (e.g. 2010-01-01T00:00:00Z). | 2010-01-01T00:00:00Z |
| Stream Position | The pagination cursor used to retrieve the next set of events. Returned by a previous request. | |
| Max Count | The maximum number of events to return in a single response. |
List Favorites
Lists all favorite items for the authenticated user.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Fetch All (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | false |
| Pagination Page (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | 1 |
| Pagination Page Size (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. |
List Folders
Lists folders, subfolders, or workspace folders.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Folder ID | The unique identifier of the parent folder whose subfolders should be listed. Omit to list top-level home folders. | |
| Workspace ID (Optional) | The unique identifier of the workspace whose folders should be listed. Omit to list folders outside of a workspace. | |
| Fetch All (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | false |
| Pagination Page (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | 1 |
| Pagination Page Size (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. |
List Groups
Lists all groups in the organization.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Fetch All (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | false |
| Modified Since | When specified with a date and time value, response only includes the objects that are modified on or after the date and time specified. Format: ISO 8601 (e.g. 2023-01-01T00:00:00Z). | |
| Pagination Page (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | 1 |
| Pagination Page Size (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. |
List Home Contents
Lists all Home objects, including dashboards, folders, reports, sheets, templates, and workspaces.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. |
List Public Templates
Lists publicly available templates.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Fetch All (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | false |
| Pagination Page (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | 1 |
| Pagination Page Size (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. |
List Reports
Lists all reports accessible to the authenticated user.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Modified Since | When specified with a date and time value, response only includes the objects that are modified on or after the date and time specified. Format: ISO 8601 (e.g. 2023-01-01T00:00:00Z). |
List Sheets
Lists all sheets accessible to the authenticated user.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Fetch All (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | false |
| Modified Since | When specified with a date and time value, response only includes the objects that are modified on or after the date and time specified. Format: ISO 8601 (e.g. 2023-01-01T00:00:00Z). | |
| Pagination Page (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | 1 |
| Pagination Page Size (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. |
List Users
Lists all users in the organization.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| The email address to filter users by. | ||
| Fetch All (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | false |
| Modified Since | When specified with a date and time value, response only includes the objects that are modified on or after the date and time specified. Format: ISO 8601 (e.g. 2023-01-01T00:00:00Z). | |
| Pagination Page (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | 1 |
| Pagination Page Size (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. |
List User Templates
Lists user-created templates.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Workspace ID | Optional. When supplied, fetches templates from this single workspace only — fast, single API call. When omitted, the action paginates ALL workspaces and aggregates templates from each — this preserves backwards compatibility with the legacy GET /templates response shape but may be slow and rate-limit-sensitive on accounts with many workspaces (chunked-parallel concurrency 5). Recommend supplying a workspace ID for production flows. | |
| Fetch All (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | false |
| Pagination Page (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | 1 |
| Pagination Page Size (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. |
List Webhooks
Lists all webhooks owned by the authenticated user.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Show All | When true, returns all webhooks for the account (including those for other apps and instances). When false, returns only webhooks whose callback URLs match a flow in the current instance. | false |
List Workspaces
Lists all workspaces accessible to the authenticated user.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Fetch All (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | false |
| Pagination Page (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. | 1 |
| Pagination Page Size (Deprecated) | DEPRECATED — has no effect on actions migrated for the 2026-06-03 Smartsheet sunset. Preserved for backwards compatibility on those actions; will be removed in a future major release. |
Move Folder
Moves a folder to a specified destination.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Folder ID | The unique identifier for the folder. Folders can contain sheets, sights, reports, templates, and other folders. | |
| Destination Folder ID | The unique identifier for the folder. Folders can contain sheets, sights, reports, templates, and other folders. |
Move Rows
Moves rows to another sheet.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Row IDs | The unique identifiers of the rows to move or copy from the source sheet. | |
| Destination Sheet ID | The unique identifier of the sheet to move or copy rows into. |
Move Sheet
Moves a sheet to a specified destination.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Destination ID | The ID of the destination container (when copying or moving a sheet or a folder). | |
| Destination Type | The type of container to copy or move the resource into. | home |
Raw Request
Sends a raw HTTP request to the Smartsheet API.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| URL | Input the path only (/reports), The base URL is already included (https://api.smartsheet.com/2.0). For example, to connect to https://api.smartsheet.com/2.0/reports, only /reports is entered in this field. | |
| Method | The HTTP method to use. | |
| Data | The HTTP body payload to send to the URL. | |
| Form Data | The Form Data to be sent as a multipart form upload. | |
| File Data | File Data to be sent as a multipart form upload. | |
| File Data File Names | File names to apply to the file data inputs. Keys must match the file data keys above. | |
| Query Parameter | A list of query parameters to send with the request. This is the portion at the end of the URL similar to ?key1=value1&key2=value2. | |
| Header | A list of headers to send with the request. | |
| Response Type | The type of data you expect in the response. You can request json, text, or binary data. | json |
| Timeout | The maximum time that a client will await a response to its request | |
| Debug Request | Enabling this flag will log out the current request. | false |
| Retry Delay (ms) | The delay in milliseconds between retries. This is used when 'Use Exponential Backoff' is disabled. | 0 |
| Retry On All Errors | If true, retries on all erroneous responses regardless of type. This is helpful when retrying after HTTP 429 or other 3xx or 4xx errors. Otherwise, only retries on HTTP 5xx and network errors. | false |
| Max Retry Count | The maximum number of retries to attempt. Specify 0 for no retries. | 0 |
| Use Exponential Backoff | Specifies whether to use a pre-defined exponential backoff strategy for retries. When enabled, 'Retry Delay (ms)' is ignored. | false |
Search Sheets
Searches sheets for a specified phrase.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID (Optional) | The unique identifier of the sheet to search within. Omit to search across all sheets. | |
| Search Query | The text to search for across sheets, rows, and cells. |
Send Sheet
Sends a sheet via email to specified recipients.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| Format | The file format to use when sending the sheet. | EXCEL |
| Paper Size | The paper size to use when generating the PDF. | LETTER |
| Emails | The email addresses of recipients to send the document to. | |
| Group IDs | The group IDs of recipients to send the document to. | |
| CC Me | When true, sends a copy of the email to the sender. | false |
| Message | The message of the email. | |
| Subject | The subject line of the email. |
Set Sheet Publish Status
Sets the publish status of a sheet.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| iCal Enabled | When true, a webcal feed is published for the calendar in the sheet. | false |
| Read Only Full Accessible By | The audience that can access the read-only full view of the published sheet. ALL allows anyone with the link; ORG restricts access to the organization. | ALL |
| Read Only Full Default View | The default layout shown when viewers open the read-only full published sheet. | CALENDAR |
| Read Only Full Enabled | When true, publishes a rich read-only version of the sheet that allows viewers to download row attachments and discussions. | true |
| Read Only Lite Enabled | When true, publishes a lightweight read-only version of the sheet without row attachments or discussions. | false |
| Read Write Accessible By | The audience that can edit the published sheet. ALL allows anyone with the link; ORG restricts access to the organization. | ALL |
| Read Write Default View | The default layout shown when editors open the read-write published sheet. | CALENDAR |
| Read Write Enabled | When true, publishes a rich version of the sheet that allows editors to modify cells and manage attachments and discussions. | true |
Update Folder
Updates the name of a folder.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Folder ID | The unique identifier for the folder. Folders can contain sheets, sights, reports, templates, and other folders. | |
| Folder Name | The display name for the folder. |
Update Sheet
Updates the properties of a sheet.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Sheet ID | The unique identifier for the sheet. | |
| New Name | The updated display name for the sheet. |
Update Workspace
Updates the properties of a workspace.
| Input | Comments | Default |
|---|---|---|
| Connection | The Smartsheet connection to use. | |
| Workspace ID | The unique identifier for the workspace. | |
| Name | The updated display name for the workspace. |