Smartsheet
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 |
|
Column updated - A column was updated in a sheet |
Sheet name - Select the sheet to receive notifications for |
Choice |
|
Comment deleted - A comment was deleted from a sheet |
Sheet name - Select the sheet to receive notifications for |
Choice |
|
Comment updated - A comment was updated in a sheet |
Sheet name - Select the sheet to receive notifications for |
Choice |
|
Attachment added - A new attachment was added to a sheet |
Sheet name - Select the sheet to receive notifications for |
Choice |
|
Column created - A new column was added to a sheet |
Sheet name - Select the sheet to receive notifications for |
Choice |
|
Comment created - A new comment was posted to a sheet |
Sheet name - Select the sheet to receive notifications for |
Choice |
|
Row created - A new row was added to a sheet |
Sheet name - Select the sheet to get notifications for |
Choice |
|
Row deleted - A row was deleted from a sheet |
Sheet name - Select the sheet to receive notifications for |
Choice |
|
Row updated - A row was updated in a sheet |
Sheet name - Select the sheet to receive notifications for |
Choice |
|
Sheet updated - A sheet was updated |
Sheet name - Select the sheet to receive notifications for |
Choice |
|
Attachment updated - An attachment to a sheet was updated |
Sheet name - Select the sheet to receive notifications for |
Choice |
|
Attachment deleted - An attachment was deleted from a sheet |
Sheet name - Select the sheet to receive notifications for |
Choice |
|
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 |
|
Send email - Indicate whether or not to send an email notifying the user |
Boolean |
|
|
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 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 |
|
|
Share workspace - Share a workspace with a user |
Workspace name - Enter the name of the workspace to share |
Choice |
|
Send email - Indicate whether or not to send an email to the user |
Boolean |
|
|
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 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 |
|
|
Email sheet - Email a sheet converted to a file |
Sheet name - Select the name of the sheet |
Choice |
|
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 |
|
|
|
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 |
|
|
Paper size - Select the paper size of the file |
Choice |
|
|
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 |
|
|
Source template - Select the custom template to base the new sheet on |
Choice |
|
|
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 |
|
|
Source template - Select the pre-built template to base the new sheet on |
Choice |
|
|
Create workspace - Create a new workspace |
Workspace name - Enter the name of the workspace |
String |
|
Update row - Update cell data for a row in a sheet |
Sheet name - Select the name of the sheet to update |
Choice |
|
Row number - Select the number of the row to update |
Choice |
|
|
Insert row - Add a row to a spreadsheet |
Sheet name - Select the name of the sheet to add the row to |
Choice |
|
Get comment - Retrieve a comment from a sheet |
Comment name - Select the ID of the comment to retrieve |
Choice |
|
Sheet name - Select the sheet containing the comment |
Choice |
|
|
Get sheet - Retrieve a sheet |
Sheet name - Select the name of the sheet to return |
Choice |
|
Get attachment - Retrieve an attachment from a sheet |
Attachment name - Select the name of the attachment to return |
Choice |
|
Sheet name - Select the name of the sheet containing the attachment |
Choice |
|
|
Get row - Retrieve data for a row in a spreadsheet |
Sheet name - Select the name of the sheet containing the row |
Choice |
|
Row number - Select the number of the row to return |
Choice |
|
|
Get column information - Retrieve information about a column |
Column name - Select the column to return information for |
Choice |
|
Sheet name - Select the name of the sheet containing the column |
Choice |
|
|
Search in sheet - Search the content inside the sheets |
Sheet name - Select the name of the sheet to return |
Choice |
|
Search term - Text with which to perform the search. Enclose in double-quotes for an exact search. |
String |
|