Skip to main content
Version: Current

Find

Description​

Searches for a text or numeric value within a Google Sheet and returns the addresses of all matching cells.

The search can be limited to a specific range within the sheet.

Common settings​

Use Process Data to bind supported inputs to workflow values or upstream outputs. See Common Activity Features for shared execution, error-handling, and output-persistence settings. Availability depends on the activity.

Design-Time Configuration​

Display Text​

A user-defined name for the activity, displayed on the workflow canvas to help identify its purpose.

Connection Name​

The configured Google Sheets connection used to access Google Sheets resources.

Spreadsheet​

The spreadsheet where the search will be performed.

Sheet Name​

The name of the sheet where the operation will be performed.

If not specified, the currently active sheet is used.

Cell Range​

The range within which to search.

Find​

The text or numeric value to search for.

Match Case​

Determines whether the search is case-sensitive.

When enabled, values such as Apple and apple are treated as different values.

info

For details about selecting spreadsheets, sheets, and ranges, see Google Sheets Data Selection.

Execution settings​

Configure Wait All Incoming when execution paths converge, and On Error for failure handling. Select Inherit where available to use the workflow-level error policy.

Output​

Cell Addresses​

A list of cell addresses where matching values were found.

Example:

[A1, B5, D10]

Remarks​

  • The authenticated Google account must have access to the spreadsheet.
  • The search is performed only within the specified range.
  • When Match Case is disabled, the search is performed without regard to letter casing.
  • Multiple matching cells may be returned.
  • If no matches are found, an empty list is returned.
  • The returned cell addresses use standard A1 notation and can be used by subsequent Google Sheets activities.

Example: Search a bounded range​

Set Cell Range to A2:A100 and Find to Pending. Enable Match Case only when capitalization matters. Iterate over Cell Addresses to process matching cells. An empty list means no match was returned.

Help improve this page