Export Emails to Google Sheet: Custom Columns (extracted from email headers)

Export Emails to Google Sheets will generate spreadsheet with columns. Columns are can derived from rfc822 email message headers. Email headers are present on every email you receive via the Internet.

The header fields contain information about the message, such as the sender, the recipient, and the subject. If a message body is included, it is separated from the header fields by an empty line (\r\n).

The following example illustrates a message in the RFC 822 message format:

Return-Path: <0100017860b743a8-bab292ea-0a89-4d28-8885-ba52392aa5a4-000000@amazonses.com>
Received: from a30-99.smtp-out.amazonses.com (a30-99.smtp-out.amazonses.com.
        by mx.google.com with ESMTPS id n18si9198603qtx.401.2021
        for <******>
        (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-SHA bits=128/128);
        Tue, 23 Mar 2021 13:12:07 -0700 (PDT)
Date: Tue, 23 Mar 2021 20:12:06 +0000
From: cloudHQ 
References: <62d924c86311b6d05b8957524eb6664577c958ce@cloudhq.net>
Mime-Version: 1.0
Message-ID: <0100017860b743a8-babaa5a4-000000@email.amazonses.com>
X-SES-Outgoing: 2021.03.23-54.240.30.99
Feedback-ID: 1.us-east-1.xJ6EU3cbbfM7B+rb5qqUKRi95Pu4rw4hOG+l1ndnmms=:AmazonSES

This is the plain text body of the message. Note the blank line
between the header information and the body of the message.

In the above example, the headers are:

  • Return-Path
  • Mime-Version
  • References
  • X-SES-Outgoing
  • Feedback-ID

Some explanation about what rfc822 email message headers are can be found here.