Read Cell

UiPath.GSuite.Activities.ReadCellConnections

Description

Reads the contents of the specified cell for use in other activities, such as Write Cell.

Scopes

This activity requires the following scopes:

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

OR

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

OR

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

OR

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

Project compatibility

Windows | Cross-platform

Configuration

• Google Sheets connection - The connection for the Google Workspace account to use in the activity.
• Spreadsheet - The spreadsheet from where the cell will be read. Click the Folder 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 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.

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

• Sheet/Named range - The sheet or named range where the cell is located, e.g., Sheet1. If it is a named range, it will read the first cell of the range. This field is prepopulated with information retrieved from the selected spreadsheet.

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

• Cell - The cell to read from, e.g., A1. Leave empty for named range. This property supports String variables and string formatted values.

Additional options

Options

• What to read - Specifies the type of value to be read. The available options are Values, Values and Formulas, and Text.
• Cell value type - Specifies the type of value of the read cell. The available options are General, Date, Date and time, Time, Number, and Text.

Output

• Read cell - The cell retrieved data. Automatically generated output variable. You can use it as it is or save it with a different name. You can use this in other activities, such as Write Cell.

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.

Example

See also:

• Sheets activities
• Write Cell
• Write Range
• For Each Row in Spreadsheet
• Create Spreadsheet