Read values

googleSheets.readValues reads A1 or named ranges in one request. Use row actions for records keyed by headers instead of positional matrices.

Example

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

export default automation("Read order data", () => {
  onDashboardRun({ title: "Read order data" })

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

Inputs

Provide spreadsheet and one range or non-empty ranges array. majorDimension defaults to rows and also accepts columns. valueRender defaults to unformatted and also accepts formatted or formula. dateTimeRender defaults to serialNumber and also accepts formattedString when values aren’t formatted. Second argument { 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 may have ragged rows and cover less than the requested range.

Built-in triggers

Built-in actions

Runtime utilities

Integrations

Example

Inputs

Output

​Example

​Inputs

​Output

Example

Inputs

Output