Automator - Deleting files with date modified older than 30 days, except if in a folder labeled red I am trying to do an automator calendar event where every Friday, it deletes files whose date modified is older than 30 days; EXCEPT files within folders labeled red. 

I have my Documents folder with 3 files, one folder created today and labeled red, a folder last modified a week ago, and a pdf that was modified more than 30 days ago.

My automator script goes as follows:

[Find Finder Items] Search "Documents", ALL of the following are true:

-Date last modified is not in the last 30 days
-Label is not red


[Move Finder Items To Trash]

//end

But this moves the red labeled folder and the older pdf, when it should only move the pdf to the trash.

Can anyone help me? Thank you!

Edit: Running macOS 10.13.3
My initial suggestion to the problem was to replace the actions you currently have in your Automator workflow with a Run AppleScript action that uses this command:

    tell application "Finder" to get every item ¬
        in the (path to documents folder) ¬
            whose modification date &lt; ((current date) - 30 * days) ¬
            and label index is not 2


You would then have either added an action after this to trash those items, or change get every item to delete every item in the script.  However, as @user3439894 pointed out, this won't traverse folder trees, so any items inside a folder that are older than 30 days (and not tagged red) will escape detection.

The following script is an example of a method that uses recursion to descend through the directory tree deleting files (or marking them for deletion) as it goes:

    property D : {}  # The files to delete
    property R : path to documents folder  # The root of the directory tree structure
    property age : 30 * days
    property red : 2


    descend into R

    # tell application "Finder" to delete D
    return D


    to descend into here
        local here

        tell application "Finder"

            # Mark files which are older than 30 days for deletion
            # EXCEPT any that are tagged red
            set end of D to every file in here whose label index is not red ¬
                and modification date &lt; (current date) - age

            # This checks to see if, following the purge, the 
            # current folder will become empty.  If so, it can 
            # be deleted too.  It adds to processing time, so
            # remove this code block if you don't need it.
            count the last item of D
            if the result is equal to (count the files in here as alias list) ¬
                and (count the folders in here) is 0 then
                set the end of D to here
                return
            end if

            # This ensures folders tagged red and their contents
            # are spared from the purge
            get the folders in here whose label index is not 2

            repeat with F in the result
                set F to the contents of F  # de-referencing

                descend of me into F
            end repeat

        end tell
    end descend


I have tested it briefly on my own fairly complex tree structure, and it appeared to work successfully.  However, I'm writing this and testing it whilst quite tired, but regardless, I would always strongly advise that you test this script yourself on dummy files and folders to ensure it works.  Please report back on how it goes, including—if they arise—any errors, with specific details on how I can reproduce the error myself.