Skip to main content

Find

Description​

This activity searches for the specified value inside the specified cell range and returns a list of cell addresses containing the search value.

note

This activity works only inside Google Context activity.

Properties​

Location​

  • Spreadsheet Path / Id - Specify the relative spreadsheet path or Id inside Google Drive.
  • Cell Range - The cell range to search the value.
  • Find - The value to search.

Misc​

  • DisplayName – Add a display name to your activity.
  • Private – Logs the variable and argument values at the Verbose level when unchecked.

Optional​

  • Sheet Name - The sheet's name to search the value. By default, it operates on the currently active sheet.
  • Continue On Error – Specifies if the automation should continue even when the Activity throws an error. This field only supports Boolean values (True, False). The default value is False.
    note

    Catches no error if this Activity is present inside the Try-Catch block and the value of this property is True.

Output​

  • Cell Address - Returns the list of cell addresses that contains the search value.

Example​

Download Example

Find