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
Address: 182 Wall Street
Zip/Postal Code: 30350
Day Phone: 2027059867
Available Capital: $30,000
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.
Test Company Name
182 Wall Street
How can I fix this? Thanks in advance.