Create sheet - Automate.ax

googleSheets.createSheet adds a tab to an existing spreadsheet.

Example

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

export default automation("Add an archive sheet", () => {
  onDashboardRun({ title: "Add an archive sheet" })

  googleSheets.createSheet({
    spreadsheet: "spreadsheet-id",
    title: "Archive",
    rowCount: 2000,
    columnCount: 20,
    frozenRowCount: 1,
  })
})

Inputs

Provide spreadsheet and a unique title. Optional positive rowCount and columnCount, nonnegative frozenRowCount and frozenColumnCount, zero-based index, hidden, and rightToLeft set the initial sheet. Second argument { account } selects the Google Account.

Output

Returns Sheet metadata with sheetId, title, zero-based index, grid counts, frozen counts, visibility, direction, type, and an empty tables array.