Automated DMARC Email Report Parsing and Notification Workflow

This n8n workflow automates the process of monitoring, parsing, and storing DMARC reports received via email. It starts by triggering on new emails with DMARC reports through an IMAP email account. The workflow then unzips attachments, extracts XML data, and converts it into JSON format for further processing. It handles reports that may contain multiple records, mapping fields appropriately for database input. The data is then formatted for consistency and inserted into a MySQL database. The workflow also checks for issues with DKIM or SPF authentication results, sending notifications via Slack or email if any issues are detected, thereby ensuring timely alerts for email authentication problems. This automation is valuable for organizations managing email security, offering continuous monitoring and reporting of DMARC compliance and issues, facilitating swift response to potential email spoofing or phishing attacks.