Delete rows - Automate.ax

googleSheets.deleteRows removes rows and shifts later rows upward. It deletes adjacent groups from bottom to top so shifting doesn’t change remaining targets.

Example

import { automation, onDashboardRun } from "automate.ax"
import { googleSheets } from "automate.ax/google-sheets"

export default automation("Delete obsolete orders", () => {
  onDashboardRun({ title: "Delete obsolete orders" })

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

Inputs

Provide spreadsheet, source, and one row number or an array of up to 1,000. The action removes duplicates and sorts the numbers. Every row must belong to the source body. Second argument { account } 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.