Hello, I am setting up a flow for sending sequential emails. I need each row of this spreadsheet, which contains information separated by columns, to go through the flow and at the end of it, an email should be sent for each row. I set up a flow and was able to get the information from the first row, and through an HTTP request, I sent it to an OpenAI node where I have a bot with a prompt that will format this email, and I output it in a Gmail node. However, I don’t know how to make this flow move to the second, third, fourth, or however many filled rows there are, and construct an email and send them sequentially. Is there a way to do this? I already tried using the loop function (Split on Batches), but it didn’t work; maybe I didn’t configure it correctly. Could you help me?
It looks like your topic is missing some important information. Could you provide the following if applicable.
- n8n version:
- Database (default: SQLite):
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app):
- Operating system:
Welcome to the community @Rafael_Pascotto !
Tip for sharing information
Pasting your n8n workflow
Ensure to copy your n8n workflow and paste it in the code block, that is in between the pairs of triple backticks, which also could be achieved by clicking </> (preformatted text) in the editor and pasting in your workflow.
```
<your workflow>
```
That implies to any JSON output you would like to share with us.
Make sure that you have removed any sensitive information from your workflow and include dummy or pinned data with it!
Could you share your workflow to have a better understanding what you have built so far? I wonder why Loop did not work for you.
Thank you, everyone. After watching some videos on YouTube, I understood where the mistake was. I was using the loop only once, when in fact I needed one loop node for the Google Sheets and another loop node for my OpenAI AI node. Only after that would the output go to the email. I did it this way, and it worked! Thanks to all
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.