Actions5
- Sheet Actions
- Row Actions
Overview
This node integrates with Smartsheet to perform various actions on sheets and rows. Specifically, for the Row - Get Row operation, it retrieves a single row from a specified sheet by its row ID. This is useful when you need to fetch detailed data of a particular row within a sheet, such as retrieving task details, project status, or any row-specific information stored in Smartsheet.
Common scenarios include:
- Fetching a specific row's data to use in subsequent workflow steps.
- Validating or processing data from a particular row.
- Integrating Smartsheet row data into other systems or reports.
Example: You have a project management sheet and want to retrieve the status and assigned person of a specific task (row) to send an update email.
Properties
| Name | Meaning |
|---|---|
| Sheet Name or ID | Select the target sheet by name or ID from a dropdown list populated dynamically. You can also specify the sheet ID via expression. |
| Row | The unique identifier of the row you want to retrieve. |
| Raw Response | Boolean option to return the raw API response from Smartsheet instead of the processed output. Defaults to true. |
Output
The node outputs JSON data representing the requested row from Smartsheet. The structure corresponds to the Smartsheet API's row object, including all columns and their values for that row.
If "Raw Response" is enabled, the output will be the full raw response from the Smartsheet API, which may include metadata beyond just the row data.
No binary data output is produced by this operation.
Dependencies
- Requires a valid Smartsheet API authentication token configured in n8n credentials.
- The node depends on the Smartsheet API to fetch sheets and rows.
- Dynamic loading of sheets and columns requires network access to Smartsheet services.
Troubleshooting
- Invalid Sheet ID or Row ID: If the specified sheet or row ID does not exist or is incorrect, the node will fail to retrieve data. Verify IDs are correct and accessible by the authenticated user.
- Authentication Errors: Ensure the API key credential is valid and has sufficient permissions to read sheets and rows.
- Empty Output: If no row matches the given ID, the output may be empty or an error may be thrown. Double-check the row ID.
- API Rate Limits: Frequent requests might hit Smartsheet API rate limits; consider adding delays or error handling for rate limit responses.