Acme Widgets inc. has been in business for over ten years and that they have exchanged emails with thousands of customers and suppliers. the email messages are archived neatly in Gmail however most of the email addresses aren’t keep in Google Contacts. the company is currently shifting office and that they need to inform everybody via email of the office move.
The big task ahead is to extract of these email addresses from the Gmail mailbox and download them during a format, like CSV, which will be simply imported into the Google address book or a mailing list service like MailChimp.
Introducing Email Address Extractor, a Google add-on that sifts through all email messages in your Gmail account, extracts the email addresses and saves them during a Google spreadsheet. It works for each Gmail and Google Apps accounts.
The Extractor will mine email addresses from a specific Gmail folder (label) or the entire mailbox. you’ll opt to extract emails of the sender, the recipient(s) and those within the CC list. The add-on may also parse the email‘s subject and message body for email addresses. this can be helpful for extracting addresses from generic senders, like PayPal emails or contact forms, wherever the email addresses are contained in the message body.
How to Extract Email Addresses in Gmail
You may follow the step-by-step guide.
- Install the Gmail Extractor add-on and grant the mandatory permissions. The add-on wants access to your Gmail and additionally to Google Drive for saving the email list within a Google spreadsheet.
- Go to the addons menu inside the Google spreadsheet, opt for Email Address Extract and click on start to launch the extractor addon.
- Specify the search criteria and all emails that match the rule are parsed by the extractor. you’ll use any of the Gmail Search operators to filter messages.
- Next choose the fields (to, from, cc, bcc) that should be parsed for extracting emails (screenshot). The add-on may also pull names of the sender and recipients if they’re available inside the message header.
Click the “Start” button and also the extractor can start pulling emails into the spreadsheet. the whole process might take some time depending up on the size of your Gmail mailbox.
Gmail Extractor FAQ
The Google sheet ought to remain open and also the computer ought to be online during the extraction. If the connection is lost, or if the extraction method is interrupted for a few reason, you’ll simply click the “Resume” button and the extractor can pick from where it left off earlier.
If you go back to Gmail, you’ll find a new label referred to as Extracted. This keeps tracks of the emails that are processed and may safely delete this label after all the email address have been parsed and extracted.
The Google spreadsheet created by Email Extractor add-on has 2 sheets – All Emails & unique Emails. the primary sheet includes each single email found in your Gmail account while the second sheet may be a cleaned up list sans any duplicate emails. this can be the sheet you should use for building your address book.
The free version of the add-on is totally featured but it might only extract addresses from up to five hundred email threads (a thread contains multiple email messages). The premium version imposes no such restriction and it entitles you to 90 days of complimentary support.
Internally, it’s a Google Script that uses the magic of standard Expressions to pull email addresses from Gmail. The extracted email addresses are saved during a Google spreadsheet which will be used as input for sending personalized email messages through Gmail Mail Merge.