Daemon@gmail

[Florencia Abila]

Iam building a flow to keep track of undeliverable email addresses in an Excel spreadsheet. The goal is to remove them from our mailing list. When there is an issue with an address because it no longer exists or was entered wrong, the email delivery service of the intended recipient will send a message to our shared inbox (with something along the lines of [EXTERNAL] Undeliverable email).

Sometimes this will come back with the faulty address in the From line and trigger the flow to populate the spreadsheet, but other times it will have an Outlook item in the message that contains the incorrect email address and the undeliverable email will be from a separate address (like mailer...@gmail.com) which is what gets populated into the spreadsheet.

I have tried running the flow to extract the contents of the attachment and those to the spreadsheet, but it comes up blank because it is an "Outlook item" and technically not an attachment. Are there any other ways that I can get the information from the attachment into the spreadsheet?

The Google Script scans your Gmail mailbox for messages from mailer...@gmail.com and prepares a bounce email report logging the failed deliveries in a Google Spreadsheet. See sample Gmail bounce report

3a8082e126