I have a loop that is processing rows from a spreadsheet. After it goes through the last row from the spreadsheet, it just continues and restarts with the first row.
Batch size is set to 1
1 Like
Hi @dbmedia Your Loop Over Items is likely never hitting the “no items left” state, so it restarts from the first row endlessly.
What to fix
-
Turn OFF “Reset”
If Reset is on, the loop reloads the input list every cycle and never finishes. -
Don’t feed the loop new item lists mid-loop
Only Get row(s) should provide the list to the loop.
Nodes like Update row should send results back into the loop output, not the loop input.
The correct pattern is:
Get rows → Loop (input) → process → update → back to Loop (loop output)
And when items are done: use the done output to continue. -
Avoid “Always Output Data” on the loop
It can prevent the loop from detecting that it has no items left.
Quick checklist
-
Loop Over Items → Options → Reset = OFF
-
Only the initial Get Rows feeds the loop.
-
Use loop output for cycling; done output to move on.
This ensures the loop stops after all rows are processed.
@Anshul_Namdev I tested this and without the update looping back to the loop, the flow just runs once and doesn’t loop over the items from the sheet
found the issue, for some reason, the Get rows node was sending 3x the amount of items.
I set it to Execute Once and now its working correctly
1 Like
Nice you actually found the root cause yourself.
Loop Over Items just loops through whatever list it receives, and in your case Get Rows was sending more items than expected. That’s why the loop never really ended.
Turning Execute Once on fixed it because it stopped Get Rows from multiplying the input. Now the loop gets the correct list and can finish normally.
Good catch!