App Icon
Digital Inspiration
•  50,534
Overview
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.
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.
Reviews
Language:
Sort by:
Profile Picture
Danny Pratt
January 6, 2021
This thing is AWESOME! I needed to get a sortable list of every email that has passed by my account and this did it perfectly. Quick proTip - make a third column on the source sheets page. In this make a delimited formula that sorts for only the @ symbol and everything after. That will allow you to sort by company (well domain, but that is pretty damn close)
Is this review helpful?
Yes
No
Profile Pciture
Danny Pratt
January 6, 2021
Oh and I got the paid variant. It is the best 4 bucks I have ever spent
Profile Picture
Green tv
December 25, 2020
Super tools.This looks like a useful add on and I would not mind use the paid for version. The issue I have noticed on trialing it is that I have 105 email in the sheet and 146 in the folder with "extracted" label. So I have no clue which emails are missing. Without this, it would be a 5 star product.
Is this review helpful?
Yes
No
Profile Pciture
Amit Agarwal
December 29, 2020
It may happen that you have multiple email messages from the same sender. The addon will thus only write unique emails to the sheet and ignore the duplicate addresses.
Profile Picture
Young Cyber Bd
December 23, 2020
Super Tools
Is this review helpful?
Yes
No
Profile Picture
Herve Humbert
November 22, 2020
This looks like a useful add on and I would not mind use the paid for version. The issue I have noticed on trialing it is that I have 105 email in the sheet and 146 in the folder with "extracted" label. So I have no clue which emails are missing. Without this, it would defo be a 5 star product. Also, I am requesting telephone number when ppl download my white papers. So I would like to be able to extract that from the email. I am conscious this is a pre-sale support question so not likely to be answered but I am throwing it out there just in case.
Is this review helpful?
Yes
No
Profile Picture
Meghan Pfeiffer
November 21, 2020
Doesn't work with forwarded emails.
Is this review helpful?
Yes
No
Profile Pciture
Amit Agarwal
December 29, 2020
It works on all sorts of emails. For forwarded emails, the email addresses are in the body of the email message and the addon can extract email addresses from the body of the emails as well into the Google Sheet.
Profile Picture
Natalie Thomson
November 20, 2020
supet tool.easy to use
Is this review helpful?
Yes
No
Profile Picture
Charles Betsill
November 9, 2020
Awesome 👍
Is this review helpful?
Yes
No
Profile Picture
Kevin Muturi
November 5, 2020
Loved it
Is this review helpful?
Yes
No
Profile Picture
Vincent Keunen
October 24, 2020
Great tool! Very easy to use, powerful... Congrats!
Is this review helpful?
Yes
No
Profile Picture
Marco Bell
October 20, 2020
Very helpful tool:-)
Is this review helpful?
Yes
No
1-10 of 104
Additional information
Digital Inspiration
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu