Append values

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

Example

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

export default automation("Append an order", () => {
  onHttpRequest({ scope: "automation" })

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

Inputs

spreadsheet, detection range, and non-empty values matrix are required. majorDimension defaults to rows; inputMode defaults to userEntered. insertMode defaults to insertRows; overwrite can write over cells after the detected table. includeValues defaults false; response render modes match Write values. account optionally selects the Google account binding.

Output

Returns spreadsheetId, optional pre-append tableRange, updatedRange, updated counts, and optional returned values. The detection range identifies a logical table; it is not necessarily the exact appended range.

⌘I

Get started

Concepts

Reference

Example

Inputs

Output

​Example

​Inputs

​Output

Example

Inputs

Output