> ## 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.

# Update banded range

> Update an ordinary Google Sheets banded range's bounds or colors.

`googleSheets.updateBandedRange()` changes a numeric banded range's bounds or row and column colors.

## Example

```ts theme={null}
import { automation, onDashboardRun } from "automate.ax"
import { googleSheets } from "automate.ax/google-sheets"

export default automation("Restyle report banding", () => {
  onDashboardRun({ title: "Restyle report banding" })

  googleSheets.updateBandedRange({
    spreadsheet: "spreadsheet-id",
    bandedRangeId: 184302910,
    rows: {
      firstBandColor: "#FFFFFF",
      secondBandColor: { theme: "accent2" },
      footerColor: null,
    },
  })
})
```

## Inputs

Provide `spreadsheet`, integer `bandedRangeId`, and at least one of `range`, `rows`, or `columns`. `range` replaces the bounds using a structured one-based grid range. Reference-only banded ranges returned by [`getSpreadsheet()`](/reference/integrations/google-sheets/actions/get-spreadsheet) can't use this action.

Within `rows` or `columns`, provide one or more `headerColor`, `firstBandColor`, `secondBandColor`, or `footerColor` updates. A color is a six-digit hex string or `{ theme }` using `text`, `background`, `accent1` through `accent6`, or `link`. Set `headerColor` or `footerColor` to `null` to clear it. The first and second band colors remain required while that direction's banding exists. Set all of `rows` or `columns` to `null` to remove that direction's banding, but a banded range must keep at least one direction. Use [`deleteBandedRange()`](/reference/integrations/google-sheets/actions/delete-banded-range) to remove both.

Second argument `{ account }` selects the Google Account. All action inputs accept compatible signals.

## Output

Returns the banded range's current zero-based range and row or column colors.