About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Email Parser template to extract list of repeating items

  • 5 July 2023
  • 3 replies
  • 20 views
ThomasU100

Hello!

 

Im trying to correctly output the following email template, it is essentially a list. In this example there are 3 ‘ShotNumbers’ and 3 ‘Vendors’:

Input as shown in email template:

 

SE0_TO_074_408_230613 to Creep

SE0_TO_075_406_230613 to NVIZ

SE0_TO_075_408_230613 to NVIZ

 

Set Template:

{{shotnumber}} to {{vendor}}

{{shotnumber}} to {{vendor}}

{{shotnumber}} to {{vendor}}

 

However, I am just getting a limited output when running Email Parser, it is extracting the first ‘shotnumber’ and the last word as the ‘vendor’, not line by line as requested in my template:

Output:

shotnumber SE4_TO_074_408_230613
vendor NVIZ

 

I actually want the output to contain 3x Shotnumbers and 3x Vendors.

If the output was correct, I would push to Google Sheets with 3 individual rows with two columns, a row and column for each shot number, and the adjacent column would be for the vendor.

Is there a way to do this in the Email Parser template?

Thanks

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

3 replies

ken.a
Userlevel 7
Badge +6

Hi @ThomasU100,

It seems like there might be a little mix-up with how your templates are set up. If the template names are too similar, the Email Parser could get a bit confused. If you're dealing with multiple Shotnumbers and Vendors, a good idea could be to give them distinct names. Here's a suggestion on how you could do that:

{{shotnumberOne}} {{vendorOne}}

{{shotnumberTwo}} {{vendorTwo}}

And so on.

Please give that a try, and let me know how it goes. 😊

ThomasU100

Hello Ken

 

Sometimes there are 5 shots, sometimes the list is extensive. How many do u write?  Up to {{shotnumber100}}?

 

Thanks 

ken.a
Userlevel 7
Badge +6

Hi @ThomasU100,

You’re correct. If there are instances where you have more than 5 shots, and sometimes even a very long list, it's a good idea to use an email with 5 or more shots as your sample for creating templates.

You can create a template for each Shot and Vendor. This way, even if an email comes through with just 1 shot/vendor, your Zap will still be able to capture it. This approach ensures your Zap is prepared for all scenarios, whether it's a single shot or an extensive list.

Hopefully, this clears everything up. 😊

Terms & Conditions