Sheet - Team L.C.L Excavation icon

Sheet - Team L.C.L Excavation

Read, update, write and delete data from Smartsheet API
Join our community

Actions13

Overview

This node interacts with Smartsheet to manage sheets and folders, specifically supporting operations such as adding, updating, deleting rows, renaming sheets, managing columns, and finding rows based on column labels. 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.

Practical scenarios include:

  • Searching for specific entries in a project management sheet by matching a task name or status.
  • Filtering rows in an inventory sheet based on product codes or categories.
  • Automating data retrieval workflows where rows need to be found dynamically by column values.

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 in the sheet.
Type Defines the format of the output: either a single object or an array containing matched rows.

Details on "Type" options:

  • Object: Returns the matched rows wrapped inside an object.
  • Array Single Item: Returns an array of matched rows directly.

Output

The node outputs JSON data representing the rows that match the search criteria in the specified sheet column. 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.

If multiple rows match, the output is either an array of these row objects or an object containing a rows array, depending on the selected "Type" property.

No binary data output is produced by 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 user must have access rights to the specified sheet in Smartsheet.
  • The node dynamically loads available sheets for selection via an internal method.

Troubleshooting

  • Error: Column key "X" not found.
    This occurs if the specified column label does not exist in the selected sheet. Verify the column name spelling and ensure it exists in the sheet.

  • No rows specified / No matching rows found.
    If no rows match the search value, the output will be empty. Confirm the search value and column label are correct.

  • API errors related to permissions or invalid sheet IDs.
    Ensure the API token has sufficient permissions and the sheet ID is valid.

  • Empty or missing sheet list in dropdown.
    This may happen if the API token lacks access or there are no sheets available. Check credentials and Smartsheet account.

Links and References

Discussion