Export Emails to Google Sheets: Continuous saving of email messages

By default, any new email message matching the label or the search filter will be automatically exported and saved into your Google spreadsheet.

The continuous job can be paused or aborted via dashboard:

automatically save emails

Why did my export stop adding rows?

Start by looking at the Export Emails to Sheets dashboard. A paused job shows a status that explains the reason. Here are the usual ones:

  1. Your Google account was disconnected or lost authorization. A Google password change can cause this. cloudHQ pauses the job and sends you an email with the subject “IMPORTANT: Export of emails is paused”, telling you the service is disconnected. Go to the Cloud Accounts tab, authorize the account again, and resume the job from the dashboard. More on this here: How to re-authorize a cloud account after an authorization error.
  2. Your Google storage is full. If Google won’t write because the account has no storage left, cloudHQ pauses the job. Make some room, then resume the job from the dashboard.
  3. The Gmail label was deleted. The job exports the emails that carry the job’s label. Delete that label and the job pauses, and cloudHQ shows the alert “Export of your email messages is paused – the label is deleted”. Create the label again, or set up a new export job.
  4. The label is not applied to new emails. Make sure your Gmail filter actually adds the label. Emails that don’t have the label won’t be exported, and the “only new emails” option leaves out older messages.
  5. You paused the job. When the status reads “Paused by user”, nothing gets imported until you resume the job.
  6. The spreadsheet reached the Google Sheets limit. One spreadsheet in Google Sheets holds 10 million cells at most. In some cases cloudHQ keeps going in a new spreadsheet, named like the first one with “(part 2)” added, and shows the warning “The export has been divided into multiple spreadsheets”. Check your Google Drive for the new file. In other cases the job pauses with the message “The spreadsheet has exceeded the maximum workbook size of 10 million cells”. In that case, stop the job and create a new one. The new job makes a new spreadsheet.

If that doesn’t solve it, send an email to support@cloudhq.net from the email address of your cloudHQ account, and include the job name.