NOTE:
To find out more about Export Emails to Google Sheets by cloudHQ, click here.
To install Export Emails to Google Sheets, click here.
To start wizard to export emails to Google Sheets, click here.

Adobe Magento Comerce is the leading platform for open commerce innovation. Every year, Magento handles over $100 billion in gross merchandise volume.

Export Emails to Sheets by cloudHQ can parse and convert purchase confirmation from your Magento email messages and upload them into your Google Spreadsheet – in real-time.

In the example here, we will automatically extract all information from the email messages about Magento purchase (emails with the subject “Marketplace Purchase Complete”).

Here are step-by-step instructions on how to do that.

Step 1: Create a Gmail label and filter with all Magento purchase completions

  1. Create a Gmail label called Magento purchase completions
  2. Create a Gmail filter like this:
    from:(marketplace-info@magento.com) subject:(Marketplace Purchase Complete) 
    

  3. Apply this filter to all existing messages. Also set that new email messages are automatically added to the Magento purchase completions label.
  4. Step 2: Set up export job for the label Magento purchase completions

    1. Start Export Emails to Sheets wizard by going here
    2. Select option Extract information from the body of your email messages
    3. Select the Gmail label Magento purchase completions
    4. Click on Add or Edit Parsing Rules to verify that all email messages are correctly parsed
    5. Verify that email messages are correctly parsed by clicking on Add or edit parsing rules.
    6. Start the export job

    Export Magento order confirmations to sheets; Parse Magento emails; Support for Magento; integration; Magento: eCommerce Platforms