Sort range - Automate.ax

sortRange rearranges rows within a structured range using one or more sort keys.

Example

import { automation, onHttpRequest } from "automate.ax"
import { sortRange } from "automate.ax/google-sheets"

export default automation("Sort orders", () => {
  onHttpRequest({ scope: "automation" })

  sortRange({
    spreadsheet: "spreadsheet-id",
    range: { sheet: "Orders", startRow: 2, startColumn: 1, endColumn: 4 },
    sortBy: [
      { column: 4, direction: "descending" },
      { column: 1, direction: "ascending" },
    ],
  })
})

Inputs

spreadsheet, one-based structured range, and non-empty sortBy are required. Each sort column is an absolute one-based sheet column, not relative to the range; direction defaults to ascending. account selects the Google account.

Output

Returns the resolved zero-based grid range. Exclude a header row from range when it should remain fixed.

⌘I