cloudHQ’s multifunctional Chrome extension, Export Emails to Google Sheets, Excel, or CSV, creates several different kinds of spreadsheets from your Gmail data. Useful for businesses, professionals, freelancers, salespeople, project managers, teams, investors, job-seekers, and just about anyone else, the extension offers a suite of six wizards, with each wizard creating a unique type of spreadsheet. The wizards, and their standard uses, are as follows:

  • Wizard 1: Back up emails from a Gmail label
    • Create and maintain shareable, up-to-date status reports for business projects
    • Back up email communications from particular contacts
  • Wizard 2: Extract custom information from the bodies of your emails
    • Create automatically-updating spreadsheets of sales and order information
    • KPI tracking: order processing time, sales
  • Wizard 3: Parse your Google Alerts
    • Monitor your (and your company’s) online presence and reputation
    • Stay on top of the stock market
    • Enhance your job search
  • Wizard 4: Create an email list of all the contacts you’ve ever communicated with
    • Grow your mailing list
  • Wizard 5: Track your outreach email campaigns and measure your lead generation
    • Analyze your sales and outreach efforts
  • Wizard 6: Identify the addresses for every bounced email you’ve sent
    • Refine your mailing list

Below, we offer a quick look at each of the six tools that make up Export Emails to Google Sheets, Excel, or CSV.

Wizard 1: Back up emails from a Gmail label

Wizard 1 allows users to populate a custom spreadsheet with information parsed from all emails in a single Gmail label. It also backs up all of the emails in that label as PDFs in a folder in your Google Drive.

This is excellent for project managers and team members who use a shared Gmail label for their documents; team leads who want to delegate responsibility; teams keeping an ongoing progress report; and anyone who wants to keep organized records of their email communications from particular contacts or groups.

Project Management — create a new gmail labelProject Management — Spreadsheet

For a step-by-step guide to using this extension, please click here.

Wizard 2: Extract custom information from the bodies of your emails

Wizard 2 allows users to populate a spreadsheet with custom information that they specify.

As an example, a user who wants an organized record of their company’s sales will specify pre-set or custom parsing rules for Wizard 2’s email parser. Then, the parser will extract the relevant information—like order number, price, product, order date, shipment date, etc. Emails that include this information may be: order and shipping notifications; email confirmations; notifications from your website’s live chat service; client replies to support tickets; and more. 

Excellent for tracking costs, monitoring order processing time, tracking sales, and sharing metrics with a team.

For a step-by-step guide to using this extension, please click here.

3. Parse your Google Alerts

A simple, free tool that helps you monitor search terms online, Google Alerts has become an indispensable resource for many businesses that rely on its daily, weekly, or real-time notifications.

The tool makes it easy to stay current on press mentions, competitor activity, stocks, industry developments, influencers/trends, or anything else you’re interested in. And while it’s highly effective as a method for staying in-the-know, there’s one problem: Google Alerts functions through individual email notifications, only showing you one alert at a time.

That means that aggregated data about your search terms is not immediately available, and there’s no keeping track of your terms broadly, viewing SEO history over weeks, months, or years. Indeed, this makes it difficult to know exactly how to use Google Alerts effectively, beyond just interacting with the notifications as they come in.

  • Google Alert keyword search term
  • Publisher of the content (e.g. Wall Street Journal, Washington Post)
  • Brief summary of the content
  • A URL of the content
  • A link to share the news on Facebook and Twitter
  • A way to flag the Google Alert as irrelevant (to Google)
  • An area for you to include any personal notes
  • Total number of alerts per keyword
  • Total list of publishers who mentioned each keyword
  • 1. Keep track of your name: online reputation management

    If you speak publicly, create podcasts, write blogs, or do anything openly that draws attention to your expertise—heck, if you tweet—you’ll want to set up Google Alerts for your name to monitor what’s being said. If it’s positive, you can share it or even comment on it. And if it’s negative, you put the fire out early with an immediate response. Don’t know what’s being said about you? That’s a bad position to be in. You’re setting yourself up to be reactive. When job hunting or applying for new public-facing opportunities, your online reputation follows you. Fortunately, when you proactively monitor your name, you can manage how the media sees you, even flooding out negative press with positive material that you can write or broadcast yourself.

    *Pro tip: In order to flood negative press and/or keep yourself relevant, offer to interview a friend; ask to be a guest on someone’s podcast; or launch a new video on your Youtube or Twitch channel. The funny thing with press is that you actually can control so much of it, especially when you understand and take advantage of market trends.

    2. Keep track of your company’s media mentions

    The first and most intuitive answer for how to use Google Alerts is, of course, self-tracking. Company media mentions are a must with this Google tool. But Export Emails to Google Sheets takes you a crucial step further. With your alerts compiled into one document, you’ll be able to easily track the timing for those mentions. How many came in right after you rolled out the big ad campaign? How many did you receive during the summer season for the past three years? During winter? Do you have multiple media mentions from the same source? Once your data is aggregated, you can study your trends.

    3. Keep track of your competitors

    Another popular idea for how to use Google Alerts is tracking your competition. It’s essential to be aware of what similar businesses in your industry are up to at any given moment. But occasional, or even regular, updates about competitors won’t do the trick. You need a structured, systematized view of your competitors’ online presence. That’s why exporting your alerts to a Google Sheet is so powerful. Don’t waste precious time on the small stuff, searching endlessly for all of the alerts you’ve received. Let us collect that info for you—then you can focus on the analysis and the big decisions.

    4. Google Alerts for jobs and market trends

    One highly effective way to grow and refine your online presence requires understanding your industry so well that you can take advantage of market trends. No matter the field—law, real estate, finance, etc.—setting up Google Alerts helps you understand what new changes are taking root. To ensure your public position as an expert, pen a guest post on an industry website sharing your thoughts on the subject. Of course, snagging that top expert positioning can take a lot of time and energy, especially as you figure out what to write about. Speed things up with your spreadsheet. Create an alert for “guest post” with an industry-specifier included (e.g., “small business tax accountant guest post,” “mls.com realtor guest post,” “immigration law guest post,” etc.). You’ll see the websites that have been contracting people and businesses like you. After our email parser compiles a list of those websites into a document, you’ll have the information ready at hand. Go through your list and start reaching out. When you find your match and land the writing spot, your reputation will grow dramatically.

    5. Google Alerts for Stocks / Google Alerts for Real Estate

    Have you tried setting up a Google Alert for “Stocks,” or even a specific stock you own shares of? Say hello to a regular roundup of the latest financial news, delivered in real time. One of the biggest problems investors face is the difficulty of seeing all the media attention a ticker symbol has received over time. With Google Alerts organized into a spreadsheet, you’ll be able to track the media about that stock over time so you can make better-informed decisions. And this goes for anything else, too: real estate opportunities, musical acts, podcasters, and authors. You can even keep track of people who you might want to hire some day. Keep an organized record!

For a step-by-step guide to using this extension, please click here.

4. Create an email list of all the contacts you’ve ever communicated with

A full email list builder has unlimited uses for small businesses. Among the first benefits are:

  1. Owning your email contact data
  2. Monitoring sales interactions with customers, or procurement interactions with suppliers
  3. Enhancing marketing effectiveness with email merge tags for email campaigns like: first name, company, job title, etc.
  1. Email Address
  2. First Name
  3. Last Name
  4. Full Name
  5. Bio
  6. Location
  7. Personal Website
  8. Last Sent Email Date (Last email sent to the contact)
  9. Last Sent Email (A link to the actual email you sent)
  10. Total Number of Emails Sent
  11. Awaiting for Reply? (Awaiting reply from the contact)
  12. Last Received Email Date (Last email received from the contact)
  13. Last Received Email (A link to the actual email you received)
  14. Total Number of Emails Received
  15. Not Replied? (Not replied to the contact)
  16. Company Name
  17. Role at Company
  18. Company Website
  19. LinkedIn Profile
  20. Facebook Profile
  21. Twitter Profile

For a step-by-step guide to using this extension, please click here.

5. Track your outreach email campaigns and measure your lead generation

For a step-by-step guide to using this extension, please click here.

6. Identify the addresses for every bounced email you’ve sent

Nothing is worse than a bounced email. All that work crafting your email message, and now what do you see? A delivery error notice. Email address is invalid! Recipient server has blocked delivery! User mailbox is full! The reasons are many, but one thing is for sure: bounced emails degrade the quality of your email list, threaten your deliverability, and risk that your future emails get flagged and thrown into Promotions boxes, Spam folders, or your entire domain will just get block listed. Clearly, then, getting rid of bounced emails is essential to reaching inboxes—and equally essential for saving energy, time, and money. Thankfully, our Chrome extension, Export Emails to Google Sheets, includes an Email Bounce Checker which automatically creates a spreadsheet for you neatly organizing every bounced email you’ve ever encountered.

3 Undeniable Reasons to Get Rid of Bounced Emails

Let’s look at three big reasons why tracking and getting rid of bounced emails will up your marketing effectiveness:

1. Sender Reputation Deliverability

Don’t let a bad sender reputation get in the way of your company’s mission. Trim the fat and keep your deliverability high so that you can land directly in your audience’s inboxes. If you’re not careful, you run a big risk of becoming block listed or flagged as a sender that regularly spams people.

2. You Can Easily Get Block Listed

What happens if you don’t remove invalid email addresses from your email list? You’ll keep sending emails to those addresses; then, you’ll be block listed. Once on a block list, your emails will be blocked by servers; your email marketing efforts will be for nothing; and your domain will downgrade in reputation. There are 7 international organizations—two of the most well-known being Spamhaus and SpamCop—who actively identify block list candidates. Once you’re on one block list, you’re likely to end up on all seven. Removing yourself from a block list is a very long process, and you’ll need to work that same process for each of the seven organizations. The easiest way to avoid the process is to never get block listed at all, of course. And using Export Emails to Google Sheets is the easiest way to find all of your bounced emails so that you can search for them in your email list and delete them forever.

3. Google Can Disable Your Account

Once Google disables your account, it’s not just your email address that they disable. In fact, it’s your entire domain—and often your IP address, too. That means that, if you have a website, you can count on it being disabled. Unfortunately, if you think it’s as easy as starting a new one from scratch, well…it’s not. You’ll need to buy a VPN in order to change your IP to a fresh one. Even then, it’ll only maybe work. After all, Google has some very intelligent algorithms in place to automate this entire process.

For a step-by-step guide to using this extension, please click here.

How to download Export to Google Sheets, Excel, or CSV

Follow these steps to download the extension:

  1. Install the extension here by clicking Add to Chrome:
    chrome extension
  2. Add the extension to Chrome:
    chrome extension
  3. Once installed, you will be forwarded to your Gmail. Note the Export Emails to Excel, CSV, or Google Sheets icon. You will also see a modal dialog box asking you to create an account. Click on Create Account:
    chrome extension
  4. After the account is created, you can save your email messages to Google Sheets, Excel, or CSV.
    • Export entire labels to Google Sheets, Excel, or CSV. More instructions on how to do that are here.
    • Export only selected emails to Google Sheets, Excel, or CSV. More instructions on how to do that are here.

And here some how-to examples:

    1. How to automatically find all bounced email messages and parse them (‘Delivery Status Notification’, ‘failure notice’, etc.)
    2. How to parse tables in email messages
    3. How to parse AWS Notification Messages (in json format)
    4. How to parse Amazon orders
    5. How to parse Paypal invoices and receipts
    6. How to parse responses (like from Shopify hulkapps)
    7. How to parse responses from five9
    8. How to parse responses from Olark
    9. How to parse responses from jivochat
    10. How to parse orders from Squarespace
    11. How to parse reports from Gmass
    12. How to parse Shopify online store’s contact forms
    13. How to parse Wuffo

contact forms