Find Spreadsheet Row

Finds a row in Google Sheets
Sheet
Google Sheet to search through
Condition
Conditions to use to find the spreadsheet row
Text conditions (e.g. "Text is exactly", "Text contains") are case-insensitive
Search from bottom of the sheet
Whether to start searching from the bottom of the sheet rather than from the top
Allows getting the most recent result if there are multiple matches
Variable to assign row number
Variable to store the row number
The row number will be -1 if there is no match
The "Row number exists/does not exist" conditions can be used to check if there's a match
Can be used for updating row values with Update Spreadsheet Row​
Use cases
Checking to see if an item already exists in a spreadsheet to avoid adding duplicates
Update Spreadsheet Row
Control Flow
Last modified 11mo ago