Skip to main content
Go to the Studio
Rows

Find row

Find row

Finds the first row where a column matches a given value.


Options​

Google Sheets connection​

Select the Connection action set up in the flow.

Spreadsheet ID​

Enter the ID of the spreadsheet. The ID can be found in the spreadsheet URL: docs.google.com/spreadsheets/d/{spreadsheetId}/edit.

Tab name or ID​

Enter the tab name (e.g. Página1) or, using the number type, the numeric ID of the tab.

Column to search in​

The exact column name, as it appears in the tab's first row (header).

Value to search for​

Enter the value to compare against the column's content, for each row of the tab.

Returns​

Javascript code​

js
actions["action-id"].rowNumber // number of the row found (Number)
actions["action-id"].row // the row found, as an object (Any)

Field selection​

  • rowNumber — number of the row found (Number)
  • row — the row found, as an object matching each column name to its value (Any)

Rules and Conditions​

  • The Google Sheets connection, Spreadsheet ID, Tab name or ID, Column to search in and Value to search for fields are required.
  • The tab's first row is always used as the header, and it is from there that the row field matches each value to its column name.
  • Only the first matching row (the one with the lowest number) is returned, even when other rows hold the same value in the searched column.
  • Values are compared as text; for example, the number 10 and the text "10" are considered equivalent.
  • If the given column does not exist in the tab's header — including the case where the tab has no header row at all — the robot stops with an error.
  • If no row matches the given value, the action does not stop the run; handle that case in the flow before using the returned rowNumber/row fields.