Collecting user reply via email

[Joe_B]

I have faced a problem on now I have using the google sheets to store the username and their email. So I will need to send to the user and wait for all the user to reply. If I using the send a message and wait for response, it will just success send to first user only, the other will not successfully to sent out. How can I solve this kind of problem？

I need to get all the user reply information (accept/reject to join the activity)

[Joe_B]

But if sending one by one, if I have 100 user, I need to execute it 100 times?

[Joe_B]

How to make store their replies in a sheet?

[Joe_B]

So Basically my workflow will be:

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]

I have using the looping function, but it did not work correctly.

[Joe_B]

[Joe_B]

In the if statement, how should I write if the user reply is accept/reject?

[Joe_B]

[Joe_B]

yes. What do u means Let’s set this up Correa.

[Joe_B]

still come out the same error

[Joe_B]

But if I using the send message and wait for response, it will show the approval and disapprove

[Joe_B]

[Joe_B]

And it will just loop the first user only

[Joe_B]

[Joe_B]

Is that possible I make it active, then will make easier for u?

[Joe_B]

@Bringasher

{{ $json.email || ‘[email protected]’ }}

now directly cannot sent the email

[fahmiiireza]

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

1. 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
2. workflow tht will be triggered when the form is filled

so it should be something like this