Parse DMARC Reports

Name: Parse DMARC Reports
Rating: 3.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

41 views

0 downloads

Data ProcessingDMARCIMAPMySQLautomationemailreportingsecurity

This workflow parses DMARC reports received via IMAP and stores the data in a MySQL database.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This n8n workflow is designed to automate the process of parsing DMARC (Domain-based Message Authentication, Reporting & Conformance) reports. It fetches these reports from an IMAP email account, extracts relevant information, transforms it, and then inserts it into a MySQL database for further analysis.

Key Features

Fetches DMARC reports from an IMAP server.
Parses the report structure to extract key data points.
Formats date fields for consistent database storage.
Maps and transforms data for insertion into a MySQL table.
Checks for issues related to DKIM or SPF authentication.

How To Use

Import the workflow JSON into your n8n instance.
Configure the 'Email Trigger (IMAP)' node with your IMAP server credentials and the email address where DMARC reports are sent.
Configure the 'Input into database' node with your MySQL database connection details and ensure the 'dmarc' table exists with the correct schema.
Ensure the 'Rename Keys' node is appropriately configured if specific key renaming is required before processing (though the current configuration appears to have placeholders).
Manually trigger the workflow or set up an appropriate trigger for receiving emails.

Apps Used

DMARC

IMAP

MySQL

automation

reporting

security

Workflow JSON

{
  "id": "471e6b02-71d1-487d-86b5-3466623e08ff",
  "name": "Parse DMARC Reports",
  "nodes": 0,
  "category": "Data Processing",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.