Create banded range

googleSheets.createBandedRange() adds ordinary alternating-color formatting to a grid range. It doesn’t create a native table.

Example

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

export default automation("Band an order report", () => {
  onDashboardRun({ title: "Band an order report" })

  googleSheets.createBandedRange({
    spreadsheet: "spreadsheet-id",
    range: { sheet: "Orders", startRow: 1, endRow: 100 },
    rows: {
      headerColor: { theme: "accent1" },
      firstBandColor: "#FFFFFF",
      secondBandColor: "#E8F0FE",
    },
  })
})

Inputs

Provide spreadsheet, a structured one-based range, and at least one of rows or columns. Each banding object requires firstBandColor and secondBandColor, and optionally accepts headerColor and footerColor. A color is a six-digit hex string or { theme }, where theme is text, background, accent1 through accent6, or link. Optional bandedRangeId supplies an integer ID. Otherwise Google assigns one. Second argument { account } selects the Google Account. All action inputs accept compatible signals.

Output

Returns the created banded range with its zero-based, end-exclusive range, row and column colors, and numeric bandedRangeId when supplied by Google.

Built-in triggers

Built-in actions

Runtime utilities

Integrations

Example

Inputs

Output

​Example

​Inputs

​Output

Example

Inputs

Output