I created a workflow that demonstrates how such a job could be done. I use two loops. The first one lists all the folders from the import folder, the second one iterates thru all the CSV files found there. The names of the folders and files are extracted and used to name the resulting Excel files. Maybe you could modify that to your needs.
This is a companion discussion topic for the original entry at https://kni.me/w/MAdGL6wj5zjUCwDB