Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to copy a sheet tab to another spreadsheet.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Copy sheet to spreadsheet function copies a sheet tab from one spreadsheet to another. The copy 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 |
| Source spreadsheet ID | Yes | Text | - | Spreadsheet ID to copy from |
| Sheet ID | Yes | Text | - | The numeric sheet ID to copy |
| Destination spreadsheet ID | Yes | Text | - | Spreadsheet ID to copy to |
| Variable | Yes | Text | - | Variable to store the result |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Object | Object containing the new sheetId and title in the destination spreadsheet |
Errors
- Source spreadsheet not found – the source spreadsheet ID is invalid
- Destination spreadsheet not found – the destination spreadsheet ID is invalid
- Sheet not found – no sheet exists with the given ID
Tips
- You must have write access to the destination spreadsheet
- The copied sheet will appear as a new tab in the destination
Related functions
- Duplicate sheet – Duplicate within the same spreadsheet