Duplicate sheet - Automate.ax

googleSheets.duplicateSheet copies one tab within the same spreadsheet.

Example

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

export default automation("Create the August sheet", () => {
  onDashboardRun({ title: "Create the August sheet" })

  googleSheets.duplicateSheet({
    spreadsheet: "spreadsheet-id",
    sheet: "Template",
    newTitle: "August",
  })
})

Inputs

Provide spreadsheet and a sheet title or numeric ID in sheet. newTitle and zero-based insertion index are optional. Second argument { account } selects the Google Account.

Output

Returns the new sheet’s metadata. The copy includes cell values and formatting. Google rejects a duplicate newTitle.