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

Use cases

  • Checking to see if an item already exists in a spreadsheet to avoid adding duplicates

Last updated