For Each Sheet in Spreadsheet

UiPath.GSuite.Activities.ForEachSheetConnections

Description

Iterates through the sheets within a spreadsheet.

Add the activities to repeat inside For Each Sheet in Spreadsheet and, when you configure them, select Use Variable > CurrentSheet from the See more button menu to indicate that you want to repeat the actions for each sheet in the iteration. For details, see Iterate through items with For Each activities.

Note: This activity uses pagination for processing large numbers of items and mitigating performance issues.

Project compatibility

Windows | Cross-platform

Configuration

• Connection - The connection for the Google Workspace account to use in the activity.
• Spreadsheet - The Google spreadsheet file to use. Click the Folder icon to browse Google Drive folders and select a spreadsheet. This option accepts input as IResource. Use the Plus button menu to switch to Use variable or Url or ID input (String) modes.
  • Spreadsheet URL - The URL of the spreadsheet of interest. This field is available when Url or ID is selected as the input mode.

Additional Options

Output

• Total number of sheets processed - The total number of sheets processed by the activity.

Body

The body of the activity that stores other activities used in the automation, such as Write Range.

Example

See also

• Sheets activities
• Add Sheet
• Write Cell
• For Each Row in Spreadsheet