Find and replace

googleSheets.findAndReplaceText searches a structured range, one sheet, or the whole spreadsheet and replaces every match.

Example

import { automation, onDashboardRun } from "automate.ax"
import { googleSheets } from "automate.ax/google-sheets"

export default automation("Normalize status text", () => {
  onDashboardRun({ title: "Normalize status text" })

  googleSheets.findAndReplaceText({
    spreadsheet: "spreadsheet-id",
    sheet: "Orders",
    find: "^pending$",
    replacement: "Open",
    searchByRegex: true,
    matchCase: false,
    matchEntireCell: true,
  })
})

Inputs

Provide spreadsheet, non-empty find, and replacement. Supply either sheet as a title or numeric ID, or a structured range, but not both. Omit both for all sheets. A range uses sheet and optional one-based inclusive row/column bounds. includeFormulas, matchCase, matchEntireCell, and searchByRegex all default false. Regular expression syntax is Java-compatible and replacement can use supported capture references. Second argument { account } selects the Google Account.

Output

Returns counts for occurrencesChanged, rowsChanged, sheetsChanged, valuesChanged, and formulasChanged. Zero occurrences is a successful no-op.

Built-in triggers

Built-in actions

Runtime utilities

Integrations

Example

Inputs

Output

​Example

​Inputs

​Output

Example

Inputs

Output