To install Export Emails to Google Sheets, click here.
To start a wizard to export emails to Google Sheets, click here.
Export Emails to Sheets stores PDF files in two locations:
- The Emails folder of your Google Drive.
- A chosen folder, if you specified one during setup.
The PDF documents in the folder Emails are organized by label and email address.
The structure of the Emails folder looks like this:
Emails/ All Emails/ Labels/ Label 1/ Sublabel 1.1/ Sublabel 1.1/ Label 2/ Label 3/ .... Email Addresses/ firstname.lastname@example.org/ email@example.com/ firstname.lastname@example.org/ ....
- The email messages which are under label under <label_name> are saved in the folder Emails/Labels/<label_name>
- The email messages which are under label under <label_name>/<sub_label_name> are saved in the folder Emails/Labels/<label_name>/<sub_label_name>
- The email messages which are sent to or received from email address <email_address> are saved in the folder Emails/Labels/<email_address>
If you want to build your own structure, you need to create Google Drive shortcuts to the above folders.
For example, let’s suppose you have a job that is exporting the label Projects which has a sub-label for each of the projects (Project A, Project B, etc.).
So emails from that label will be also inside the folders:
Emails/Labels/Projects/Project A Emails/Labels/Projects/Project B ...
To organize it, create Google Drive shortcuts to the above folders from anywhere in your Google Drive or Google Team Drive. There will be only ONE version of a PDF file – with multiple shortcuts.
For example, you can create two short cuts: My folder for Project A and All emails I exchanged with email@example.com which look like this:
My folder for Project A -> Emails/Labels/Projects/Project A All emails I exchanged with firstname.lastname@example.org -> Emails/Email Addressesemail@example.com
save email; save email correspondence; save email exchange; backup to sheets;