Skip to main content
Version: Current

Find and Replace

Description​

Searches for values within a Google Spreadsheet and replaces matching content with a new value.

The activity supports text, numbers, formulas, and regular expression–based pattern matching.

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 and replace operation will be performed.

Search Scope​

Determines where the search will be performed.

Supported options include:

  • Specific Range
  • Entire Sheet
  • All Sheets

Sheet Name​

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

Required unless Search Scope is set to All Sheets.

Cell Range​

The range of cells to search.

Required when Search Scope is set to Specific Range.

Find​

The text, number, formula value, or pattern to search for.

Replace With​

The value used to replace matching content.

Match Case​

Determines whether the search is case-sensitive.

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

Match Entire Cell​

Determines whether the entire cell content must match the search value.

When disabled, partial matches within the cell content are also considered.

Search Within Formula​

Determines whether the search includes underlying cell formulas in addition to displayed values.

Search Using Regex​

Determines whether the Find value is treated as a regular expression.

When enabled, regular expression pattern matching is used instead of literal text matching.

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 and replaced.

Example:

[A1, B5, D10]

Remarks​

  • The authenticated Google account must have permission to modify the spreadsheet.
  • The search can be restricted to a specific range, a single sheet, or all sheets within the spreadsheet.
  • When Match Entire Cell is disabled, partial matches within cell contents are also replaced.
  • When Search Within Formula is enabled, formulas are searched instead of only their displayed values.
  • When Search Using Regex is enabled, the Find value must be a valid regular expression pattern.
  • Existing formulas, references, and calculated results may be affected by replacement operations.

Example: Replace a status​

Choose Specific Range, supply Sheet Name and Cell Range C2:C100, set Find to Pending, and Replace With to Processed. Enable Match Entire Cell so a longer phrase containing Pending is not partially changed. Leave Search Using Regex off for literal matching.

For Entire Sheet, omit Cell Range; for All Sheets, the search is not restricted to one Sheet Name. Inspect the returned Cell Addresses before using them in further operations.

Help improve this page