I need to iterate over every single row of a csv file that I’ll be receiving through Webhook → SpreadsheetFile, and manipulate each row individually. Can I use the Spreadsheet File node by itself or do I need something else? The skeleton of the workflow should look something like this:
Hi @RafaFischerReichert, you would typically use two separate Spreadsheet File nodes in such a scenario. The first one reads the file and makes the data available to n8n as JSON data.
You can then manipulate the data as needed until you have the data you need. Lastly, use a second Spreadsheet File node to write the n8n JSON data into a CSV file again.
In the process you don’t typically need to build loops yourself as almost all n8n nodes will run once for each item they receive. So something like this:
Hope this helps!