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, 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.
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!