Run for every row of an Excel sheet

Do the same task for each patient, order or customer in a spreadsheet.

1. 1

   Open Variables, add a File variable and upload your sheet (or use a Read Excel step).

2. 2

   Drag For Each Row onto the board and choose the sheet as its source; put the steps to repeat on its body arrow.

3. 3

   In those steps use {{row["Column name"]}} wherever a value from the row goes.

4. 4

   Set Max rows to 1 or 2 for a trial run first. Each row's outcome is written to the run's results.xlsx.