Copy Activity
The Copy activity facilitates the duplication of data between different ranges, sheets, or even separate Google Spreadsheet instances. It allows for high-speed data transfer while providing the option to preserve formatting or transfer only the raw values.
| Field | Description | Requirement |
|---|---|---|
| Google sheet name | The reference name for the destination Google Spreadsheet instance. | Optional |
| Source Google sheet name | The reference name for the source Google Spreadsheet instance where data is pulled from. | Required |
| Source Sheet name | The specific worksheet (tab) name in the source spreadsheet. | Optional |
| Sheet name | The specific worksheet (tab) name in the destination spreadsheet. | Optional |
| Range | The cell coordinates or range in the source sheet to be copied (e.g., "A1:B10"). | Required |
| Destination | The starting cell address in the target sheet where the data will be pasted (e.g., "A1"). | Required |
| Copy as value | If enabled, only the data values are copied, excluding formulas and formatting. | Optional |
Action Types & Examples
Internal Sheet Copy
Copying data from one tab to another within the same spreadsheet.
- Format:
Source Sheet name: "RawData",Sheet name: "Backup" - Example Result: All data from the "RawData" tab is mirrored into the "Backup" tab starting at the defined destination.
Implementation Examples
Field Setup
- Google sheet name:
Main_Inventory - Source Google sheet name:
Main_Inventory_2 - Range:
A1:D50 - Destination:
A1 - Copy as value:
True
Execution Parameters
- Operation: Data from
A1:D50is read from the source and pasted as static values into the destination sheet.
Technical Notes
When
Copy as valueis checked, formulas like=SUM(A1:A10)will be converted to their resulting numerical or text value during the paste process. IfGoogle sheet name(destination) is not provided, the activity assumes the source and destination are within the same spreadsheet instance.