Find row in a Google Sheet step

The Find row in a Google Sheet step searches a Google Sheet for one or more values and returns the row number of the first cell that matches. The number is output as the [find-row-google-sheet] token, which later steps use to read, write or delete that row.

You can use this step to locate rows for tasks such as:

  • Updating stock levels
  • Editing scraped data
  • Generating reports

How to configure the Find row in a Google Sheet step


Spreadsheet

Select a Google Sheet to search, or paste its URL.

Sheet name

Optionally enter the name of the sheet to search, the tab at the bottom of the document. Leave it blank to use the first sheet.

Values (comma separated)

Enter a list of values separated by commas, or insert data holding one value per row. The step returns the row number of the first cell that matches.

Exact match

Tick to match the whole cell value. Off, a cell that contains the value anywhere matches.

Value matching mode

Choose whether a row matches when it holds any of the values or only when it holds all of them.

Columns (optional)

Turn the switch on and enter column numbers separated by commas, such as 1,2, to search only those columns.

Write back to the row it found


To update the row rather than append a new one, pass the token into a Write data to a Google Sheet step: choose Add to existing data, then in the starting cell box type the column letter and click Insert Data to add the [find-row-google-sheet] token after it, so A plus the token writes to column A of the row found.

A Write data to a Google Sheet step with Add to existing data chosen and its starting cell set to the letter A followed by the find-row-google-sheet token

Guides that use this step