App Icon
Digital Inspiration
•  112,658
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
Hazel Mae Fernando
April 28, 2021
works like a charm! thank you so much! :)
Is this review helpful?
Yes
No
Profile Picture
Purushotham Ram
April 10, 2021
The app didnt work
Is this review helpful?
Yes
No
Profile Picture
Mukne Lea
April 9, 2021
great
Is this review helpful?
Yes
No
Profile Picture
Julanda Theron
February 25, 2021
THIS ADD ON DOES NOT WORK. THE SUPPORT IS NON-EXISTANT. ONLY AFTER YOU BUY PREMIUM IT SAYS IT IS NON-REFUNDABLE WHICH IS IN VIOLATION OF THE CONSUMER PROTECTION ACT AS I PAID FOR A SERVICE THAT WAS NOT PROVIDED. I THEREFORE DEMAND A REFUND. NOT ONLY DOES THE PROGRAMME NOT WORK BUT I ALSO PAID FOR TECHNICAL EMAIL SUPPORT WHICH WAS NOT PROVIDED. THIS COMPANY IS THUS IN VIOLATION The terms of an agreement to supply goods or services may not be unfair, unreasonable and unjust, for example, the terms may not only favour the supplier. Such a term or agreement will be void. This means that the consumer can return the goods bought or cancel his/her order within 5 days after the date s/he received it or ordered it, without penalty or reason. The supplier must inform the consumer of his/her right to a cooling-off period. I POST HERE AS NO OTHER PLACE SEEMS TO GET A RESPONSE. Don't waste your money
Is this review helpful?
Yes
No
Profile Picture
Rakesh Prabhu
February 3, 2021
Useful tool, but it looks like no support. I'm unable to activate the premium license and I had dropped a message on their website and sent an email. No response.
Is this review helpful?
Yes
No
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
Barry Bowden
February 11, 2021
I would like to have the same option added if possible.
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.
1-10 of 104
Additional information
Digital Inspiration
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu