Create spreadsheet

googleSheets.createSpreadsheet creates a workbook owned by the connected account.

Example

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

export default automation("Create an operations workbook", () => {
  onDashboardRun({ title: "Create an operations workbook" })

  googleSheets.createSpreadsheet({
    title: "Operations",
    locale: "en_US",
    timeZone: "America/Los_Angeles",
    sheets: [{ title: "Orders", frozenRowCount: 1 }],
  })
})

Inputs

Provide title. Optional locale and a timeZone from the IANA database set spreadsheet properties. autoRecalc accepts onChange, minutely, or hourly. sheets is a non-empty array of initial sheet definitions with title and optional rowCount, columnCount, frozen counts, and hidden. Omit it for Google’s default sheet. Second argument { account } selects the Google Account.

Output

Returns the created Spreadsheet. See Get spreadsheet. Keep spreadsheetId or url for later actions.

Built-in triggers

Built-in actions

Runtime utilities

Integrations

Example

Inputs

Output

​Example

​Inputs

​Output

Example

Inputs

Output