Email Classification

The purpose of this workflow is to showcase the "Email Connector (Labs)", "Email Reader (Labs)" nodes, and the "Email Mover (Labs)" nodes. The workflow aims to classify emails based on subject keywords and attachment presence.

The "Email Mover (Labs)" node moves emails matching the criteria to selected folders. Users can implement more complex logic in KNIME Analytics Platform.

You can easily download and run the workflow within your KNIME installation. For optimal performance, we recommend using the latest version of the KNIME Analytics Platform.

To execute the workflow, you don't have to provide email server details such as address, port or user login credentials. The "Email Inbox Setup" component sets up a self-contained mail server. It includes four folders and ten simulated emails with counterfeit attachments ready for use.
For more information, refer to the component description.

Check "External resources" for more information about how to obtain the necessary tokens to connect to your ISP email account using IMAP protocol (e.g. Gmail or Outlook) via the "Email Connector (Labs)" node.

Hence, there is no need to provide any additional information in the "Email Connector (Labs)" node. All node configurations are managed by the variables previously created by the component. The inbox of User2 is being connected to since it is the inbox where the fake emails were sent.

We use the "Email Reader (Labs)" node to read emails from the inbox. Since the other folders are empty, we only need to focus on this particular folder. By clicking "Show advanced settings", we can check the "Output attachments table" option, which extracts all the attachments from the emails. A second table output port will appear.

Using the "Value Lookup" node, we append the file name to the email table information, using the Email ID column as a key value.

With the "Rule Engine node", we create a new column called "Move email criteria" with two values.

0 = The email contains "Report" in the email subject and has an attachment.
1 = The email contains "Recap" in the email subject and has an attachment.

Finally, we filter matched emails and move them to a target folder using "Row Filter" nodes and the "Email Mover (Labs)" node.

External resources

• POP, IMAP, and SMTP settings for Outlook.com
• Set up Gmail with a third-party email client