Clear range formatting

googleSheets.clearRangeFormatting() removes formatting from a grid range or native-table section while preserving cell values.

Example

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

export default automation("Reset order body styles", () => {
  onDashboardRun({ title: "Reset order body styles" })

  googleSheets.clearRangeFormatting({
    spreadsheet: "spreadsheet-id",
    range: { table: "OrdersTable", section: "body" },
    properties: ["backgroundColor", "borders", "text.bold"],
  })
})

Inputs

Provide spreadsheet and range. A grid range takes sheet plus optional one-based inclusive row and column bounds. A table target takes table and optional section: all, header, body, or footer. Omit properties to clear all user-entered cell formatting. Otherwise provide one or more of backgroundColor, borders, horizontalAlignment, hyperlinkDisplay, numberFormat, padding, rotation, text, text.bold, text.color, text.family, text.italic, text.link, text.size, text.strikethrough, text.underline, textDirection, verticalAlignment, or wrap. Clearing text clears every text-format property. Use a text.* value for a narrower reset. This action doesn’t remove conditional-format rules, ordinary banding, or native-table styling. Those separate layers can still make cleared cells look formatted. Second argument { account } selects the Google Account. All action inputs accept compatible signals.

Output

Returns the resolved zero-based, end-exclusive grid range with numeric sheetId.

Built-in triggers

Built-in actions

Runtime utilities

Integrations

Clear range formatting

Example

Inputs

Output

​Example

​Inputs

​Output

Example

Inputs

Output