Looping to Send All Email

[Joe_B]

How can the looping function can send all the email that I stored in the google sheets? For now it can just send the first user email and wait for that response only….

[mohamed3nan]

Hi @Joe_B

I think you can achieve that by wrapping the “Send message and wait for response” node in a subworkflow,
You don’t need the loop node, since n8n handles that automatically when the Google Sheets node outputs more than one item.

Here’s an example where I send two emails and wait for the replies:

Also do not forget to disable the Wait For Sub-Workflow Completion

---

If this fixes the issue, please❤️ and mark the reply as the solution✅ . Thanks!

[Joe_B]

How u can link the sub-workflow? Because I’m is trigger

[mohamed3nan]

right click on the “Send message and wait for response” node and click on “Convert node to sub-workflow”

[mohamed3nan]

Did it work @Joe_B ?

[fahmiiireza]

hi there @Joe_B

you can do something like this

hope it helps!

[Joe_B]

For the start, need how to setting?

[Joe_B]

[mohamed3nan]

You just need to remove the loop node from your workflow

then right click on the “Send message and wait for response” node and click on “Convert node to sub-workflow”

just test that

[Joe_B]

Yes all the user can received the email

[mohamed3nan]

Glad it worked @Chinwe_Nwokoro , Thanks for confirming,
Would you mind please like❤️ and mark the reply as the solution ? Thanks!

[Joe_B]

1. First, I will using the google sheets to store the username and their email

2. After that, I will send the email to all the user that have stored in the google sheets. I will ask them want to joining and event or not.

3. So the user will reply the message whether is accept or reject to joining event.

4. I will need to collect the user reply message and make the further action.

[Joe_B]

But how can I get the user reply message on accept or reject?

[Joe_B]

Yes. Here can just send an email, but I still want to get the user reply on want to accept or reject to join the activity

[mohamed3nan]

Go to the Gmail node in the sub-workflow then look for “Approval Options” you can look for the options that you need

[fahmiiireza]

i think i replied to you in another discussion about it, you send the n8n form link and from there you will know if they want join or no

[Joe_B]

In the sub-workflow, how setting the email part?

[fahmiiireza]

this one @Joe_B

Collecting user reply via email

Hi there @Joe_B , i think for what you want, it’s better if we do it with 2 workflow this is what im thinking about workflow to send the email where there will be a link tht will redirect them to fill a yes/no form and they can just answer yes and no workflow tht will be triggered when the form is filled so it should be something like this

[Joe_B]

alright, I will take a look

[Joe_B]

Thanks so much