Actions5
- Sheet Actions
- Row Actions
Overview
This node integrates with Smartsheet to perform various actions on sheets and rows. Specifically, for the Row - Create Row operation, it allows users to add a new row to an existing Smartsheet. Users can specify the target sheet, the location where the new row should be inserted (top or bottom), and the data for the new row either as individual cell values or as a JSON object.
Common scenarios include:
- Automating data entry by adding new rows based on incoming workflow data.
- Appending records to a Smartsheet for tracking tasks, inventory, or any tabular data.
- Inserting rows at the top or bottom of a sheet depending on business logic.
Example: Automatically add a new task row to a project management sheet whenever a new issue is created in a bug tracker.
Properties
| Name | Meaning |
|---|---|
| Sheet Name or ID | Select the target Smartsheet by name or ID where the new row will be added. The list is dynamically loaded from your Smartsheet account. |
| Location | Choose where to insert the new row: either at the "Top" or "Bottom" of the sheet. |
| Value Type | Method to supply the row data: either as individual "Cells" or as a full "JSON" object representing the row. |
| Cells | When using "Cells" value type, specify one or more cells with their column name/ID and corresponding value. Each cell corresponds to a column in the sheet. |
| JSON | When using "JSON" value type, provide the entire row data as a JSON object. This allows setting multiple fields in one structured input. |
Output
The node outputs an array of JSON objects representing the newly created row(s) in Smartsheet. Each object contains the details of the row as returned by the Smartsheet API, including cell values and metadata.
If binary data were involved (not applicable here), it would represent file attachments or similar content related to the row.
Dependencies
- Requires a valid API key credential for Smartsheet configured in n8n.
- Access to the Smartsheet API to list sheets, columns, and create rows.
- The node dynamically loads available sheets and columns via API calls to assist user selection.
Troubleshooting
- Invalid Sheet ID or Name: If the specified sheet does not exist or the ID is incorrect, the node will fail to find the sheet. Verify the sheet exists and the correct identifier is used.
- Missing Required Fields: When creating a row, all required columns must have values. Ensure that the provided cells or JSON include mandatory columns.
- API Authentication Errors: If the API key is invalid or lacks permissions, authentication errors will occur. Check the API key validity and permissions.
- Incorrect Column IDs: When specifying cells, column IDs must match those in the selected sheet. Use the dynamic dropdown to avoid mismatches.
- Location Option Misuse: Only "top" or "bottom" are valid locations. Using other values may cause errors.