Use scripts as rule actions
You can attach an AppleScript script to a Mail rule. For example, you could have an incoming message trigger a script that copies information from the message and pastes it into a database that works with Script Editor.
Choose Mail > Preferences, then click Rules.
Select an existing rule to edit, then click Edit. Or click Add to create a rule.
Choose Run AppleScript from the “Perform the following actions” pop-up menu.
Choose a script from the pop-up menu of scripts that are located in ~/Library/Application Scripts/com.apple.mail. Or choose “Open in Finder” to open the folder so you can copy a script into it.
If you later move or rename the script, your rule will not work.
Click OK to save the rule.
If you use iCloud Drive, your rules are available on your other Mac computers that have iCloud Drive turned on. Scripts attached to rules aren’t available. For more information, see Store your desktop and documents in iCloud.