No Credit Card Required

How do I Convert Email to Google Sheets?

A couple of weeks ago we covered in detail how you can transfer email data to Excel Files. This time, we’ll dive into how you can automatically parse and convert email to google sheets. I’m sure you can imagine how much time and money automating this workflow can save. That’s why doing this is so popular!

Step 1: Create an Inbox

You will need to login to Mailparser to do this, but it’s totally free to create an account, and you do not need a credit card. Once you create your account we’ll actually create your inbox for you. You just need to click the “Create an inbox” button so we know you’re a real human, and not spammers taking advantage of our free service.
This takes about 20 seconds. It’s super easy! Create Your free Account
(No credit card or payment required)

Step 2: Send a Couple Test Emails

Once you create your inbox, we’ll give you an email address that you can forward your emails to. Like anything, it’s best to test a couple of emails first. Don’t worry, it’s easy. Literally, just forward one or two emails to the email address we give you.

Step 3: Setup Your Rules

Use the test emails to make sure the correct data in your emails are being collected and stored in Google Sheets the right way.

Step 4: Connect to Google Sheets

Once your email parser is set up and new incoming emails are automatically forwarded to your inbox, it’s time to add the integration with Google. This is an easy step thanks to the native Google Sheets Integration offered by Mailparser. All you need to do is to create a new “Webhook Dispatcher” and select “Google Spreadsheet Integration”. Once you connected your Google Account you’ll need to select the Worksheet to which you want to populate your email data. Connect Your Email to Google Sheets

Step 5: Organize Your Google Sheets for Your Data

The final step is to make sure your Mailparser data fields go to the right columns in your Google Sheet. Mailparser will show you all column headers of the selected Google Spreadsheet and you just need to define which parsed field should go to which column. That’s it, you are ready to go! *Note – The columns in the Google Spreadsheet you are mapping your data to should only be simple headers, (only letters and numbers). For Example ID, Date, Customer Name, as seen below are good. (Characters like . – _ , * etc… For Example, these symbols in addition to text will not work: ID. Date- Customer_Name) Organize Your Email Data into Google Sheets How To Convert Email To Google Sheets

Watch a video on how to convert email to Google Sheets

Why would you want to import data from email to Google Sheets anyway?

Let’s have a look at some common use-cases for an email to Google Sheets automation: Copy Email Leads to Google Sheets A use-case we see quite often is to parse leads (contact details of prospects) from incoming emails and add them to an auto-updating Google Sheet. Once the leads are in Google Sheets you can then add a status and additional info. So basically you create your own custom CRM and Sales Pipeline based on email data to google sheets integration. Parse Order and Shipping Notifications from email to Google Sheets Order fulfillment is another hot topic when it comes to parsing data from email to Google Sheets. As an e-commerce shop owner or drop shipping fulfillment partner, you receive probably hundreds of orders and shipping notifications each day, and keeping track quickly gets difficult. So why not just parse all this useful data (Date, Reference-ID, line-items, totals, …) stored inside those notifications and automatically populate a Google Docs Spreadsheet with it. Looks like you can actually build a little custom ERP, warehouse, and shipping solution based on email parsing. Copy data from email attachments to Google Sheets We should probably mention that Mailparser can not just extract data fields from the email body text. With Mailparser you can also extract data fields from email attachments such as PDF, DOC, DOCX, XLS or CSV files. The possibility to process email attachments is really useful for a lot of use-cases. You can for example automate your order fulfillment process (see above) by parsing line-items from attached PDF invoices.

Bonus Info:

Add rows to Google Sheet from CSV and Excel File Attachments Another great way of using our Google Docs integration is to automatically add rows to a Google Spreadsheet from email. This works by extracting rows from email file attachments and then moving them to Google Docs. Just create a parsing rule which will extract all rows from an attached spreadsheet and Mailparser can then send all rows over to your Google Spreadsheet. Once set up, you have a fully automated workflow. Well, that’s it for now! We hope this article was helpful and showed you how easy it is to save data from inbound emails to Google Spreadsheets. Please leave a comment if there are any questions or contact us at support [at] We are already looking forward to hearing from you! And if you haven’t already done so, create a free account and begin automating your workflows!

Test our email parser

Save hours of time extracting data from emails.
(No credit card or money required)

Takes 2 minutes to set up.

14 Responses

  1. Hi,
    Loving the functionality!
    Is it possible to upload data to a Google Sheet and overwrite the data that is in the sheet…
    Not just adding rows to the Google Sheet.

    1. Hi Steven! Unfortunately we only support insertion of new rows for the moment. Updating rows is something we want to implement in the future and I’ll make sure to let you know once we are ready. In the meantime you might get lucky by putting Zapier in the middle and use the Zapier Google Sheets Integration.

  2. I am absolutely fascinated by the idea. My team receives emails with offers including some pictures and items being offered in attached spreadsheets. Could all of this content be loaded into excel or google sheets?

  3. Have you guys added the ability to “update” yet? Im trying to pull data from a QB Desktop report and stick it into smartsheets.

  4. For replacing data in a google sheet, you can use the importdata function in sheets and use the URL from the file downloads portion on the inbox. I use this to take marketo analytics data into sheets, pivot it, and output it to our company dashboarding tools.

  5. Is this possible to do something similar but with gmail ? I am trying to have supply orders feed into google sheets as we are not allowed to use forms.

Leave a Reply

Your email address will not be published. Required fields are marked *

Hi there, I’m Joshua.
I oversee product development at Mailparser. This includes working with customers and overseeing new feature implementation.

Try Mailparser for free!
Save hours of time!

No credit card required.