Here’s an explanation on how to use cloudHQ wizard for exporting emails to Google Sheets:

  1. Go to cloudHQ dashboard. Click on Emails to Google Sheets icon:
  2. Click on Start Wizard for Export Email to Sheets button:
  3. The following wizard is opened: Export Emails to Google Sheets: What do you want to do?
  4. Alternatively, the wizard can also be opened from Gmail clicking on the icon “Start Export Google Sheets Wizard”:

Backup email messages from a Gmail label

This wizard will help you set up a continuous backup of all your emails of a Gmail label and save them in your Google Sheets. All of your attachments will also be saved as a PDF Google Drive link in your Google Sheet. This is an excellent solution for small businesses so you can:

  • Archive project-related emails.
  • Delegate responsibility handling emails with your team by saving emails from your Gmail label to a spreadsheet, and then share the spreadsheet with whoever needs access.
  • For managers to share emails with their assistants or team.
  • etc…

Automatically find all bounced email messages and parse them

This will automatically find all bounced email messages that did not get delivered, and will identify the following information from those bounced emails:

  • Email address
  • Reason why the email bounced, as reported by the server

The export will be continuously running and as soon as an email message is bounced it will be added to your spreadsheet.

Parse Google Alerts

This is an excellent solution for small businesses or individuals to monitor the web for mentions of your company, your name, or your competitors. To set up Google Alert, please read our support page here.

Extract any information from within the body of your email messages

You can set up automated email information extraction workflows using this powerful email parser. The information you extract will be delivered in a Google Sheet in your own Google Drive account. It populates the information from your emails in the sheet in real-time, as you receive emails. It will also go through all your past emails and include those that fit the rules that you define. Here are some examples of the kind of information you might want to capture from your emails and populate into a Google Sheet:

  • Order and shipping notifications
  • Email confirmations
  • Email lead information from forms or from multiple forms
  • Messages and contact information from people who leave messages on your website live chat service
  • Customer service or client replies to support tickets
  • Travel service request emails
  • Lead page consolidation
  • Automatically generated reports like job reports, contractor invoices, project milestones, etc.

incoming Gmail emails that match a label to Google Sheets as new rows