Smartsheet icon

Smartsheet

Perform various actions against a Smartsheet

Actions5

Overview

This node integrates with Smartsheet to perform various actions on sheets and rows. Specifically, for the Row - Update Row operation, it updates an existing row in a specified sheet by modifying its cell values or by providing a JSON representation of the row data.

Common scenarios where this node is useful include:

  • Automating updates to project management sheets when task statuses change.
  • Syncing data from other systems into Smartsheet rows.
  • Bulk updating rows based on external triggers or workflows.

For example, you could update the status column of a specific row to "Completed" after a task finishes in another system, or modify multiple cells in a row by specifying their column names and new values.

Properties

Name Meaning
Sheet Name or ID Select the target sheet by name or ID where the row exists. You can choose from a list of available sheets or specify an ID using an expression. This property is required.
Row The ID of the row to update within the selected sheet.
Value Type Method to supply updated fields: either as individual cells or as a JSON object representing the row. Options: Cells, JSON.
Cells When Value Type is Cells, specify one or more cells to update. Each cell requires:
- Column Name or ID: select the column to update (from a list or via expression).
- Value: the new value for that cell.
JSON When Value Type is JSON, provide the entire row data as a JSON object to update the row.

Output

The node outputs an array of JSON objects representing the updated row(s). Each object corresponds to a row with its updated fields as returned by the Smartsheet API.

If binary data were involved (not indicated here), it would typically represent file attachments or similar content related to the row, but this node focuses on JSON data updates only.

Dependencies

  • Requires a valid API authentication token credential for Smartsheet.
  • Needs access to the Smartsheet API to list sheets and columns dynamically.
  • The node uses internal helper methods to fetch sheets and columns for dropdown options.

Troubleshooting

  • Invalid Sheet or Row ID: Ensure the provided sheet and row IDs exist and are accessible with the given credentials.
  • Permission Errors: Verify that the API token has sufficient permissions to update rows in the target sheet.
  • Incorrect Column Names/IDs: When updating cells, ensure column identifiers match those in the sheet; otherwise, updates may fail or be ignored.
  • Malformed JSON: If using the JSON input method, ensure the JSON structure matches Smartsheet's expected format for rows.
  • Empty Required Fields: The node requires the sheet ID and row ID; missing these will cause errors.

Links and References

Discussion