This problem recently beset me the other day when I discovered that I needed to create a mailing list for the employees of My Thought and Technology and Jamaica Writer’s Guild. This is a non-profit research group I’ve formed for the purpose of showing others how to make money online (Deer, 2014) using VPN (Virtual Private Networks).
So back to the mailing list problem; how do I extract emails from my Gmail account? Turns out it’s as simple as using a Google Script called Gmail Extractor (Agarwal, 2014) to extract all your email contacts in a few simple steps.
- Click Gmail Extractor to copy the Google script into your Google Drive
- Put the name of your Gmail label in cell A2 e.g. Inbox
- Go to the Gmail Addresses menu in the Google sheet
- Select Initialize
- Grant the script access to your Gmail mailbox
- Choose Start from the same Gmail menu to begin the extraction process
The process takes several minutes to several hours, depending on how much email you have in your Gmail accounts. You can actually close your Gmail Account and go about your business.
When the Google script is finished extracting your emails, it’ll send them to you as an email with an attachment. Just download the *.csv file and your list of Gmail contacts is there for you to use!
Next time I touch on this topic, I’ll be exploring email address extraction from other emails, such as Yahoo and Microsoft Outlook.
Here’s the link:
- Agarwal, A. (2014, July 5). How to Extract Email Addresses from your Gmail Folders. Retrieved from http://www.labnol.org/internet/extract-gmail-addresses/28037/
- Deer, L. (2014, September 20). Surfing the Internet Anonymously using VPN – How to use Streaming Set Top Boxes over VPN. Retrieved from http://mythoughtsontechnologyandjamaica.blogspot.com/2014/09/surfing-internet-anonymously-using-vpn.html