Google Sheets — Find cell
Google Sheets — Find cell
Section titled “Google Sheets — Find cell”Type: googlesheets-find-cell · Package: Google Sheets Activities v1.0.0 · Output: Dictionary
Searches for a value in the sheet and returns the location of the first matching cell. It’s the Google Sheets “Search” from the bot.
How it works
Section titled “How it works”It scans the sheet (or the given range) looking for value based on the match-type, and returns the first match, or null if it doesn’t find it. The comparison is case insensitive.
Required parameters
Section titled “Required parameters”| Parameter | Editor | Description |
|---|---|---|
value | expression | Value to look for. |
Optional parameters
Section titled “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 | Limit to a range. By default, the entire sheet. |
match-type | list | Comparison: exact (def.) · contains · starts-with. |
Output
Section titled “Output”Returns a Dictionary with address, row, column, value, or null if there is no match.
Example
Section titled “Example”Google Sheets — Find cell session = = hoja value = "Total" → output: celdaIf condition = = !isNull(celda) └─ then: Log message = = "Encontrada en " + celda["address"]