Smartsheet icon

Smartsheet

Perform various actions against a Smartsheet
Join our community

Actions5

Overview

The node integrates with Smartsheet to perform various actions on sheets and rows. Specifically, for the "Row" resource with the "Find Row" operation, it searches for a row within a specified sheet where a particular column matches a given value. This is useful when you want to locate specific data entries in a Smartsheet based on column criteria.

Common scenarios include:

  • Retrieving a row by a unique identifier or key stored in a column.
  • Searching for rows matching a status or category.
  • Automating workflows that depend on finding and processing specific rows dynamically.

Example: Find the row in a project tracking sheet where the "Task ID" column equals "12345" to update its status or extract details.

Properties

Name Meaning
Sheet Name or ID Select or specify the target sheet from which to find the row.
Raw Response Choose whether to return the full raw response from Smartsheet or a simplified output.
Column Name or ID Select or specify the column used as the search key to find the row.
Value The value to match in the selected column to identify the desired row.

Output

The node outputs an array of JSON objects representing the found row(s) matching the search criteria. Each object corresponds to a row's data fields as returned by Smartsheet.

If "Raw Response" is enabled, the output includes the complete Smartsheet API response for the row, which may contain metadata and additional information beyond just the row data.

The node does not explicitly mention binary data output for this operation.

Dependencies

  • Requires a valid API authentication token credential for Smartsheet.
  • Needs access to the Smartsheet API to list sheets, columns, and retrieve rows.
  • The node dynamically loads available sheets and columns for selection via helper methods.

Troubleshooting

  • Issue: No rows found despite correct inputs.

    • Cause: The specified value might not exist in the chosen column or the sheet ID/column ID is incorrect.
    • Resolution: Verify the sheet and column selections; ensure the value exactly matches the cell content (case-sensitive).

  • Issue: Error loading sheets or columns options.

    • Cause: API credentials may be invalid or lack permissions.
    • Resolution: Check the API key validity and permissions granted to it.

  • Error Message: Generic API errors or timeouts.

    • Resolution: Confirm network connectivity and Smartsheet service status; retry after some time.

Links and References

Discussion