Thank you in advance for helping me out (if you so choose). I am currently creating an automator sequence that will move .pdf items from a "Bin" folder on the desktop to a variety of folders of which do not yet exist. I'm scratching my head a bit about it and was wondering if anyone could help.
So, when I start by creating the first folder I need ("Main" folder) and route it to the desktop (using the drag and drop "New Folder" creator in automator), Then I can name it "Main" Then I can add the "Set Value of Variable" item from the list and create a variable called "Parent Folder"
The problem now is that I need to create subfolders in that parent folder ("Main"). So, let's call them "Subfolder 1" Subfolder 2" etc. But I need them to have specific names, and I need to be able to set a variable for each of them to recall their location later when sorting the .pdf documents. The names for each of these subfolders will be in an excel document which will be open already. So, automator will need to go to the document, select a specific cell, then rename "Subfolder 1" to that name in the box. Let's call it "Renamed Subfolder 1" While I can write an AppleScript for that action to happen, the problem is, how do I assign that newly created folder a path (or variable) so that I can recall it later. The name "Renamed Subfolder 1" will be on the clipboard from the excel document already, so maybe there is a way to set a variable or path or something to that folder so I can reference it?
As that is the main area where I am confused, is there any chance someone can help me with that?
The goal will be to have many of these custom named subfolders in the parent folder, then going into the 'bin' folder and moving the .pdf files to their respective locations where they belong using the 'Find Finder Items' function then the 'Move Finder Items' repeatedly to their respective folder paths. The problem is, again, I don't know how to tell automator where the folder path is when it does not yet exist until we begin running the workflow.
Do I need to use AppleScript or bash for that? If so, an example would be SUPER helpful.
Any help would be greatly appreciated!