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!

  • What have you tried so far? – music2myear Jun 4 '19 at 18:55
  • I have got to the point where the parent folder and subfolders have been created, I renamed the subfolders by using the excel spreadsheet, and I was able to route to the bin folder and select items and move them over to the parent folder. What I do NOT know how to do is to move the files into their custom named folder in the same automator (or AppleScript) program since the files have been renamed a custom name. How do I point those files to a path that did not exist prior to running the workflow? That's where I'm stuck. – mstrain Jun 4 '19 at 21:37
  • TL;DR. A picture is worth a 1000 words. Screenshot your workflow, and if you can post a link to it in the comments, it saves whomever is going to help you the chore of having to try and recreate where you're at from a written description. – CJK Jun 5 '19 at 1:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.