How to extract email addresses from your own Gmail Account

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).

MICO Wars - How to extract emails addresses from your own Gmail Account - 31-01-2015 LHDEER

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.

  1. Click Gmail Extractor to copy the Google script into your Google Drive
  2. Put the name of your Gmail label in cell A2 e.g. Inbox
  3. Go to the Gmail Addresses menu in the Google sheet
  4. Select Initialize
  5. Grant the script access to your Gmail mailbox
  6. 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:

Gmail Email Extractor Script


  1. Agarwal, A. (2014, July 5). How to Extract Email Addresses from your Gmail Folders. Retrieved from
  2. Deer, L. (2014, September 20). Surfing the Internet Anonymously using VPN – How to use Streaming Set Top Boxes over VPN. Retrieved from

One thought on “How to extract email addresses from your own Gmail Account

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s