ForEachReadRange

This activity helps the user to iteratively read data from specified ranges from each sheet in the selected Google Sheet. Ensure that this activity is utilized within the “ForEachSheet” activity.

Properties

Configuration

Each activity requires a connection with Google Sheets authentication. Once you select the respective project name where Google Sheets has been authenticated, the activity will automatically retrieve the available connections for that project.

Below are the properties available after the project has been integrated:

Google: *This parameter indicates the account name associated with the integration.

INPUT

IncludeColumnHeaders: Indicates to include the “Column Headers” in the spreadsheet while reading the data. If left blank, the column headers will not be considered. 

Read Range: *It indicates to select the range or provide the range to read the data from the spreadsheet. It accepts the value in “String” datatype, which can be either hardcoded or provided as a variable in the “String” datatype.

Sheet Name: *This parameter specifies the name of the sheet against which the range of data needs to be read. Utilize the “CurrentSheet” variable from “ForEachSheet” activity to automatically iterate and extract the values. 

What To Read: Indicates to read either the value from the range of cells or values with formula from the range of cells.

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”
True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

OUTPUT

Datatable: It provides the output of the activity as the result of the values read from the specified range in the spreadsheet in a table format. It returns the value in “Datatable” datatype.

Result: It provides the ability to view the execution status of the activity. It returns values in “Boolean.”

True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

* Represents mandatory fields to execute the workflow.