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
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.