Actions13
- Manage Smartsheet Actions
- Manage Folder Actions
Overview
This node enables users to manage Smartsheet data, specifically focusing on adding rows to a sheet using column labels. It interacts with the Smartsheet API to insert new rows at the bottom of a specified sheet by mapping input fields to the corresponding columns via their labels.
Common scenarios include:
- Automating data entry into Smartsheet from other systems or workflows.
- Bulk inserting multiple rows based on dynamic input data.
- Integrating Smartsheet as a backend for form submissions or data collection processes.
For example, you might use this node to add sales records collected from a web form directly into a Smartsheet tracking sales performance, where each form field corresponds to a column label in the sheet.
Properties
| Name | Meaning |
|---|---|
| Sheet Name or ID | Select the target Smartsheet by name or specify its ID. The list is dynamically loaded from your Smartsheet account. |
| Row | A collection of one or more rows to add. Each row consists of multiple fields where each field maps a column label (field name) to a value to insert. Multiple rows can be added in one execution. |
Details on "Row" property:
- Field Name or ID: Choose the column by its label (title) or ID within the selected sheet.
- Value: The value to insert into the corresponding column for that row.
Output
The node outputs JSON data representing the result of the add rows operation. This typically includes details about the newly added rows such as their IDs and any metadata returned by the Smartsheet API.
The output structure contains an array of objects, each representing a row added to the sheet, including confirmation of insertion and any relevant identifiers.
No binary data output is produced by this operation.
Dependencies
- Requires a valid API authentication token credential for Smartsheet.
- The node uses the Smartsheet REST API v2 endpoint
https://api.smartsheet.com/2.0. - The user must have appropriate permissions on the target Smartsheet to add rows.
- Dynamic loading of sheets and columns depends on successful API calls to list sheets and retrieve sheet columns.
Troubleshooting
Error: No rows specified
Occurs if the "Row" property is empty or no fields are provided. Ensure at least one row with valid fields is defined.Column not found errors
If a specified column label does not exist in the selected sheet, the operation will fail. Verify that the column names match exactly those in the sheet.Authentication errors
If the API key or token is invalid or expired, the node will fail to connect. Re-authenticate or update credentials.API rate limits or network issues
Temporary failures may occur due to API limits or connectivity problems. Retrying after some time or checking network status is recommended.
Links and References
- Smartsheet API Documentation - Official API reference for adding rows.
- n8n Expressions Documentation - For using expressions in property values.
- Smartsheet Developer Portal - General resources and guides for Smartsheet API integration.