Skip to main content
Version: Current

Find and Replace

Description​

Searches for specific values in a Google Spreadsheet and replaces them with new content. Supports text matching, numeric values, formulas, and regular expression–based searches.

Common Capabilities​

Process Data Support​

info

This activity supports dynamic configuration using variables from the Process Data drawer.

You can bind values from Model Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.

Learn more → Using Process Data

Design Time Configuration​

Display Text​

The label for this activity as it appears on the workflow canvas.

Connection Name​

Select the configured Google Drive connection used to authenticate and access the spreadsheet.

Spreadsheet​

The file path or unique Spreadsheet ID of the Google Spreadsheet stored in Google Drive.

See this guide for details on using file paths and IDs.

Search Scope​

Defines where the search is 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 search the entire spreadsheet.

Cell Range​

The specific range of cells to search (for example, A1:D10).
Required only when Search Scope is set to Specific Range.

Find​

The text, number, or pattern to search for.

Replace With​

The value that replaces the matched content.

Match Case​

When enabled, the search is case-sensitive (for example, treating Apple and apple as different values).

Match Entire Cell​

When enabled, a match occurs only if the entire cell content exactly matches the Find value, rather than partially containing it.

Search Options​

  • Search Within Formula
    When enabled, the search includes underlying cell formulas in addition to their calculated display values.

  • Search Using Regex
    When enabled, the Find value is treated as a Regular Expression for advanced pattern matching.

Wait All Incoming​

Execution Control

Controls how this activity behaves when multiple incoming execution paths converge.

Choose whether the activity runs when:

  • any incoming path completes, or
  • all relevant incoming paths complete before execution

Learn more → Execution Control

On Error​

Error Handling Strategy

Defines how the workflow behaves if this activity encounters a runtime error.

Supported strategies include Fault, Continue, Suspend, and Retry.

Learn more → Error Handling

Output​

Cell Addresses​

A list of strings containing the addresses of all cells where the value was found and replaced
(for example, ['A1', 'B5']).