To install Export Emails to Google Sheets, click here.
To start a wizard to export emails to Google Sheets, click here.
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/ email@example.com/ firstname.lastname@example.org/ email@example.com/ ....
- 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 firstname.lastname@example.org which look like this:
My folder for Project A -> Emails/Labels/Projects/Project A All emails I exchanged with email@example.com -> Emails/Email Addressesfirstname.lastname@example.org
save email; save email correspondence; save email exchange; backup to sheets;