Workflow to Process Comma-Separated List and Generate Excel Report

[herrT15]

Hello,

I am trying to build a workflow in n8n where I can input a variable containing a comma-separated list of names. Here’s what I want to do:

1. The workflow should take the list as an input variable.
2. It should then retrieve the first name from the list and perform an HTTP request using that name.
3. The HTTP request will return data, and the workflow should repeat this process for each name in the list.
4. Finally, the data retrieved from all names should be concatenated and saved into a single Excel file.

I’m looking for guidance on how to loop through the list, handle the HTTP requests, and create the Excel file with the combined results.

Would appreciate any suggestions or tips on how to achieve this!

Thank you!

[bartv]

Here’s a snippet that will get you started: it takes a string, splits it into an array and then turns the array into items that are ready to process. I’ll leave the rest to you

[herrT15]

Hello,

Thanks for your quick reply. This part is working well.
Now the loop is the thing I have no idea of how to implement it

Thanks a lot!