Smartsheet

Smartsheet icon

Smartsheet is a cloud-based work management tool that helps teams plan, track, and manage projects.

Triggers

Trigger

Configuration fields

Data type

Required?

Column deleted - A column was deleted from a sheet

Sheet name - Select the sheet to receive notifications for

Choice

Checkmark icon, required field

Column updated - A column was updated in a sheet

Sheet name - Select the sheet to receive notifications for

Choice

Checkmark icon, required field

Comment deleted - A comment was deleted from a sheet

Sheet name - Select the sheet to receive notifications for

Choice

Checkmark icon, required field

Comment updated - A comment was updated in a sheet

Sheet name - Select the sheet to receive notifications for

Choice

Checkmark icon, required field

Attachment added - A new attachment was added to a sheet

Sheet name - Select the sheet to receive notifications for

Choice

Checkmark icon, required field

Column created - A new column was added to a sheet

Sheet name - Select the sheet to receive notifications for

Choice

Checkmark icon, required field

Comment created - A new comment was posted to a sheet

Sheet name - Select the sheet to receive notifications for

Choice

Checkmark icon, required field

Row created - A new row was added to a sheet

Sheet name - Select the sheet to get notifications for

Choice

Checkmark icon, required field

Row deleted - A row was deleted from a sheet

Sheet name - Select the sheet to receive notifications for

Choice

Checkmark icon, required field

Row updated - A row was updated in a sheet

Sheet name - Select the sheet to receive notifications for

Choice

Checkmark icon, required field

Sheet updated - A sheet was updated

Sheet name - Select the sheet to receive notifications for

Choice

Checkmark icon, required field

Attachment updated - An attachment to a sheet was updated

Sheet name - Select the sheet to receive notifications for

Choice

Checkmark icon, required field

Attachment deleted - An attachment was deleted from a sheet

Sheet name - Select the sheet to receive notifications for

Choice

Checkmark icon, required field

Actions

Action

Configuration fields

Data type

Required?

Share sheet - Share a sheet with a user

Sheet name - Enter the name of the sheet to share

Choice

Checkmark icon, required field

Send email - Indicate whether or not to send an email notifying the user

Boolean

Checkmark icon, required field

Email message (optional) - Enter a message to include in the body of the email

String

 

Email address - Enter the email address of the user to share the sheet with

Email

Checkmark icon, required field

Email subject - Enter the subject of the email

String

 

Copy sharer - Indicate whether or not to copy the sheet sharer on the email

Boolean

 

Access level - Select the access level for the user

Choice

Checkmark icon, required field

Share workspace - Share a workspace with a user

Workspace name - Enter the name of the workspace to share

Choice

Checkmark icon, required field

Send email - Indicate whether or not to send an email to the user

Boolean

Checkmark icon, required field

Email message (optional) - Enter a message to include in the body of the email

String

 

Email address - Enter the email address of the user to share the workspace with

Email

Checkmark icon, required field

Email subject - Enter the subject of the email

String

 

Copy sharer - Indicate whether or not to copy the workspace sharer on the email

Boolean

 

Access level - Set the access level of the user

Choice

Checkmark icon, required field

Email sheet - Email a sheet converted to a file

Sheet name - Select the name of the sheet

Choice

Checkmark icon, required field

Email message (optional) - Enter a message to include in the body of the email

String

 

Recipient email addresses - Enter the email addresses of the sheet recipients

 

Checkmark icon, required field

Email subject - Enter the subject of the email

String

 

Copy sender - Indicate whether or not to copy the sheet sender on the email

Boolean

 

File format - Select the file format of the sheet

Choice

Checkmark icon, required field

Paper size - Select the paper size of the file

Choice

Checkmark icon, required field

Create sheet from custom template - Create a sheet from your own custom template

Template data objects - Enter the data objects to add to the sheet. Enter as a comma-separated list.

String

 

Sheet name - Enter the name of the sheet

String

Checkmark icon, required field

Source template - Select the custom template to base the new sheet on

Choice

Checkmark icon, required field

Create sheet from pre-built template - Create a sheet from a pre-built template

Template data objects - Enter the data objects to add to the sheet. Enter as a comma-separated list.

String

 

Sheet name - Enter the name of the sheet

String

Checkmark icon, required field

Source template - Select the pre-built template to base the new sheet on

Choice

Checkmark icon, required field

Create workspace - Create a new workspace

Workspace name - Enter the name of the workspace

String

Checkmark icon, required field

Update row - Update cell data for a row in a sheet

Sheet name - Select the name of the sheet to update

Choice

Checkmark icon, required field

Row number - Select the number of the row to update

Choice

Checkmark icon, required field

Insert row - Add a row to a spreadsheet

Sheet name - Select the name of the sheet to add the row to

Choice

Checkmark icon, required field

Get comment - Retrieve a comment from a sheet

Comment name - Select the ID of the comment to retrieve

Choice

Checkmark icon, required field

Sheet name - Select the sheet containing the comment

Choice

Checkmark icon, required field

Get sheet - Retrieve a sheet

Sheet name - Select the name of the sheet to return

Choice

Checkmark icon, required field

Get attachment - Retrieve an attachment from a sheet

Attachment name - Select the name of the attachment to return

Choice

Checkmark icon, required field

Sheet name - Select the name of the sheet containing the attachment

Choice

Checkmark icon, required field

Get row - Retrieve data for a row in a spreadsheet

Sheet name - Select the name of the sheet containing the row

Choice

Checkmark icon, required field

Row number - Select the number of the row to return

Choice

Checkmark icon, required field

Get column information - Retrieve information about a column

Column name - Select the column to return information for

Choice

Checkmark icon, required field

Sheet name - Select the name of the sheet containing the column

Choice

Checkmark icon, required field

Search in sheet - Search the content inside the sheets

Sheet name - Select the name of the sheet to return

Choice

Checkmark icon, required field

Search term - Text with which to perform the search. Enclose in double-quotes for an exact search.

String

Checkmark icon, required field