Extract Email is a useful Google Script that will help you extract email addresses from your Gmail account. You may extract addresses from every single message in your Gmail mailbox or it can sift through emails that are tagged with a particular label (or folder).

The extracted email addresses are saved in a Google spreadsheet that you may either download as a CSV file for importing into your mailing list program or you can use that raw list as an input for Mail Merge.

If you looking to create an email marketing campaign for your clients that are not in your Google Contacts address but have previously communicated with you over email, The Sender’s List could be a time-saving option.

extracted email addresses

To get started, click here to create a copy of the email extractor Google sheet in your Google Drive. Next, put the name of your Gmail folder in cell A2. You may use inbox for extracting addresses from mails that are in your Inbox, sent for mails that you have sent, starred for just the important emails or all for processing all messages.

Please note that Gmail label names are case sensitive.

Internally, the script pulls email addresses of senders from messages tagged with a particular label and exports them to a Google Sheet. Since the script needs to track messages that have been processed, it applies a new label to these messages and the default name of this label is AddressExtracted . If you wish to use a different name, just replace the value of cell B2.

Now choose the Gmail Addresses menu in the Google sheet (see screenshot) and select Initialize. Grant the script access to your Gmail mailbox and then choose Start from the same Gmail menu to begin the extraction process.

The Google script is now running in the background and, depending on the size of your Gmail folder, may take some time to complete. You may close the Google sheet and it will send you an email once the extraction is complete. You can then use the Remove Duplicates option in the Gmail Addresses menu to filter out all the duplicate email addresses from the final list.

If you wish to extract addresses from another Gmail label, just create a new copy of the blank sheet and repeat the steps. Also, you may choose Gmail->Uninstall to stop the background script from running.

Email Extract for Gmail — Premium


The free version of the email extraction script extracts the sender’s email address only. If you however wish to extract all email addresses that are mentioned in the message body or in the TO an CC list of the message, please upgrade to the premium version.

It includes a step-by-step installation manual and you may also opt for one-on-one Google Script support via email, Skype or Google Hangouts.

Awesome Google Scripts → Custom Google Scripts →