Question

Parsing emails to create/update Active-campaign list

  • 22 June 2023
  • 3 replies
  • 41 views

I think I am making this much harder than it needs to be, so hoping someone can help me. 

I have a podcast on Buzzsprout, in which people can choose to pay a monthly subscription.

When they join I receive an email to GMAIL giving me their details. I also get an email when they cancel. From here, I want to 

  1. add them to a mailing list in ActiveCampaign
  2. tag them as ACTIVE in order to automatically send them a welcome email in Active-campaign

Then when they end their subscription, I want to

  1. remove the ACTIVE TAG

HOW do I do this?  So far I have tried to set up a filter and automatic forwarding of the emails from gmail to Email Parse by Zapier (this didn’t work first time so I created a zap to forward these emails). 

Then I created zap 2 to send the Parsed info into a new row on my Google sheet.

Then I created zap 3 to create/update activecampaign contact when new Google sheet row is added

where I also add the tag.

 

This is where I am hitting a wall.  I am not sure how to separate New Subscribers from Cancelled Subscribers.  I can parse that info and add it in a “Status” column in the Google sheet.   

 

I hope I have explained this clearly enough for someone to help clarify what I should be doing.  Do I need so many different zaps? Do I need a Google doc? Can I do a branching scenario in a zap (if this then that and if that do this instead)?

Thanks in advance. 

​​​​​​​BTW I am a beginner :S


3 replies

Userlevel 7
Badge +14

Hi @AnnaTyrie 

Good question.

We’d need to see screenshots of the received email templates to be able to better evaluate and advise.

Options:

  1. Formatter
    1. Formatter > Text > Extract Email Address
    2. Formatter > Text > Extract Pattern
    3. Formatter > Text > Split
      1. May need a few of these steps to isolate the desired value.
  2. Email Parser
    1. I recommend Mailparser
      1. More robust and reliable than the Email Parser by Zapier
  3. AI
    1. ChatGPT / OpenAI
      1. See article below
  4. Code
    1. Custom code to do email parsing
      1. https://zapier.com/apps/code/help

 

 

Try these Zap steps:

  1. Trigger: Gmail - New Email Matching Search
  2. Action: ???
    1. Pick from the above options
  3. Action: ActiveCampaign - Create/Update Contact

Thank you @Troy Tessalone 

I can’t seem to get the basics to work, so maybe this needs to continue to be a manual job.  

I have Gmail forwarding my emails to Email Parser, and all the tests worked when I manually forward the emails but when it happens in real-time the email forwards but not all the info shows in Email Parser - see screen shots. 

If I can’t get this part to work then I have no chance of automating the rest. 

 

:s

 

Userlevel 7
Badge +14

@AnnaTyrie 

Did you try another option?

Options:

  1. Formatter
    1. Formatter > Text > Extract Email Address
    2. Formatter > Text > Extract Pattern
    3. Formatter > Text > Split
      1. May need a few of these steps to isolate the desired value.
  2. Email Parser
    1. I recommend Mailparser
      1. More robust and reliable than the Email Parser by Zapier
  3. AI
    1. ChatGPT / OpenAI
      1. See article below
  4. Code
    1. Custom code to do email parsing
      1. https://zapier.com/apps/code/help

Reply