How to add rows to an existing Smartsheet
You can add rows to an existing Smartsheet by using Smartsheet - Add Rows action. Follow the steps given below to achieve this.
Add the Smartsheet connector to canvas and connect it to Start icon.
Double-click the Smartsheet connector, and select Add Rows action from the Select Action drop down list. Select/add the account for Smartsheets that you want to use to execute this action. Read more about creating accounts.
Once this is done, click Next, and the following details in the action configuration window that appears next:
Sheet ID: Select/specify the ID of the sheet in which you want to add rows.
Row Location (Mandatory): Select the location where you want to add a row from the options given under the drop-down list. If you select Child of Parent option, you have to enter the Parent ID, and if you select Sibling, you have to enter the Sibling ID.
Note: Child of Parent adds a new row as a child of the specified row and Sibling adds a new row at the same hierarchical level of the specified row.
Parent ID: Select the ID of the parent row. The new row is added as the first child of this parent row
Insert Row in the Child List At: Select the position of the row you want to add.
You can add multiple rows and columns by clicking on the ADD link.
Once you have entered the relevant details, click Next, test the action, and click Done. This will take you back to canvas.
Next, Save the workflow and click Test. This will add a new row (along with the value, if any) at the specified location. Please note that to see the reflected changes, you will need to refresh the selected sheet in Smartsheet.