Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

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

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

Hello Ken

 

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

 

Thanks 

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