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