26 May 2016

How to Extract Email Addresses from your Gmail Messages


Acme Widgets Inc. has been in business for over 10 years and they have exchanged emails with thousands of customers and suppliers. The email messages are archived neatly in Gmail but most of the email addresses aren’t stored in Google Contacts. The company is now shifting office and they need to inform everyone via email of the office move.

The big task ahead is to extract all these email addresses from the Gmail mailbox and download them in a format, like CSV, that can be easily imported into the Google address book or a mailing list service like MailChimp.

Introducing Email Address Extractor, a Google add-on that sifts through all email messages in your Gmail account, extracts the email addresses and saves them in a Google Spreadsheet. It works for both Gmail and Google Apps accounts.

The Extractor can mine email addresses from a particular Gmail folder (label) or the entire mailbox. You can choose to extract emails of the sender, the recipient(s) and those in the CC list. The add-on can also parse the email‘s subject and message body for email addresses. This is useful for extracting addresses from generic senders, like PayPal emails or contact forms, where the email addresses are contained in the message body.

How to Extract Email Addresses in Gmail

You may follow the step-by-step guide or watch the video tutorial on YouTube (download) to get started:

  1. Install the Gmail Extractor add-on and grant the necessary permissions. The add-on needs access to your Gmail and also to Google Drive for saving the email list inside a Google Spreadsheet.
  2. Go to the addons menu inside the Google Spreadsheet, choose Email Address Extract and click Start to launch the extractor addon.
  3. Specify the search criteria and all emails that match the rule will be parsed by the extractor. You may use any of the Gmail Search operators to filter messages.
  4. Next select the fields (to, from, cc, bcc) that should be parsed for extracting emails (screenshot). The add-on can also pull names of the sender and recipients if they are available inside the message header.

Click the “Start” button and the extractor will start pulling emails into the spreadsheet. The entire process may take some time depending up on the size of your Gmail mailbox.

Gmail Email Extractor

Gmail Extractor FAQ

The Google sheet should remain open and the computer should be online during the extraction. If the connection is lost, or if the extraction process is interrupted for some reason, you can simply click the “Resume” button and the extractor will pick from where it left off earlier.

If you go back to Gmail, you’ll find a new label called Extracted. This keeps tracks of the emails that have been processed and can safely delete this label after all the email address have been parsed and extracted.

The Google Spreadsheet created by Email Extractor add-on has two sheets – All Emails & Unique Emails. The first sheet includes every single email found in your Gmail account while the second sheet is a cleaned up list sans any duplicate emails. This is the sheet you should use for building your address book.

Email Address List

The free version of the add-on is fully featured but it would only extract addresses from up to 500 email threads (a thread contains multiple email messages). The premium version (link) imposes no such restriction and it entitles you to 90 days of complimentary support.

Internally, it is a Google Script that uses the magic of Regular Expressions to pull email addresses from Gmail. The extracted email addresses are saved in a Google spreadsheet that can be used as input for sending personalized email messages through Gmail Mail Merge.

Also see: Schedule Emails in Gmail for Sending Later


The story, How to Extract Email Addresses from your Gmail Messages, was originally published at Digital Inspiration by Amit Agarwal on 26/05/2016 under GMail, Internet.

23 May 2016

How to Identify the Gender of your Twitter Followers


Do you ever wonder what is the demographics of people who follow you on Twitter. How many of your Twitter friends are men? Or women? Or random colored eggs, people who are either too lazy to change their default avatar or maybe they are Twitter bots.

The Graph Search of Facebook can provide deep insights into the demographics of people who are connected with you on the social network. For instance, you can write a natural language query like “My friends who are older than 30” or “My female friends who live in Delhi” and the answer will be available instantly. Such granular data is however not available for Twitter users.

Who Follows You? Males, Females or Eggs

How do you programmatically determine the gender of a person on Twitter?

The Twitter API doesn’t provide the gender information but there’s a workaround. You can take the profile picture of a Twitter user, feed it into Siftr’s Vision API and it will detect the gender of the most prominent face in the photograph. You can go a step further and use Microsoft’s Face API and it will even provide the approximate age of the subject in the photo.

Image Recognition to know the gender of Twitter followers

Detecting Gender of Twitter users with Image Recognition

 

Analyze your Twitter Followers

Meet Twitter Analyzer, a web app that analyzes your Twitter network (friends or followers) and logs the details of all user inside a Google Spreadsheet (see screenshot). You get to know their gender, how often they tweet, where are they located, when did they last join Twitter and more.

Getting started is easy. Go to labnol.org/analyzer and sign-in with your Google Account. It requires all these permissions because the underlying Google Script saves everything inside a Google Spreadsheet that will be in your Google Drive. Once the Twitter followers have been analyzed, you’ll get an email notification.

After you’ve granted the necessary permissions, click “Authorize Twitter” to allow the sheet to access your Twitter account. It will never post any tweet to your profile. Next click the scan button and close the page. You’ll get an email once the analysis is complete and this time will vary based on the number of followers you have.

Twitter Eggs

Go to labnol.org/analyzer to scan your Twitter followers

 

Identifying Humans vs Twitter Bots

Camisani Calzolari wrote a set of rules (PDF) that can help detect real users from bots, inactive accounts and fake Twitter users. Some of the rules are:

  • The account has written at least 50 tweets
  • the account has at least 30 followers
  • the profile contains a URL
  • the profile contains an image
  • the profile contains a biography
  • it has been inserted into other Twitter lists

The Google Spreadsheet that is generated by the Twitter Analyzer app includes most of this information as well. Thus, apart from gender analysis, the Analyzer app may help you figure out how many fake bots and inactive profiles follow you on Twitter.


The story, How to Identify the Gender of your Twitter Followers, was originally published at Digital Inspiration by Amit Agarwal on 23/05/2016 under Twitter, Internet.