Skip to main content
Version: Current

Copy Sheet

Description​

Copies a sheet from one Google Spreadsheet to another.

The copied sheet is created as a new sheet in the target spreadsheet while preserving the original sheet in the source spreadsheet.

Common Capabilities​

Process Data Support​

info

This activity supports dynamic configuration using variables from the Process Data drawer.

You can bind values from Model Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.

Learn more → Using Process Data

Design-Time Configuration​

Display Text​

A user-defined name for the activity, displayed on the workflow canvas to help identify its purpose.

Connection Name​

The configured Google Sheets connection used to access Google Sheets resources.

Spreadsheet​

The source spreadsheet containing the sheet to be copied.

You can:

  • Select a spreadsheet using the Google Drive Picker.
  • Provide a spreadsheet identifier dynamically through Process Data.

Target Spreadsheet​

The destination spreadsheet where the copied sheet will be created.

You can:

  • Select a spreadsheet using the Google Drive Picker.
  • Provide a spreadsheet identifier dynamically through Process Data.

Source Sheet Name​

The name of the sheet to copy from the source spreadsheet.

New Sheet Name​

The name assigned to the copied sheet in the destination spreadsheet.

If not specified, Google Sheets assigns a default name.

Wait All Incoming​

Execution Control

Controls how this activity behaves when multiple incoming execution paths converge.

Determines whether the activity executes when:

  • Any incoming path completes, or
  • All relevant incoming paths complete before execution

Learn more → Execution Control

On Error​

Error Handling Strategy

Defines how the workflow behaves if this activity encounters a runtime error.

Supported strategies include:

  • Fault
  • Continue
  • Suspend
  • Retry

Learn more → Error Handling

Output​

Sheet Properties​

Properties describing the newly created sheet in the destination spreadsheet.

Common properties include:

  • Sheet ID
  • Sheet Name
  • Index
  • Sheet Type
  • Grid Properties

For details, refer to the Google Sheets documentation:

https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/sheets

Remarks​

  • The authenticated Google account must have access to both the source and destination spreadsheets.
  • The original sheet remains unchanged in the source spreadsheet.
  • A new sheet is created in the destination spreadsheet.
  • The copied sheet includes the sheet structure and data maintained by Google Sheets during the copy operation.
  • If the specified sheet name already exists in the destination spreadsheet, Google Sheets naming rules apply.