Parse DMARC Reports, Save to DB & Notify on DKIM/SPF Errors

This workflow monitors your postmaster email inbox via IMAP for incoming DMARC reports (rua tag) from email providers. It automatically downloads attachments, unpacks and parses the XML reports into structured JSON, then maps and formats the data for insertion into a MySQL or MariaDB database. This keeps a comprehensive log of all DMARC verification results without manual intervention.

The key benefit is intelligent alerting: instead of notifying on every report, it only triggers Slack or email notifications when SPF or DKIM checks fail, indicating potential spoofing attempts or misconfigurations in your email setup. This reduces noise, saves time, and ensures you focus on actionable issues, improving email security management.

Ideal for postmasters, sysadmins, or domain owners managing email servers. Use cases include proactive monitoring of DKIM/SPF compliance across high-volume domains, quick response to spoofing threats, and maintaining audit trails for compliance. Easy setup requires configuring IMAP credentials, database connection, and notification channels.

Enhances DevOps workflows by automating tedious XML parsing and conditional logic, freeing you to focus on resolution rather than report sifting.