On cells changed

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

export default automation("Handle order changes", () => {
  const batch = googleSheets.onCellsChanged({
    spreadsheet: "https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit",
    range: "'Orders'!A2:F",
  })

  batch.changes.forEach((change) => {
    change.cell.a1
    change.before.value
    change.after.value
  })
})

const batch = googleSheets.onCellsChanged({
  spreadsheet: "SPREADSHEET_ID",
  range: {
    sheet: 123456789,
    startRow: 2,
    startColumn: 1,
    endColumn: 6,
  },
})

type CellsChangedEvent = {
  spreadsheet: {
    id: string
    title: string
    url: string
  }
  observedAt: string
  chunk: {
    index: number
    total: number
  }
  changes: Array<{
    sheet: {
      id: number
      title: string
    }
    cell: {
      a1: string
      row: number
      column: number
    }
    before: CellState
    after: CellState
  }>
}

type CellState = {
  value: string | number | boolean | null
  formula?: string
  error?: {
    type: string
    message?: string
  }
}