The Gmail add-on extracts email addresses and names from email messages. It can extract emails from the message header (To, From, CC, ReplyTo fields), the email body and subject line. The email addresses are saved in Google Sheets that can be later imported into other email services like Outlook, Google Contacts, MailChimp, or CRM applications like Salesforce.
Listing updated:February 26, 2024
Works with:
349K+
Overview
The Email Address Extractor extracts email addresses from your Gmail and GSuite accounts and saves them in a Google Spreadsheet.

The add-on can pull emails from the TO field (Recipients), the FROM field (Sender), CC field, BCC field, Reply-To addresses, the Email Body and the Email Subject line.

You can also choose to extract names (aliases) only if the names are available in the TO, CC and FROM field of the email message. The names cannot be extracted from the message body or email signatures.

The Gmail add-on runs in your Google Account and does not store, share or upload your data anywhere. It processes your Gmail messages and saves the emails directly in a Google Sheet in your Google Drive.

The Email extractor add-on is fully functional but the free edition can process a maximum of 100 email threads from your Gmail mailbox. If you need wish to extract email addresses from a large number of Gmail labels, or extract addresses from old messages in your Gmail archives, please upgrade to the premium edition.

The extractor add-on will apply the Label "Extracted" to all Gmail messages that have been processed. Once the extraction is complete, you can safely remove the label from your Gmail account manually.

You can use advanced Gmail search operators to extract email addresses from specific messages. For instance, you can say from:paypal newer_than:7d to extract addresses from all emails of PayPal that were received in the last week.

The addons is designed and develped by Amit Agarwal, Google Developer Expert for GSuite and Google Apps Script. It has been verified by Google for compliance with all their policies.

Tutorial:
---------
https://www.labnol.org/gmail-search-4355

Support:
---------
https://digitalinspiration.support

Buy License
-------------
https://digitalinspiration.buy?sku=GA07

Changelog:
-----------
Jun 03, 2020 - Completely rewritten Email Extractor, improved duplicate engine for removing duplicate emails in the sheet, enhanced free daily limits
Sep 12, 2019 - Dates issue resolved. INR Price updated.
Sep 04, 2019 - Scopes Updated. Security Assessment Completed by Google
Oct 22, 2018 - Added in-app purchase option for Gmail users in India
Sep 27, 2018 - Added support for parsing emails encoded in 7bit and older formats
Sep 25, 2018 - Added option to renew product license.
Sep 18, 2018 - Updated extractor to pull email addresses from the body of emails that are encoded in 7bit or 8bit in addition to base64 encoding.
Additional information
PricingNot available
Developer
Privacy policy
Terms of service
Email Address Extractor will ask for the permissions shown below. Learn more
Email Address Extractor will need access to your Google account
This will allow Email Address Extractor to :
See, edit, create, and delete all your Google Sheets spreadsheets
Read, compose, and send emails from your Gmail account
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Loading
Search
Clear search
Close search
Google apps
Main menu