Delete rows - Automate.ax

deleteRows removes rows and shifts following rows upward. It groups adjacent targets and deletes from bottom to top so row shifting cannot change later targets.

Example

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

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

  deleteRows({
    spreadsheet: "spreadsheet-id",
    source: { sheet: "Orders" },
    rowNumbers: [12, 18, 19],
  })
})

Inputs

spreadsheet, source, and one row number or an array of up to 1,000 are required. Duplicates are removed and numbers are sorted. Every row must belong to the source body. account optionally selects the Google account binding.

Output

Returns { affectedCells, rowNumbers }, where row numbers are the original one-based targets. Stored row numbers below a deletion can become stale because the sheet shifts upward.

⌘I