Hey guys, I’m a newbie to n8n and trying to make a simple workflow, so basically i want to send email to multiple recipients (for example 2) with a custom form which include 2 data: Sale and Profit (in number). After that i want OpenAI to help pick those 2 data that 2 recipient replied me (so a total of 4 numbers) and put them in my google sheet in which i already have 2 rows named Sale and Profit. my steps are:
- Trigger manually.
- Node Outlook: Send and Wait for Response, in “To” i typed 2 emails of the recipients and made a custom form already.
- Node OpenAI: i use Message a Model with prompt
- Node Google Sheet: i map each column manually with values “Sale” and “Profit” from Outlook.
So the problem is the email with custom form was sent to both recipients, however only 1 of them can send the data back. when the 1st recipient sent the data, the 2nd recipient when clicked the form only received the announcement “No action required”. the data from 1st recipient was picked by OpenAI and successfully sorted in my Google Sheet.
I don’t know how to have the workflow receive both replies from 2 recipients and to sort into Google Sheet. Please help!!! (sorry for my simple English).