Search a Google Sheet by one column for a specific term. NOTE: If there is a blank cell in between two values in the column you are searching within, this action will only search for values above that blank cell. We recommend making sure the column you are searching in FLOs has a value in every row, even if it is 0, so that this action will search the entire column.

Options

  • Spreadsheet (dropdown) : The spreadsheet on which you are searching.
  • Worksheet (dropdown) : The tab or worksheet of the spreadsheet on which you are searching.
  • Column to Search (dropdown) : A list containing the specific column you want to search.

Input Fields

You can search by any value in any column of your spreadsheet.

  • Search Query
    • Search Term (text): The value you want to search for, inside the column.

Output Fields

  • Output

    • Row Number (Number) : The row number at which the value you searched by was found. This action will return the first row at which the value is found, not a list if there are duplicates of that value in the sheet. If the value is not found within the column, the output will return null.

    Note : The Search process starts from second row as the first row will be treated as custom “Column Headers” defined for the Google Sheet.