Smartsheet Actions

Actions are the operations (or API operations) that you can perform on Smartsheet by a simple drag and drop and data mapping of elements and values from input trigger, derived values using formulas or a desired constant that you may wish to map.

All of the actions that you see below automate what you can do manually on Smartsheet.

As shown below, you can create or update sheet and sheet objects in your Smartsheet account in response to a trigger event.

Figure 1. Actions for Smartsheet Application on Connect iPaaS

On Connect iPaaS, you can create a sheet as well as create or update sheet objects. It is configurable and highly flexible allowing you to map any available elements from captured event data to the Smartsheet objects (row or sheet) you wish to create or update.

Add Row

Every time an event is triggered, this action will create a new row in the target sheet. When adding/creating the row, you can choose to either add the row at the top or the bottom of an existing sheet.

Figure 2. Add Row Action for Smartsheet Application on Connect iPaaS

Update Row

Every time an event is triggered, this action will update row(s) based on the selection criteria in the target sheet.

Figure 3. Update Row Action for Smartsheet Application on Connect iPaaS

​

Create Sheet

You can use this node to create an empty sheet with your specified columns and datatype in your Smartsheet account. When creating a sheet, you can choose to either add the sheet in the Home folder, any Workspace, or any other Folder.

Figure 4. Create Sheet Action for Smartsheet Application on Connect iPaaS