Activities
latest
false
Productivity Activities
Last updated Jul 9, 2024

For Each Sheet in Spreadsheet

UiPath.GSuite.Activities.ForEachSheetConnections

Description

Iterates through the sheets within a spreadsheet.
Note: This activity uses pagination for processing large numbers of items and mitigating performance issues. This activity doesn't support persistence.
Scopes

This activity requires the following scopes:

  • https://www.googleapis.com/auth/drive
  • https://www.googleapis.com/auth/drive.readonly
  • https://www.googleapis.com/auth/spreadsheets
  • https://www.googleapis.com/auth/spreadsheets.readonly

Project compatibility

Windows | Cross-platform

Configuration

  • Google Sheets connection - The connection for the Google Workspace account to use in the activity.
  • Spreadsheet - The Google spreadsheet file to use. Click the Folderdocs image 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.
    • Select the Reload File Picker option if you've modified your folders and need to retrieve the latest data.

Additional Options

Output

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

    Can be used outside the For Each Sheet in Spreadsheet activity. Automatically generated output variable. You can use it as it is or save it with a different name.

Body

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

Example



See also:
  • Description
  • Project compatibility
  • Configuration
  • Example

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.