Skip to main content
Version: Current

Set Active Sheet

Description​

Moves the selected sheet to the first tab position in a Google Spreadsheet. Activities that use the first tab by default will then target that sheet.

This operation changes the shared spreadsheet's tab order. It does not control the currently selected tab in another user's browser.

Common settings​

Use Process Data to bind supported inputs to workflow values or upstream outputs. See Common Activity Features for shared execution, error-handling, and output-persistence settings. Availability depends on the activity.

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.

info

For details about selecting spreadsheets and sheets, see Google Sheets Data Selection.

Execution settings​

Configure Wait All Incoming when execution paths converge, and On Error for failure handling. Select Inherit where available to use the workflow-level error policy.

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 0 represents the first sheet.
  • The returned sheet properties can be used by subsequent activities.

Example: Select the default tab​

Choose By Name and set Sheet Name to Orders, leaving Sheet Index unset. After execution, Orders is the first tab and its returned Sheet Properties → Index is 0. Alternatively, choose By Index and supply the current zero-based index of the tab to move.

If subsequent operations should target Orders without moving it, set their Sheet Name directly instead.

Help improve this page