Actions13
- Manage Smartsheet Actions
- Manage Folder Actions
Overview
This node interacts with Smartsheet to manage sheets and folders, specifically here focusing on the Find Row operation within the Manage Smartsheet resource. The "Find Row" operation searches for rows in a specified sheet where a particular column matches a given search value.
Typical use cases include:
- Retrieving specific row data based on a known cell value.
- Automating workflows that depend on locating rows matching certain criteria.
- Integrating Smartsheet data lookups into broader automation pipelines.
For example, you might want to find a row in a project tracking sheet where the "Task Name" column equals "Design Review" to update or process that row further.
Properties
| Name | Meaning |
|---|---|
| Sheet Name or ID | Select the target sheet by name or specify its ID. |
| Column Name or ID | Select the column to search within by name or specify its ID. |
| Search Value | The exact value to search for in the specified column. |
| Type | Determines the format of the output: - Object: Wraps found rows inside an object. - Array Single Item: Returns an array of matching rows directly. |
Output
The output is JSON data representing the rows found in the specified sheet where the chosen column's value matches the search query.
- Each matched row includes:
rowId: The unique identifier of the row.rowNumber: The position number of the row in the sheet.- Key-value pairs for each column in the row, where keys are column titles and values are the corresponding cell values.
Depending on the selected Type property:
- If "Object": The output wraps the matched rows inside an object, e.g.,
{ rows: [...] }. - If "Array Single Item": The output is a plain array of matched row objects.
No binary data output is involved in 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 node dynamically loads available sheets and columns via API calls to assist user selection.
Troubleshooting
- No rows found: If no rows match the search value, the output will be empty (empty array or object with empty rows). Verify the search value and column selection.
- Invalid Sheet or Column ID: If the sheet or column ID does not exist or is inaccessible, the node may throw an error. Ensure the IDs are correct and the API token has access rights.
- Empty or missing parameters: Required properties like Sheet ID, Column, and Search Value must be provided; otherwise, the node will fail.
- API rate limits or connectivity issues: Network problems or API limits can cause errors. Check your network and Smartsheet API usage quotas.
- Incorrect output type: Selecting the wrong output type may cause confusion in downstream nodes expecting a different structure.