Actions13
- Manage Smartsheet Actions
- Manage Folder Actions
Overview
This node integrates with the Smartsheet API to manage sheets and folders, enabling users to perform various operations such as adding rows, deleting rows, renaming sheets, retrieving sheet data, and more. Specifically, the Add Rows (Line Item Supported) operation allows users to append multiple rows of data to a specified Smartsheet sheet in a single execution.
Common scenarios where this node is beneficial include:
- Automating data entry into Smartsheet from other systems or workflows.
- Bulk importing tabular data into Smartsheet for project management or tracking.
- Dynamically updating sheets based on external triggers or events.
For example, a user could automate adding new task entries to a project sheet whenever a form is submitted or when new records are created in a CRM system.
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. This identifies the sheet where rows will be added. |
| Rows | A collection of rows to add. Each row consists of multiple fields: - Field Name or ID: Choose the column by name or ID where the value should be inserted. - Value: The value to set for that field. |
The "Rows" property supports multiple values, allowing you to add several rows in one operation. The fields available depend on the selected sheet's columns.
Output
The output JSON contains the result of the API call to add rows. It typically includes details about the newly added rows, such as their IDs and any metadata returned by Smartsheet.
The structure corresponds to the Smartsheet API response for adding rows, which includes an array of row objects under a result key.
No binary data output is produced by this operation.
Dependencies
- Requires an active connection to the Smartsheet API via an API key credential configured in n8n.
- The node uses the Smartsheet REST API v2 endpoint (
https://api.smartsheet.com/2.0). - Proper permissions on the Smartsheet account to read sheet metadata and add rows.
Troubleshooting
Error: No rows specified
Occurs if the "Rows" input is empty or missing. Ensure at least one row with valid fields and values is provided.Invalid Column ID or Name
If a specified field does not match any column in the sheet, the API may reject the request. Use the dynamic dropdown to select valid columns or verify column IDs.Authentication Errors
If the API key is invalid or lacks required permissions, requests will fail. Verify the API key credential configuration.API Rate Limits or Network Issues
Temporary failures might occur due to rate limiting or connectivity problems. Retrying after some time or checking network status can help.
Links and References
- Smartsheet API Documentation - Add Rows
- n8n Expressions Documentation (for using expressions in properties)
- Smartsheet Developer Portal