Set Active Sheet
Description
Sets the active sheet within a Google Spreadsheet.
The target sheet can be identified by its name or index.
Common Capabilities
Process Data Support
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 spreadsheet containing the sheet to activate.
Selection Type
Determines how the target sheet is identified.
Supported options include:
- By Name
- By Index
Sheet Name
The name of the sheet to activate.
Required when Selection Type is set to By Name.
Sheet Index
The zero-based index of the sheet to activate.
Required when Selection Type is set to By Index.
For details about selecting spreadsheets and sheets, see Google Sheets Data Selection.
Wait All Incoming
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
Defines how the workflow behaves if this activity encounters a runtime error.
Supported strategies include:
- Fault
- Continue
- Suspend
- Retry
Output
Sheet Properties
The properties of the activated sheet.
Common properties include:
- Sheet ID
- Sheet Name
- Index
- Sheet Type
- Grid Properties
Remarks
- The authenticated Google account must have access to the spreadsheet.
- The target sheet can be identified either by name or by its zero-based index.
- The specified sheet must exist within the spreadsheet.
- Sheet indexes are zero-based, where
0represents the first sheet. - The returned sheet properties can be used by subsequent activities.