The Email Parser Guide: How to Automatically Copy Data From Your Emails
- Get link
- X
- Other Apps
Ebay emailed—someone ordered something from your store. Your bank emailed with your monthly statement, your credit card is reminding you to pay your bill, and Apple's reminding you of that app you bought last night. And the contact form on your website is nice, but each message is another thing piling up in your inbox.
It's easy enough to sort through and manage data in a spreadsheet or database. In your email inbox, though, notifications are only more clutter, more things to archive and forget. It's easier to only take the time to copy text from emails and paste it somewhere useful when you need it.
Or, you could let an app do the busywork for you. Here's how to parse text from emails and put their data to good use—automatically.
What Is an Email Parser?
When your boss or best friend emails, you likely read every word.
The rest of the time, odds are, you skim the message. Your eyes quickly dart across the screen, picking out keywords and phrases like New Sale and $4.99 and Payment Due: Friday, Nov 3.
Email parsers work the same way. You teach these programs how to recognize patterns in your emails, tell them what data is actually important and that everything else can be ignored, and then have them save only the important stuff. Then, connect the email parser to an automation tool like Zapier to save that important text into any other apps you want to log the orders in a spreadsheet, for example, or remind you to pay your credit card bill tomorrow. As long as the emails are all laid out generally the same way, the email parser should be able to figure out what's important and copy the data for you.
Got that? Ok. Let's back up, and step-by-step build an email parser that can copy text out of your emails and put it to work. We'll use Zapier's Email Parser—a free tool to copy text out of your emails—and then look at other tools that can do more with your emails. The basics work the same in every app, and once you know how to parse one email, you know how to parse them all.
Onwards.
1. Make a new email parser
2. Forward an Email to the Parser
3. Teach the parser how to read your email
4. Automatically forward emails to the parser
5. Put your parsed email data to work
Make a New Email Parser
The first step is the easiest. Just go to parser.zapier.com, sign in with your Zapier account or make a new account, then click the Create Mailbox button to add a new email parser.
Email Parser will then show you an email address like 1asdfe2fg@robot.zapier.com
. Copy that address.
2. Forward an Email to the Parser
Now, send the first email to be parsed. Open your email app, find an email like the ones you want to use with your email parser. I'm going to have Email Parser notify me about new App Store purchases—so I got an App Store email.
Click the button to forward the email, put your @robot.zapier.com
email address in the To: field, and click Send.
3. Teach the Parser How to Read Your Email
Time to put on your teacher hat. Once Zapier Email Parser receives your email, it shows a text version of your email in the Initial Template box. All you need to do is find the important data and tell the parser that this is what to copy.
Scroll down to the text that you want the Email Parser to copy, and select it. With my App Store emails, I want to know what I purchased, so I select the text of the product name. Type a name for that item in the box, click Save, and the Email Parser will replace the text with the name in curly brackets, like .
Repeat that for everything else you want the email parser to copy. I selected the total price, too, and gave it a name.
Once that's done, click the blue Save Address and Template button at the bottom—and your email parser is ready to work.
The email parser will work best if the text you select is something written the same way in every email—perhaps a number after the word Total, or a link written after the word Click here. The value can change, but the email parser will work best if that preceding text is the same and in the same place every time.
Want to make your Email Parser more reliable? Forward another similar email to the same address, then click the View Emails beside your parser's name in Zapier Email Parser's Mailboxes list. That shows your most recent emails—with the text Email Parser selected in yellow.
If that's incorrect, click the Edit extra template link near the bottom. Select the same text you'd originally wanted to copy from your emails, give it the same names, then save this new template. You can repeat that multiple times to make your parser more reliable.
4. Automatically Forward New Emails to the Parser
The Email Parser you made is now ready to copy text from other similar emails—App Store receipts, in this case. We need to send every new App Store receipt to the email parser.
The best option is to automate things with a filter in your email app to automatically forward messages that match the one you sent to Email Parser. Typically, your notification emails will all have something in common—they come from the same sender and often have the same subject. App Store receipts, for instance, come from no_reply@email.apple.com
and have the same Your receipt from Apple
subject.
To watch for those emails in Gmail, you'll first need to add your email parser address to Gmail to automatically forward emails. Here's how:
- Open your Gmail Forwarding settings—click the gear icon, select Settings, then click the Forwarding tab.
- Click the Add a forwarding address button there.
- Enter your Email Parser
@robot.zapier.com
email in the text box and click next. - Check your email—Zapier should send you a confirmation email from Gmail. If you don't see it, check the Email Parser app's mailbox—it should have the email. Either way, copy the confirmation code, then paste it in the box back in your Gmail Forwarding settings.
Now you can have Gmail automatically forward emails to your email parser. First search for the email address and/or subject of the messages you'll have the email parser process; I'll enter from:no_reply@email.apple.com AND subject:"Your receipt from Apple"
. Click the tiny down arrow on the right of the search bar to see the full Advanced Search options—then click the Create filter button or link in the lower right corner. Have that filter forward the email to the email parser address you just added—and you should be all set.
After a bit of mouse and keyboard exercise, you're done. Every time Apple sends you an App Store receipt—or whenever you receive whatever other email messages you want to parse—Gmail will send it along to the Email Parser.
If you use another email service, check your documentation to see if your app or service can automatically forward email messages.
5. Put Your Parsed Email Data to Work
Copying text out of emails alone isn't enough—you need to do something with that data. The easiest option is to connect your Email Parser to Zapier's app automations, which lets you send data from your emails to 1,300+ other popular work apps—from Airtable to Zoho.
Visit Zapier and log in or sign up if you haven't already. Then click the orange Make a Zap button in the top right corner. Select Email Parser as the trigger app, then choose the New Email trigger. Connect your Email Parser account if you haven't already, and pick the parser address you just set up.
You can then put your email data to work. In the Action step, select the app you want to send your email data to. I wanted to get an SMS notification about my App Store receipts, so I picked the SMS app's Send SMS action.
To use your email data, click the +
button beside any of the fields from your app. Here, I've added the purchase name and price from Email Parser to the SMS notifications—you could perhaps add names and emails to your email newsletter, log sales info to rows of a spreadsheet, or use your email data however you want.
Test the Zap to make sure everything works the way you want, turn it on, and you're done!
Now, whenever an email comes in with details you need to save, your email app will forward it to Email Parser, which will skim your email and copy out the important info, then send it to Zapier, which then sends it to the app that needs your data. It's the most productive Rube Goldberg machine yet.
The Best Email Parser Apps
Zapier's Email Parser isn't the only way to copy text out of your emails. It's a great tool, and one of the easiest to setup and use. But it's only designed to parse text from your emails, and may fail at copying text if your email formatting changes much.
Need more power for your email parsing? There are a handful of other tools that can do similar things, watching for new emails and parsing out the text you want—often with even more features for those most difficult emails.
Here are the best apps to parse your emails:
mailparser.io
to automatically find data to parse
mailparser.io makes it much faster to start parsing emails—and much more precise. Start the same as you would with Zapier's Email Parser: Make a new inbox, copy its unique mailparser email address, and forward your emails to it. This time, forward several similar emails to start.
As soon as the emails come in, mailparser.io will try to figure out the common patterns in your messages—names, dates, prices, order numbers, and more. It shows them in a table automatically, and if everything looks good, you can turn on the email parser and let it run without changing anything for one-step email parsing.
Odds are, though, you'll want to customize and extract the specific things you want from your messages. Open the Parsing Rules tab in mailparser.io, then select any of the pre-made rules—or add a new one. There, you can have mailparser.io filter out ordinary text like links and blank lines, then tell it precisely what to watch for before and after the parsed text. It can count a specific number of characters, find the next blank space or line, or look for an exact text string.
It can also parse other things in your email. Need to copy all entries of a table—even when sometimes there will be more entries than others? Add an Extract Tabular Data text filter, and mailparser.io can copy the full table or XML content for you. It can even copy text from PDF or text attachments on your emails.
- mailparser.io Pricing: from $29/month Professional plan to parse 500 emails per month in up to 30 inboxes
- Connect your parsed emails to other apps with Zapier's mailparser.io integrations.
- For a deeper look at mailparser.io's features and pricing, check out our mailparser.io review.
Tip: Need to automatically extract data from PDF files? mailparser.io's sister app, docparser, uses the same tech to help copy important info from your PDFs. Check our docparser review for more info.
Parseur
to copy text from HTML and rich-text emails
Both Zapier's Mail Parser and mailparser.io turn your emails into plain text—you get the core details from your emails, without the images and formatting. That works—and mailparser.io lets you make advanced filters to dig deeper into HTML formatting—but it can be difficult to use.
Parseur simplifies things with an HTML parser that shows your messages exactly the way they look in your email inbox. Set up an email parser the same way—add an inbox, copy the address, forward an email—then you can make a new template in Parseur. Click on the text you want Parseur to copy, add a name for the field on the right sidebar and click Create, then repeat for everything else you want to select. It's easy to quickly pick out what you need to copy with the standard, rich-text email view.
Then, you can use Parseur as an email inbox with an archive of your parsed emails. Click through the Documents tab to see every email that Parseur received—and open them to see the original email along with a table of the copied text.
If Parseur can't figure out what to do with an email, it'll show it highlighted in red on your Documents list. Open the email and click the +
icon in the right corner to add a new template, and Parseur will then parse that email and use the extra template as a backup next time.
- Parseur Pricing: from 49€/mo (~$56 USD) Starter plan to parse 1,000 emails/month
- Build email parsing workflows with Zapier's Parseur integrations.
- For a deeper look at Parseur's features and pricing, check out our Parseur review.
Bonus: Parse Email Messages with Regex and Zapier Formatter
Only want to copy phone numbers, links, email addresses, and other easily recognizable text from email messages? You don't even need an email parser. All you need is a regex—or Regular Expression—script that can find text that matches the pattern you need.
With a regex script, you could search through your email text inside a text editor like Sublime Text and copy out the items you want in seconds. Or, using Zapier's Formatter tool, you could have Zapier watch Gmail for a new email, use Formatter to find, say, a link or phone number in the text, and then add another action app to your Zap that puts your text to work.
Another option: You could use this Gmail Parsing Google Script from ctrlq.org to use regex scripts right inside Gmail that find data in your emails and copy it to a Google Sheet.
Here's how in our in-depth guide on how to extract text with regex and Zapier Formatter.
Put Your Parsed Emails to Work with Automations
You've learned how to parse emails and found the perfect app for the emails you need to parse. All that's left is to start using that parsed text in your work. Just as in the example above, you can connect your email parser to Zapier, then automatically send every parsed email to your CRM, eCommerce tool, project management app, and more.
Here are some of the most popular ways to use parsed email data with Zapier:
Save Your Parsed Email Data to a Spreadsheet
One of the easiest ways to use your email data is to save it to a spreadsheet. There, you can sort and filter the data or easily import it into another app. Zapier can save your email data to a Google Sheets or Excel spreadsheet—or a database—automatically for a list of everything you need in one place.
Get Notified About Parsed Emails
Want to get an SMS with the simpler details from your parsed emails? Or perhaps you'd rather get another email with just the important text or notify your team in Slack. Either way, you can do this automatically.
Add New Subscribers to an Email List
You could automatically copy email addresses of people who contact your company and add them to an email list, but you'd miss out on lots of important data. An email parser can help fill in the blanks, copying all their contact info before adding them as new subscribers.
Create CRM Contacts and Leads from Emails
Whether you're parsing messages from your contact forms or order receipts from an eCommerce store, save your email data to a CRM to keep as many details on your contacts and customers as possible.
Start Projects and Tasks with Parsed Emails
Don't let work pile up in your inbox. Parse the emails, and let Zapier turn those messages into tasks and projects you'll complete.
Email's the default way for most apps to send notifications and other info—and can be the best way to automate apps that don't have their integrations. With an email parser and Zapier workflows, your inbox can get your most important emails working for you as soon as they come in—no more copying and pasting from your inbox.
Want to make your inbox even more productive? Here are some great Zapier guides to help:
- Learn how to get to Inbox Zero and manage your email.
- Using Gmail? Check out our guide to 30 of the best Gmail tips, tricks, hacks, and add-ons.
- Or, perhaps you need a new email app. Here are 15 of the best email apps, from dozens we've tested as a team.
Image Credits: Ocean background photo by Dimitris Vetsikas via Pixabay
from The Zapier Blog https://ift.tt/2kCw68O
- Get link
- X
- Other Apps
Comments
Post a Comment