Read values - Automate.ax

readValues reads raw A1 or named ranges in one request. Use row actions when you want records keyed by headers instead of positional matrices.

Example

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

export default automation("Read order data", () => {
  onHttpRequest({ scope: "automation" })

  readValues({
    spreadsheet: "spreadsheet-id",
    ranges: ["Orders!A1:D100", "Summary!B2"],
    valueRender: "unformatted",
  })
})

Inputs

spreadsheet and one range or non-empty ranges array are required. majorDimension is rows (default) or columns. valueRender is unformatted (default), formatted, or formula. dateTimeRender is serialNumber (default) or formattedString when values are not formatted. account selects the Google account.

Output

Returns one { range, majorDimension, values } per requested range. values is (string | number | boolean | null)[][]; the outer dimension matches majorDimension. Google omits trailing empty cells and rows, so matrices can be ragged and shorter than the requested range.

⌘I