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!
(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 @mailparser.io 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.
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)
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] mailparser.io. 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!
Tags: google sheets, integrations
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.
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.
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?
Hi Gregory, our app generally was not built to extract pictures inside of Excel spreadsheets, sorry! If you have any questions please feel free to submit a ticket to support@mailparser.io.
Have you guys added the ability to “update” yet? Im trying to pull data from a QB Desktop report and stick it into smartsheets.
Thank you for sharing with video. Such informative article.
Hi Nick,
While we do not have a native Smartsheets integration, if you have a Zapier account you can send parsed data there which can update existing rows in Smartsheets: https://zapier.com/apps/mailparser/integrations/smartsheet
If you have any questions please feel free to send an email to support@mailparser.io :)
That was a really helpful article. Thanks!
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.
Really Great Post ! thanks for sharing informative article.
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.
Hi Anthony,
Thanks for reaching out! I can confirm you can set up automatic forwarding in Gmail so the emails you need can come to Docparser:
https://support.mailparser.io/article/215-how-to-forward-emails-automatically-from-gmail
If you have any questions or run into trouble getting set up please reach out to us at support@mailparser.io :)
Thanks for sharing informative article
Thank you for these details, it is very interesting