The steps in the order they run, from what starts it.
- 1Email Trigger (IMAP)Email Read ImapService
- 2Unzip FileCompressionService
- 3Extract XML dataExtract From FileService
- 4Parse XML data to JSONXmlLogic
- 5If multiple records to parseIfLogic
- 6Split Out For Separate EntriesSplit OutLogic
- 7Rename column for consistencySetLogic
- 8Rename KeysRename KeysService
- 9Map fields for DB input and parseSetLogic
- 10Begin format dateDate TimeLogic
- 11End date formatDate TimeLogic
- 12Input into databaseMy SqlService
- 13If issue with DKIM or SPFIfLogic
- 14Slack Post Message On ChannelSlackService
- 15Send Error Notification EmailEmail SendService
How it's built
- Starts on
- An arriving email
- Steps
- 15, with 2 branches
- Size
- Medium: a working afternoon
- Connects to
- Email, MySQL, Slack
- Model
- None. This is plumbing, not judgement
Questions
What does it need to run?
An n8n account, plus your own Email, MySQL and Slack accounts. You connect your own accounts after importing it; none are included.
What starts it?
It starts on an arriving email.
Does it use AI?
No. Every step is fixed logic or a call to a service, so it does the same thing every time.
How long does it take to set up?
Plan an afternoon. 15 steps is enough that you should read each one before running it.
How do I import it?
Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.
Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 15 steps before you point it at anything that matters.