I have a folder with say 10 CSV files. I want to run a workflow that reads one CSV file at a time and process it. How can I achieve this without using the Read Binary Files node as reading all files together in the same instance of the workflow will cause memory issues. The file names and quantity are dynamic and thus I need to be able to execute the same workflow once for each file and process the file.
Also can a workflow take in parameters via n8n CLI or otherwise in which case I can write an external script that will start the workflow via CLI with filename as a parameter for each file in the directory?
Any guidance is much appreciated.
Thank you,