Duplicate sheet - Automate.ax

duplicateSheet copies one tab within the same spreadsheet.

Example

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

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

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

Inputs

spreadsheet and sheet (title or numeric ID) are required. newTitle and zero-based insertion index are optional. account selects the Google account.

Output

Returns the new sheet’s normalized metadata. The copy includes cell values and formatting; a duplicate newTitle is rejected.

⌘I