How to parse email into spreadsheet rows: five steps with an email parser

Parsing an email means mailbox, samples, fields, test, export

To parse email, you send a copy of each message to a parser mailbox, show the parser which pieces of text are fields, test it on a few more messages, and connect an export so every new email becomes a row. Those five steps are the same in every tool. The steps below follow Parsio's help center, with notes where Email Parser by Zapier works the same way. They come from the vendors' documentation, not from hands-on use.

What you need first: access to the mailbox settings where the emails arrive, five to ten real examples of the email you want to parse, and a list of the fields you want. Parsio's free plan includes 30 credits a month, which is enough to try this. Its paid Starter plan was $29 a month for 100 credits on monthly billing as read on 3 October 2026.

Step by step: how to use an email parser

1. Create a mailbox for one email type. Parsio's tips page recommends a separate mailbox for each kind of email, for example one for marketplace orders and another for contact-form leads, so fields do not mix on export. Each mailbox gets its own address ending in io.parsio.io. Zapier's parser gives you an address ending in robot.zapier.com.
2. Send sample emails. Forward a few real messages to the mailbox address, or import existing ones. Parsio can import past mail from Outlook, Gmail, iCloud, Yahoo or any IMAP server.
3. Define the fields. With a template parser, you highlight each value in a sample and name it. With Parsio's GPT-powered parser, you list the fields you want in plain language instead. Write the list down first as a field contract so names and formats stay stable.
4. Test on more samples. Send the remaining examples and check every field in the parsed data. Parsio's help center says a mailbox usually needs only one to three templates. Add a second template when a layout variant fails.
5. Turn on forwarding and export. Set an automatic forwarding rule in your mail provider for just the emails you want parsed, then connect the export: a CSV, Excel or JSON download, Google Sheets, a webhook, or Zapier, Make, n8n or Pabbly Connect.

Which parser engine to pick for the email you have

The template parser is the cheapest but, by Parsio's own description, it has no OCR and cannot extract tables from PDF files. If the data you need is in an attachment, read how to extract data from a PDF before choosing.

A worked example: contact-form leads into Google Sheets

A plumbing company gets about 90 website inquiry emails a month, all generated by the same form. It wants name, phone, ZIP code and job description in a Google Sheet.

• One Parsio mailbox named for web leads, using the template-based parser.
• Six past inquiries forwarded as samples. The four fields are highlighted in the first one.
• The other five are checked. Suppose one has a two-line job description that comes back cut short: a second template is added for it.
• A mail filter forwards only messages from the form's sender address.
• The Google Sheets export is switched on.

At 1 credit per email, 90 emails fit inside the 100-credit Starter plan. If the company only received 25 a month, the free plan's 30 credits would cover it.

The mistake to avoid: emails that do not match your samples

The mistake to avoid is feeding the parser emails that do not look like the samples. Two habits cause it. The first is forwarding the whole inbox, which Parsio's documentation specifically advises against. The second is building the template from a manually forwarded message. Zapier's help page warns that forwarded mail can carry extra threads, signatures and indentation. Create templates from messages that arrived through the same automatic rule you will use in production.

One more thing to watch: when credits run out, Parsio keeps receiving mail but stops parsing until the next billing period, so check usage after the first month. If your emails come from Gmail or Outlook, the provider-specific forwarding steps are on the Gmail parser page and its Outlook counterpart.