Append values

googleSheets.appendValues uses an A1 range to detect a logical table and appends after its last data row or column.

Example

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

export default automation("Append an order", () => {
  onDashboardRun({ title: "Append an order" })

  googleSheets.appendValues({
    spreadsheet: "spreadsheet-id",
    range: "Orders!A:D",
    values: [["A-1042", "Ada", 125, "Open"]],
  })
})

Inputs

Provide spreadsheet, detection range, and non-empty values matrix. majorDimension defaults to rows. inputMode defaults to userEntered. insertMode defaults to googleSheets.insertRows. overwrite can write over cells after the detected table. includeValues defaults false. Response render modes match Write values. Second argument { account } selects the Google Account binding.

Output

Returns spreadsheetId, optional pre-append tableRange, updatedRange, update counts, and optional values. The detection range identifies a logical table, not necessarily the appended range.

Built-in triggers

Built-in actions

Runtime utilities

Integrations

Example

Inputs

Output

​Example

​Inputs

​Output

Example

Inputs

Output