Find and replace

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

Example

import { automation, onHttpRequest } from "automate.ax"
import { findAndReplace } from "automate.ax/google-sheets"

export default automation("Normalize status text", () => {
  onHttpRequest({ scope: "automation" })

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

Inputs

spreadsheet, non-empty find, and replacement are required. Supply either sheet (title or numeric ID) or structured range, 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. Regex syntax is Java-compatible and replacement can use supported capture references. account selects the Google account.

Output

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

⌘I

Get started

Concepts

Reference

Example

Inputs

Output

​Example

​Inputs

​Output

Example

Inputs

Output