Google Sheets — Find row

Google Sheets — Find row

Type: googlesheets-find-row  ·  Package: Google Sheets Activities v1.0.0  ·  Output: object

Finds the first row where a column matches a value, and returns the entire column. It is the equivalent of a BUSCARV (VLOOKUP): locate a customer record, an order, an appointment by its identifier.

How it works

Searches the column column (letter like A or number like 1) for value, and returns the row found. With has-headers = true (default) returns it as a dictionary (key = column name); if not, as a list of values. The comparison ignores capital letters and spaces.

Required parameters

Parameter	Editor	Description
column	expression	Column to search for: letter (A, B) or number (1, 2).
value	expression	Value to look for.

Optional parameters

Parameter	Editor	Description
session	session	Google Sheets — Open session. Optional: within a body it is inherited.
sheet	expression	Sheet where to search.
range	expression	Search range. By default, all columns (A:Z).
has-headers	boolean	First row as headers → result as dictionary. By default true.

Output

Returns the row found (a dictionary if has-headers, or a list), or null if there is no match.

Example

Google Sheets — Find row   session = = hoja   column = "A"   value = = nit   has-headers = true   → output: cliente
If   condition = = !isNull(cliente)
 └─ then:
      Log   message = = "Cliente: " + str(cliente["Nombre"])

Related activities

• Find cell — find a specific cell.
• Read sheet — read all and filter with LINQ.