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.

  • Home
  • Get Help
  • How Do I
  • How to extract specific data from an email and Zap just the vendor, name, and email to a spreadsheet?

Hi,

I’m getting more and more familiar with Zapier but I have tried building this particular Zap and I’m just not sure it’s possible. 

I have an incoming email as my trigger - I only need the vendor, name, and emails zapped to a spreadsheet.

Example of email:

Your email was sent to:

Vendor: Name: Email

Vendor: Name: Email

Vendor: Name: Email

blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah 

I can’t figure out how to ONLY zap the information after ‘Your email was sent to:’ and ignore everything after the last email address. 

Anyone have any idea how I can format this?

Hi there @Virtual Library,

Welcome to the Community! 🎉

Before we dig deeper into this, have you tried using Email Parser by Zapier? This app allows you to parse only the important data that you’re after. You can learn more about Email Parser by Zapier here: https://zapier.com/features/parser

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

Hi @Virtual Library 

Resources for email parsing...

 

Hey @Virtual Library! 👋

Did you manage to extract the necessary data from the email using Email Parser Ken suggested or one of the other options outlined in the guide that Troy shared?

Happy to lend a hand if you’re still stuck at all, just let us know! 🙂

o format the Zap to extract only the relevant information (Vendor, Name, and Email) from the email, start by using the "New Email" trigger from your email service to capture the incoming message. Once that’s done, in the next step, you can use the "Formatter by Zapier" action to handle the data extraction. Choose the Text action event and select the "Extract Pattern" option. For this, you’ll need to use a Regular Expression (RegEx) to pull the vendor, name, and email from the body of the email. A possible RegEx pattern you could use is: Vendor: (.+?)\nName: (.+?)\nEmail: (.+?). This pattern will capture the text that appears after "Vendor:", "Name:", and "Email:", up until the next line break. Once the relevant data is extracted, the Formatter step will output the information in a structured format, which can then be mapped to your spreadsheet. Finally, send the extracted details to your spreadsheet using an action like Google Sheets, ensuring that each field (vendor, name, email) is mapped to the correct column.

Terms & Conditions