1.Store the employee details in the excel file. 2.Use SpreadSheetRead range activity and store in the Datatable using Google Workspace. 3.Iterate through the datatable with For each row in Excel using currentrow(“Column Name”) 4.Inside the loop You can use the Send Email activities. ima...
terate through each row in the DataTable using a For Each Row activity. Within the loop, use the Assign activity to assign the value of the current row and column to a variable. For example, if you want to calculate the sum of the “Amount” column, you can assign the value of the ...
Next, add aFor Each Row in Data Tableactivity to theDesignerpanel and fill in the blank fields with “row” and the name of the DataTable variable,dt_DataTable1, respectively. This activity performs the action defined within it for each row in the data table. The sequence should look sim...