Create spreadsheet

createSpreadsheet creates a new workbook owned by the connected account.

Example

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

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

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

Inputs

title is required. Optional locale, IANA timeZone, and autoRecalc (onChange, minutely, hourly) set spreadsheet properties. 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. account selects the Google account.

Output

Returns the complete created Spreadsheet; see Get spreadsheet. Keep spreadsheetId or url for later actions.

⌘I

Get started

Concepts

Reference

Example

Inputs

Output

​Example

​Inputs

​Output

Example

Inputs

Output