How to send distinct emails for each item in a list?

Need help Database
1

Hi!

When someone makes an order of items (with different sellers), I’m trying to send an email to each seller to notify that their item has been purchased.

Does anyone know how I would be able to write the email body so that it only lists the items specific to seller I am emailing?

I tried using filtering, but would appreciate any advice on how to approach this.
(Each item has a Name and a Seller Email)

Screenshot 2024-01-27 at 10.12.13 PM
Screenshot 2024-01-27 at 10.12.13 PM676×1242 61.4 KB

Screenshot 2024-01-27 at 10.16.38 PM
Screenshot 2024-01-27 at 10.16.38 PM672×522 24.1 KB

2

You need to create a recursive workflow so that you loop through the list of sellers on the order and send an email to the single seller for that particular ‘loop’…right now it looks like you are trying to send an email to multiple sellers via a single email action.

3

Thanks so much for the reply! How would I do a recursive function in bubble’s workflows? I am not sure I have done that yet