> ## Documentation Index
> Fetch the complete documentation index at: https://docs.automate.ax/llms.txt
> Use this file to discover all available pages before exploring further.

> ## Agent Instructions
> Automate.ax automations are TypeScript programs.
> Use Bun for installation and command examples.
> Use Automate.ax for the product name and automate.ax for the package, CLI, and domain.
> Treat documented public APIs as current; do not invent transitional or deprecated names.

# Create banded range

> Add alternating row or column colors to an ordinary Google Sheets range.

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

## Example

```ts theme={null}
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.