Read Range

Scopes

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

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

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

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

• 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 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 Sheet1C5: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 options

• 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

See also:

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