For Each Row in Spreadsheet

UiPath.GSuite.Activities.ForEachRowConnections

Description

Reads and saves the information from a spreadsheet's range for subsequent activities, like Write Range.

Add the activities to repeat inside For Each Row in Spreadsheet and, when you configure them, select Use Variable > CurrentRow from the See more button menu to indicate that you want to repeat the actions for each row 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. This activity doesn't support persistence.

Project compatibility

Windows | Cross-platform

Configuration

• Google Sheets connection - The connection for the Google Workspace account to use in the activity.
• 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 modes.
  • Spreadsheet URL - The URL of the spreadsheet of interest. This field is available when Url or ID is selected as the input mode. This property supports String variables and string formatted values.
  • Spreadsheet sample - The spreadsheet template to use. The field is visible after clicking Use spreadsheet template. Browse the Google Drive folders and select a spreadsheet. In Studio Desktop, the option is available from the Plus button menu next to Range type. To learn more, see Working with templates. This field accepts IResource input.

  • Select the Reload File Data option if you've modified your folders and need to retrieve the latest data.

• Range - The range within which rows are iterated. This field is prepopulated with information retrieved from the selected spreadsheet or spreadsheet sample. This property supports String variables and string formatted values. Click the Plus button menu to select Update Ranges if you've performed changes in the spreadsheet ranges.

  • Select the Update Table option if you've modified your workbook and need to retrieve the latest data.

• Has headers - Specifies whether the first row in the range represents a header row. By default, True is selected. This property supports Boolean values.

Additional options

Input

• If row is empty - Indicates the behavior to follow when an empty row is iterated. The available options are Skip, Process, and Stop.
• What to read - Specifies what to read from the range. The available options are Values, Values, and Formulas, Text.

Output

• Number of rows processed - The total number of rows processed by the activity. Can be used outside the For Each Row 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 Read Range.

Known limitations for requests

Be aware of request/response limits when working with ranges. The limit stands at 4 MB, e.g., on average 10,000 cells with 20 characters each for Read requests, and 4,000 cells with 20 characters each for Write requests.

Note:

Batching API calls is supported for the following activities when used inside the For each:

• Write Row
• Write Cell

Example

See also:

• Sheets activities
• Read Range
• Read Cell
• Write Range
• Write Cell