Export Emails to Google Sheet: Default Columns

Export Emails to Google Sheets will generate spreadsheet with columns. Columns are derived from common email headers, email body text, and special email headers.

Default Columns:
These are columns that are derived from email headers and some basic parsing of email body text.

Column Name Description
Thread ID thread ID of Gmail conversation
Message ID message ID of Gmail email message
From Sender email address
From (all info) Sender email address and name. It is in this format: name <email@address.com>
To Recipient email address
To (all info) Recipient email address and name. It is in this format: name <email@address.com>
Cc Cc email address
Cc (all info) Cc email address and name. It is in this format: name <email@address.com>
Bcc Bcc email address
Bcc (all info) Bcc email address and name. It is in this format: name <email@address.com>
Reply-to Reply-to email address
Reply-to (all info) Reply-to email address and name. It is in this format: name <email@address.com>
Subject Subject of the email message
Date & Time Sent Date and time when the email message was sent
Date & Time Received Date and time when the email message was received (appered in your inbox).
Labels List of Gmail labels for the email message.
RFC 822 Message ID RFC 822 Message ID of the email message. Message ID is a unique identifier for the email message, Each email you send and receive has a RFC 822 Message ID attached to it. Once you determine what the RFC 822 Message ID value is, you can search your inbox for any emails with that ID. If you scroll all the way to the bottom of this list of Gmail search filters, rfc822msgid shows up as an option.
Email Text The email message in a txt format.
Body Snippet Body snippet the email message in a txt format.
Email in PDF The email message in a PDF format. The PDF is saved to your Google Drive insdide folder /Emails. The folder Emails has 3 subfolders:

  1. All (all email messages)
  2. Labels(email messages organized by labels),
  3. Email Addresses (email messages organized by email addresses)
Attachments Email message attachments. The attachments saved to your Google Drive insdide folder /Emails. The folder Emails has 3 subfolders:

  1. All (all email messages)
  2. Labels(email messages organized by labels),
  3. Email Addresses (email messages organized by email addresses)
Attachments Count/td>

Number of the attachments in the message.
Is Real Reply? Set to YES if the email message is real reply: it is not bounce, automated response, etc.
Is Auto Reply? Set to YES if the email message is automated response (out of office, etc.).
URL Links This option will extract all url link from the body of the email message.