Actions13
- Manage Smartsheet Actions
- Manage Folder Actions
Manage Smartsheet → Add Rows (Using Column Label)
AI-generatedOverview
This node operation allows users to add multiple rows to a specified Smartsheet sheet by using column labels to identify the data fields. It is useful for automating data entry into Smartsheet sheets where the user wants to append rows at the bottom of the sheet by specifying values for columns using their labels rather than column IDs. For example, a user can add new project tasks or inventory items to a Smartsheet sheet by providing the sheet ID and the row data with column labels.
Use Case Examples
- Adding new rows to a project management sheet by specifying task names, due dates, and assigned team members using column labels.
- Appending inventory data to a Smartsheet sheet by providing product names, quantities, and prices using column labels.
Properties
| Name | Meaning |
|---|---|
| Sheet Name or ID | The identifier of the Smartsheet sheet where rows will be added. Can be selected from a list or specified via an expression. |
| Row | The data for the rows to be added. Each row consists of multiple fields where each field is identified by a column label and its corresponding value. |
Output
JSON
rowId- The unique identifier of the newly added row in Smartsheet.rowNumber- The position number of the newly added row in the sheet.cells- An array of cell objects representing the data added to the row, each containing a column ID and the value added.
Dependencies
- Smartsheet API with an API key credential for authentication
Troubleshooting
- Ensure the sheet ID is valid and accessible with the provided API credentials.
- Verify that the column labels used in the row data match exactly with the column titles in the Smartsheet sheet.
- Check for proper formatting of numeric values, especially for columns like 'contractquantity' and 'unitprice' which are parsed as floats.
- Common error messages include 'Column - {label} not found' if a column label does not exist, and API errors related to authentication or permissions.