Parse DMARC reports, save them in database and notify on DKIM or SPF error
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 15 nodes and runs when a new email arrives over IMAP. Along the way it connects MySQL and Slack.
How it runs
Trigger: When a new email arrives over IMAP.
- Unzip File (Compression): uses Compression
- Extract XML data (Extract from File): extracts data from a file (xml)
- Parse XML data to JSON (XML): converts between XML and JSON
- If: checks a condition and branches into true / false
- Split Out: splits a list into separate items
- Rename column for consistency (Edit Fields (Set)): sets 1 field: fbr
- Rename Keys: uses Rename Keys
- Map fields for DB input and parse (Edit Fields (Set)): sets 13 fields: full_data, org_name, date_range_begin…
- Begin format date (Date & Time): formats or calculates dates
- End date format (Date & Time): formats or calculates dates
…plus 4 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (12)
- Email Trigger (IMAP)
n8n-nodes-base.emailReadImap - Date & Time
n8n-nodes-base.dateTime - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - MySQL
n8n-nodes-base.mySql - Rename Keys
n8n-nodes-base.renameKeys - Compression
n8n-nodes-base.compression - Extract from File
n8n-nodes-base.extractFromFile - XML
n8n-nodes-base.xml - Split Out
n8n-nodes-base.splitOut - Slack
n8n-nodes-base.slack - Send Email
n8n-nodes-base.emailSend
From the author
Who is it for If you are a postmaster or you manage email server, you can set up DKIM and SPF records to ensure that spoofing your email address is hard. On your domain you can also set up DMARC record to receive XML reports from email providers (rua tag).…