I have a sheet like >
NAME | Apples | Oranges | email
Zak | 2 | 1 | Zak@zak.com
Zak | 3 | 6 | Zak@zak.com
Zak | 1 | 2 | Zak@zak.com
mika | 2 | 1 |Mika@zak.com
mika | 3 | 6 |Mika@zak.com
mika | 1 | 2 |Mika@zak.com
and i want to do " if apples > oranges = email name"
And i did this by “for earch row” → " if apples >oranges" then “email name”
but what i would like to do, is rather then send an email per row, is send 1 csv to zak, and 1 csv to mikam each containing the relevant row data