Actions13
- Manage Smartsheet Actions
- Manage Folder Actions
Overview
This node interacts with Smartsheet to manage sheets and folders, specifically supporting a variety of operations such as adding rows, deleting rows, renaming sheets, updating rows or columns, finding columns by title, and finding rows based on column values. The "Find Rows (Using Column Label)" operation allows users to search for rows in a specified sheet where a particular column matches a given search value.
Common scenarios include:
- Searching for specific data entries within a large Smartsheet by matching a column's label to a search term.
- Automating workflows that require retrieving rows based on dynamic criteria.
- Integrating Smartsheet data retrieval into broader automation pipelines.
Practical example:
- You have a project management sheet and want to find all rows where the "Status" column equals "Completed". Using this node, you specify the sheet, the column label "Status", and the search value "Completed" to retrieve those rows.
Properties
| Name | Meaning |
|---|---|
| Sheet Name or ID | Select the target sheet by name or specify its ID. |
| Search Value | The value to search for within the specified column label in the sheet's rows. |
| Type | Defines the output format: - Object: returns results wrapped in an object. - Array Single Item: returns results as a flat array of matching rows. |
Output
The node outputs JSON data representing the rows found in the specified sheet where the column label matches the search value.
- Each row object includes:
rowId: The unique identifier of the row.rowNumber: The position number of the row in the sheet.- Key-value pairs where keys are column titles and values are the corresponding cell values for that row.
Depending on the selected "Type" property:
- If "Object" is chosen, the output is an array containing one object with a
rowsproperty holding the matched rows. - If "Array Single Item" is chosen, the output is a flat array of matched row objects.
The node does not output binary data.
Dependencies
- Requires a valid API authentication token for Smartsheet.
- Needs the Smartsheet API credentials configured in n8n.
- Uses Smartsheet REST API v2 endpoints to fetch sheets, columns, and rows.
Troubleshooting
Error: "Column key "
" not found." - Cause: The specified column label does not exist in the selected sheet.
- Resolution: Verify the exact column label spelling and ensure it exists in the sheet.
No rows returned despite correct inputs
- Cause: No rows match the search value exactly.
- Resolution: Check the search value for exact matches including case sensitivity and whitespace.
Error: "No rows specified" when deleting rows
- Cause: Attempting to delete without specifying any row IDs.
- Resolution: Provide at least one valid row ID to delete.
API rate limits or connectivity issues
- Cause: Network problems or exceeding Smartsheet API limits.
- Resolution: Check network connection and Smartsheet API usage quotas.