Write data in empty rows from where it left inside for each loop

I am using data scraping inside for each loop so my question is how can I write new data in the same excel sheet when using a loop instead of getting data written over and over again?


you can try some thing like below

Initialize counter value i.e counter = 1
in a loop
use if activity and give condition like “counter =1”
use write range activity and pass necessary inputs
use append range activity with same inputs as write range

increase the counter value out side if