How to Use Email Parsing for Small Businesses

cloudHQ’s Emails to Sheets extension enables small businesses across industries to export and parse email messages to Google sheets with just one click.

Users worldwide rely on this extension to back up their Gmail label emails to a Google spreadsheet, parse emails and export critical data from attachments or message bodies, export contact information to build an email list, and detect bounced email addresses as they run their business on platforms like Adobe Magento, Etsy, Walmart, and Zillow.

Let’s find out how email parsing works for small businesses in these marketplaces.

How to Parse Adobe Magento Emails Confirming Purchase to a Google Spreadsheet

With cloudHQ’s Emails to Sheets extension, you can convert your Magento emails confirming customer purchases to Google sheets and upload them to a spreadsheet in real time.

Here’s how to do it.

1. Log in to your Gmail account and go to “All Mail.”
2. Create a Gmail label of emails with the subject “Marketplace Purchase Complete” using a filter: from:(marketplace-info@magento.com) subject:(Marketplace Purchase Complete).
3. Tick two options before hitting “Create Filter”: “Apply the label: Marketplace Purchase Completions” and “Also apply filter to matching conversations.” This will ensure that all future emails with this subject line automatically add to the Magento purchase completions label.
4. Click here to start the Export Emails to Sheets wizard.
5. Select “Extract information from the body of your email messages.”
6. Tap on the Gmail label “Magento purchase completions.”
7. Confirm the correct parsing of the emails by clicking “Add or Edit Parsing Rules.”
8. Start exporting.

How to Parse Etsy Emails for Order Confirmation to a Google Spreadsheet

Follow the steps below to parse all existing Etsy order confirmations and set up future automatic export of your emails to a Google sheet.

1. Create a Gmail filter like from:(transaction@etsy.com) subject:(Etsy Order confirmation) to ensure all emails with the subject “Etsy order confirmations” are added to one label.
2. Apply this filter to all the emails in your inbox and enable the option that automatically adds new messages to the selected label.
3. Go here to set up the exporting job with the Export Emails to Sheets wizard.
4. Choose to export information from the body of the emails in the Gmail label “Gmail label Etsy order confirmations.”
5. Tap “Add or Edit Parsing Rules” to confirm the correct parsing of the emails.
6. Start exporting.

How to Parse Walmart Emails to a Google Spreadsheet

Follow the steps below to parse and convert Walmart order confirmations into a Google Spreadsheet in real-time.

1. Create a Gmail label for Walmart emails titled “Order received.” The filter should be like this: from:walmart.com subject:”order received.”
2. After applying this filter to all existing messages, request new emails to be automatically added to the label.
3. Start the Export Emails to Sheets wizard.
4. Click the option “Extract information from the body of your email messages.”
5. Choose the order confirmations label.Request to “Add or Edit Parsing Rules” to verify that your emails are correctly parsed.
6. Start exporting.

How to Parse Zillow Emails to a Google Spreadsheet

Follow the steps below to set up real-time parsing of Zillow search notifications in your inbox.

1. Create a Zillow search notifications label in your Gmail.
2. Apply the filter (from:(instant-updates@mail.zillow.com)) to all emails and enable the automatic transfer of messages to the Zillow search notifications label.
3. Click here to use the Export Emails to Sheets extension.
4. Select the option that allows extraction of information from the email body of messages in the Gmail label “Zillow search notifications.”
5. Click “Add or Edit Parsing Rules” to verify the parsing of your emails.
6. Start exporting.

Final Words

cloudHQ’s Export Emails to Sheets extension is a useful tool for small business owners who regularly receive emails from Etsy, Adobe Magento, Zillow, and Walmart regarding customer purchases and order notifications.

The continuous export function lets you put email parsing on auto-pilot so you can focus on other important business matters.

Want to learn more about cloudHQ’s Emails to Sheets extension?

Click here.