ForEachRowSpreadsheet

This activity helps the user to iterate through and retrieve the range of row values from the specified sheet in the Workbook.

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

If row is empty: This parameter defines the action to be taken when an empty row is encountered during processing:

Skip: Skips the empty row and moves to the next one.
Process: Processes the empty row as part of the workflow.
Stop: Halts the operation upon encountering an empty row.

WorkbookName: * This parameter specifies the existing spreadsheet where the sheet details needs to be retrieved. It offers multiple ways to choose the spreadsheet: 

1. Browse Option: When selecting the “Click on Browse” option, it will automatically list the folders and spreadsheets available for the specified account. The user must manually select the spreadsheet each time when using this option.
2. Three-Line Menu:Clicking on the “Three lines” icon will open a context menu with the following two options.
a. Reload Folder Picker:Refreshes the selected folder or spreadsheet.
b. Use Variable: Allows you to provide the “Workbook Name” as a variable in “String” format. You can either hardcode the values as a string or use a variable of the “String” datatype. Below are the values that can be provided as variable, 
     i. URL or ID: After creating the workbook in the specified Google account, you will receive the workbook’s URL and ID. You can use these as a reference to add a new sheet within the workbook. 
    ii. Spreadsheet Name: You can either hardcode the name as a string or provide a variable of the “String” datatype.

Sheet Name: This parameter indicates to choose the existing spreadsheet from where the range of row values needs to be retrieved. It offers multiple ways to choose the sheet name: 

1. Browse Option: When selecting the “Sheet Name” option, it will automatically list the sheet name available in the specified workbook from the dropdown. The user must manually select the spreadsheet each time when using this option.
2. Three-Line Menu:Clicking on the “Three lines” icon will open a context menu with the following two options.
a. UpdateRange: Refreshes the selected sheet name and prompts to re-select the sheet name.
b. Use Variable: Allows you to provide the “Sheet Name” as a variable in “String” format. You can either hardcode the values as a string or use a variable of the “String” datatype. Below are the values that can be provided as variable,
     i. Sheet Name: You can either hardcode the name as a string or provide a variable of the “String” datatype. 
    ii. Select Sheet: When selecting this option, it will automatically list the sheet name available in the specified workbook from the dropdown. The user must manually select the spreadsheet each time when using this option.

Read Range: It indicates to provide the range of row values that needs to be processed from the specified workbook. You can either hardcode the values as a string or use a variable of the “String” datatype.

ForEach: This parameter represents each row retrieved from the list of sheets in the specified workbook. You can customize its name as needed.

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

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.

The number of rows processed: This parameter helps you to get the count of the rows processed during the execution. It returns values in “Integer” datatype. 

* Represents mandatory fields to execute the workflow.