Actions13
- Manage Smartsheet Actions
- Manage Folder Actions
Overview
This node integrates with the Smartsheet API to manage and manipulate sheets and folders. Specifically, the Update Row (Using Column Name) operation allows users to update a specific row in a Smartsheet by specifying the row ID and providing column name-value pairs for the update.
Common scenarios where this node is beneficial include:
- Automating updates to project management sheets by changing task statuses or deadlines.
- Synchronizing data from other systems into Smartsheet rows based on dynamic inputs.
- Correcting or enriching existing row data without manually editing the sheet.
For example, you might update a row to change the "Status" column to "Completed" and set the "Completion Date" column to today's date by providing those column names and values.
Properties
| Name | Meaning |
|---|---|
| Sheet Name or ID | Select the target Smartsheet by name or specify its ID. |
| Row ID | The unique identifier of the row to update within the selected sheet. |
| Columns (Name and Value Pair) | A JSON string representing an object where keys are column names and values are the new values to set in those columns. Example: {"Status":"Completed","Priority":"High"} |
Output
The output JSON contains the response from the Smartsheet API after updating the row. It typically includes details about the updated row such as its ID and the new cell values.
If the update fails due to invalid column names or other issues, the node throws an error with a descriptive message.
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). - The user must have appropriate permissions to read sheet metadata and update rows.
Troubleshooting
Error:
Column - <column_name> not found
This occurs if one or more specified column names do not exist in the target sheet. Verify that the column names exactly match those in Smartsheet, including case and spacing.Invalid JSON in Columns property
The "Columns (Name and Value Pair)" input must be a valid JSON string. Ensure proper formatting, e.g., use double quotes around keys and string values.Row ID does not exist
If the provided Row ID is incorrect or no longer exists, the update will fail. Confirm the Row ID is valid for the selected sheet.API authentication errors
Make sure the API key credential is correctly set up and has sufficient permissions.
Links and References
- Smartsheet API Documentation - Rows
- n8n Expressions Documentation (for dynamic input expressions)
- Smartsheet Developer Portal