ForEachWriteRange

This activity enables users to write data iteratively to specified ranges in each sheet of the selected Google Sheet. Ensure this activity is used within the “ForEachSheet” activity which loops through all the sheets in the file.

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 writing the data. If left blank, the column headers will not be considered. 

Write Range: *It indicates to select the range or provide the range where the values need to be written in 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 where it needs to be written. 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

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.

WriteStatus: It provides the output of the activity as the result of the values written in the sheets. Ite returns the 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.