Update banded range

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

Example

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() 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() 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.

Built-in triggers

Built-in actions

Runtime utilities

Integrations

Example

Inputs

Output

​Example

​Inputs

​Output

Example

Inputs

Output