Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to duplicate a sheet tab.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Duplicate sheet function creates a copy of an existing sheet tab within the same spreadsheet. The duplicate includes all values, formatting, and data validation rules.
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Connector | Yes | Select | - | Select the Google Workspace connector to use |
| Spreadsheet ID | Yes | Text | - | Google Sheets spreadsheet ID |
| Sheet ID | Yes | Text | - | The numeric sheet ID to duplicate |
| New title | No | Text | Copy of [original] | Title for the duplicated sheet tab |
| Variable | Yes | Text | - | Variable to store the result |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Object | Object containing the new sheetId and title |
Errors
- Sheet not found – no sheet exists with the given ID
Tips
- Use this to create template copies for monthly reports or recurring data
Related functions
- Copy sheet to spreadsheet – Copy a sheet to a different spreadsheet
- Add sheet tab – Add a blank tab