Create sheet - Automate.ax

createSheet adds a tab to an existing spreadsheet.

Example

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

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

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

Inputs

spreadsheet and unique title are required. Optional positive rowCount and columnCount, nonnegative frozenRowCount and frozenColumnCount, zero-based index, hidden, and rightToLeft set the initial sheet. 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.

⌘I