Skip to main content

Read Range

UiPath.GSuite.Activities.ReadRangeConnections

Description​

Reads and saves the contents of the specified range so you can use them in activities such as Write Range.

note

The Read Range activity is not available in API workflows.

Scopes​

This activity requires the following scopes:

OR

OR

OR

Project compatibility​

Windows | Cross-platform

Configuration​

  • Google Sheets connection - The connection for the Google Workspace account to use in the activity.

  • Spreadsheet - Select the spreadsheet to read from or use a variable/URL or ID and define a spreadsheet with the range columns. With a template, the activity can generate the ranges and the columns. Click the Folder docs image icon to browse Google Drive folders and select a spreadsheet. This option accepts input as IResource. Use the See more button menu to switch to Use variable or Url or ID input (String) modes.

    • If you select Use variable, you can use the output variable from other activities, such as Create Spreadsheet.
    • Spreadsheet URL - The URL or ID 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. For details, see How to Retrieve Spreadsheet IDs.
    • 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 See more button menu next to Range. To learn more, see Working with templates.
    • Select the Reload File Data option if you've modified your folders and need to retrieve the latest data.

  • Range - Select the Range to read from after configuring the workbook. This field is prepopulated with information retrieved from the selected spreadsheet or spreadsheet sample. You can also add a custom range, such as Sheet!1C5:F10 or a NamedRange, e.g., Clients. This property supports String variables and string formatted values.

    • Select the Update Ranges option if you've modified your sheets and need to retrieve the latest data.
    • 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 is a header row. This property supports Boolean values.

  • What to read - Specifies the type of value to be read. The available options are Values, Values and Formulas, and Text.

Additional option​

Output

  • Read range - The range information stored in a DataTable variable.
  • Read information - Details of the selected range, stored in a RangeInformation variable.

Known limitations for requests​

Be aware of request or response limits when working with ranges. The limit stands at 4 MB. For example, on average 10,000 cells with 20 characters each for read requests, and 4,000 cells with 20 characters each for write requests.

Example​

docs image

For more details, check the following resources: