Delete conditional format rule - Automate.ax

googleSheets.deleteConditionalFormatRule() deletes one conditional-format rule from a sheet’s priority list.

Example

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

export default automation("Remove an obsolete formatting rule", () => {
  onDashboardRun({ title: "Remove an obsolete formatting rule" })

  googleSheets.deleteConditionalFormatRule({
    spreadsheet: "spreadsheet-id",
    sheet: "Orders",
    index: 0,
  })
})

Inputs

Provide spreadsheet, sheet, and the rule’s zero-based index. Indexes are per sheet and are positions, not stable IDs. Deleting a rule shifts the indexes of lower-priority rules. Second argument { account } selects the Google Account. All action inputs accept compatible signals.

Output

Returns the deleted rule’s former { index, ranges, rule } metadata.