Question

Formatter (Split Text) including field titles in output

  • 26 January 2022
  • 4 replies
  • 107 views

I am trying to set up a lead forwarder that adds the lead to a specific MailChimp campaign and also adds the contact to a new row in a Google Sheet. I was using Mail Parser by Zapier for this but it’s way too unpredictable and I am looking for something that will need less maintenance/tweaking.

I have the leads being sent to a Email By Zapier inbox, and the trigger is set to this inbox.

Here is an example of the data that is included in the trigger email:

Company Name: Test Company Name
First Name: Test
Last Name: Jones
Email: tjones87@gmail.com
Address: 182 Wall Street
City: Houston
State: TX
Province: AB
Zip/Postal Code: 30350
Country: USA
Day Phone: 2027059867
Available Capital: $30,000
Comments:

The action is Formatter by Zapier with the following settings: 
Text > Split Text > Input Body Plain > Separator “:” > Segment Index All As Separate Fields 

When testing this it always includes the title of the next field in the output.

Example:

Item 2

Test Company Name

First Name

Item 3

Test

Last Name

Item 4

Jones

Email

Item 5

tjones87@gmail.com

Address

Item 6

182 Wall Street

City

Item 7

Houston

State

Item 8

TX

Province

Item 9

AB

Zip/Postal Code

 

How can I fix this? Thanks in advance.

 

 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +14

Hi @franchise007 

Try the Mailparser app: https://zapier.com/apps/mailparser/integrations

 

Or a Code step can be used to do parsing: https://zapier.com/apps/code/help

Hi @franchise007 

Try the Mailparser app: https://zapier.com/apps/mailparser/integrations

 

Or a Code step can be used to do parsing: https://zapier.com/apps/code/help

I am trying to switch from the Mailparser app because it’s parsing out extra data in specific fields, even after many attempts to correct the issue with new templates. 

 

I will look into the code step. Thanks.

Userlevel 7
Badge +14

@franchise007 

To clarify, Mailparser.io is a different more robust app than the mail parser by Zapier app.

Userlevel 7
Badge +9

Hey @franchise007 Just wanted to check in to see how you made out here! Were you able to get things working with a Code step or by utilizing Mailparser (instead of the Zapier email parser)? Let us know!