How to extract email addresses from purchase confirmation emails?

Question

Dear Zapier Community!I’ve been searching for this in our Community but have not found, and I need your help!I receive automatic payment confirmation each time when a customer buys my product.	Payment confirmation has a customer’s E-mail that inside the content of confirmation E-mail. Customer’s E-mail is already registered on the list in Active Campaign.	I want zap that triggers when purchase confirmation E-mail lands in the box, searches for customer’s E-mail inside purchase confirmation E-mail content and add specific tag to the same E-mail in Active Campaign.This is going to save a lot of my time and improve customer’s experience.

SamB · Accepted Answer

I just came across this and wanted to confirm that the Formatter (Text > Extract Pattern) that Troy mentioned has the ability to return multiple email addresses.

To achieve that you’d need to set the Match All field to Yes:

The pattern you’d use to extract the email addresses (see How to Extract Email Addresses, Phone Numbers, and Links From Text) is as follows:

(?:[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*|"(?:[\x01-\x08\x0b\x0c\x0e-\x1f\x21\x23-\x5b\x5d-\x7f]|\\[\x01-\x09\x0b\x0c\x0e-\x7f])*")@(?:(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?|\[(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?|[a-z0-9-]*[a-z0-9]:(?:[\x01-\x08\x0b\x0c\x0e-\x1f\x21-\x5a\x53-\x7f]|\\[\x01-\x09\x0b\x0c\x0e-\x7f])+)\])

Provided the email addresses only use standard English characters the pattern above should work for all standard email addresses, sub-domains, and TLDs. :)

Troy Tessalone · Answer

Hi @PrzemysławTry using the Formatter > Text > Extract Email action step: https://zapier.com/help/create/format/extract-data-in-zaps#extract-email-address

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded