Parse email-protection reports with failure alerts

The scenario catches reports in AWS SES, parses them into MySQL, and on a signature or sender problem warns you in botHelp and by email.

  • Reports parsed automatically
  • Data saved to MySQL
  • Alert on a signature or sender problem
  • Notification to botHelp and AWS SES
Email Trigger (IMAP)
Add it to your accountScriptera

How it works

To get MySQL notifications in botHelp, you don't need a developer: a ready-made scenario watches events and sends messages for you.

  1. Starts when: Email Trigger (IMAP)
  2. Then: Unzip File
  3. Then: Extract XML data
  4. Then: Parse XML data to JSON
  5. Check: If multiple records to parse
  6. If yes: Split Out For Separate Entries
  7. Then: Rename Keys
  8. Then: Map fields for DB input and parse
  9. Then: Begin format date
  10. Then: End date format
  11. Then: Input into database
  12. Check: If issue with DKIM or SPF
  13. If yes: Slack Post Message On Channel
  14. If yes: Send Error Notification Email
  15. If no: Rename column for consistency

You can launch this MySQL + botHelp integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios