Find Your Followers’ Other Social Media Accounts Using Google+
BY: Chris Makara
Dec 02, 2014
Home > Blog > Find Your Followers’ Other Social Media Accounts Using Google+

Creating connections is an integral part of any digital strategy. For the most part, you and I made a connection through a social channel. Channels such as Twitter, LinkedIn, Google Plus, or Pinterest.

Even though Google killed off authorship in the search results, I am still a believer in using Google Plus to drive referral traffic.

Not only is Google Plus a nice source for traffic, it is also an excellent website to build meaningful relationships. Unlike Twitter or Pinterest, your profile can provide some great insight into your audience. You are able to provide detailed information about yourself on your “About” page in Google Plus.

Most people (myself included) took some time to really provide details about who we are are. Not only can you cover your background, but you can add employment history and even links to other websites you frequent.

Among these websites listed are typically other social media profiles such as Twitter, LinkedIn, Facebook, and Pinterest.

Google Plus About Social Links

Since I am already connected to someone on a Google Plus, chances are that at they would connect to me other other social sites they have profiles on. Sure, I could manually go through each of my connections and make a list of their social accounts to follow. It would feel a lot like “Where’s Waldo“. You would spend so much time looking at each Google+ profile and seeing where they might have other social media accounts.

But, ain’t nobody got time for that!

Keep reading and I will reveal how to easily create a Google Docs/Microsoft Excel file that shows how to find social media accounts of your Google+ audience.

What is Needed

To accomplish this, we will need access to the following tools:

  • Circloscope
  • iMacros (for Chrome or FireFox)
  • Google Docs
  • Microsoft Excel

While there is a paid version of Circloscope (which I use), I believe you can use the free version for the data we need.

Getting Your Google+ Data

The first thing we need to do is to get a list of the users who follow you (or who you follow) on Google+. For this, we will use Circloscope.

For me, Circloscope is the most powerful Google+ tool out there. I won’t go into all the cool things you can do with it, but here is a good starting point.

This is a browser extension that loads right up into Google Chrome or FireFox.

Once it is installed, we need to export the list of users we want to find the social profiles for. Depending on how you have your Google+ Circles setup, you can choose one, some, or all of your circles to pull the data from.

Here is How To Export Google+ Data

  • Activate the Circloscope plugin by clicking on it in your browser
  • Click on the “Dashboard > My Circles” drop down and select all or one of your circles you want to find the social media profiles for
  • Click “Select > Select All”
  • Click “Action > Export > Export To Text File”
  • Click “All”
  • Click “OK”
  • Click “Save”

circloscope

Creating a CSV of Google+ Followers

Once you have exported from Circloscope, we will need to modify the file. For some reason, when you create a CSV file from Circloscope, it does not properly generate the Google+ ID of the user if you simply try to open the file in MicroSoft Excel (if you know why, please let me know).

To properly import the CSV data, I like to use Google Docs to import the Circloscope data which creates the correct Google+ profile URLs.

So head on over to Google Drive and click to create a new spreadsheet. Once you blank spreadsheet has is created, click on “File > Import >Upload” and select the text file you exported from Circloscope. For the settings, you can select “Replace Spreadsheet” and “Detect Automatically. Then click “Import.” Once the import is complete, click “Open Now.” Your spreadsheet will show all the data that was exported from Circloscope, including the Google+ ID number.

Create CSV in Google Docs

Now we need to add the a URL to the ID to create a full URL that will pull up the social media links we want to scrape. You might think we are simply going to add the URL “http://plus.google.com/+” to the ID. However, I’m not a huge fan of scraping data from Google owned sites.

So what we will do here is scrape a site that already gets this data from Google+. The site you will be getting the data from is CircleCount.

Therefore, we need to combine the URL for CircleCount and the Google+ ID so that the script we run knows where to get the data from. In your Google Spreadsheet, click on column A and right click > “Insert 1 Left.” This will create a new column. Then in this column, paste this formula:

=CONCATENATE(“http://www.circlecount.com/p/”,C2)

Provided your ID column is column C, this will create the full URL our script needs to visit for the data. Be sure to drag down the formula for all rows of data.

Next, we need to save this file as a CSV. Simply click on “File > Download As > Comma Separated File (CSV).”

Find Social Media Accounts From Google+

Once the CSV is ready, we can move on to actually getting the social media profile data from Google+. To do this (and automate the process), we are going to use one of my favorite tools, iMacros.

In short, iMacros allows you to do many things, one is automate repetitive tasks. In this case, we are going to use it to visit a list of Google+ profiles and create a CSV of social media profiles for Twitter, LinkedIn, Pinterest, and Facebook.

The first thing you need to do is install iMacros for Google Chrome or FireFox. After it is installed, you will need to add a JavaScript to iMacros (don’t worry, if you can copy/paste it’s easy). Simply drop in your email address below so I know where to email the iMacros script to.

Get the iMacros Script – Click here to download my “ready-to-go” iMacros script.

  • Open the iMacros extension in the browser of your choice (I prefer the FireFox version to the Chrome – both should work)
  • Get the code by clicking the button below, open it and copy it to your clipboard (Ctrl+A then Ctrl+C)
  • Click the “Record” tab and press “Record”
  • Click “Stop”
  • Click the “Manage” tab and click “Edit Macro”
  • Delete all text that appears in the editor and paste the text from your clipboard
  • Edit row 11 to match the location of your iMacros installation
    • This is what row 11 looks like “iMacrosFolder=”C:\\Users\\Chris\\Documents\\iMacros\\Datasources”, // iMacros Install folder”
  • Click “Save & Close”

By default, your macro will be saved as “#Current.iim.”, you need to right click on the name and select “Rename” to rename it as something else. By default, anytime you click “Record”, the macro will be saved as “#Current.iim”. It is important that you rename it so that you don’t accidentally overwrite it. Also, for this macro to work, we need to be sure it has a .js extension. So a name like “GooglePlus.js” would work.

This script is what tells iMacros what it needs to do. Here are the basic steps:

  • Visit CircleCount for the profile of a Google+ user from your Google+ profile list
  • Scan the page for links to Twitter, LinkedIn, Pinterest, and Facebook
  • Save these URLs to a CSV
  • Visit the next profile in your Google+ profile list
  • Repeat until all profiles have been visited

Before we actually run the script, you will need to move (or save as) your CSV that was created in Google Docs as “Profiles.csv” in your “/iMacros/Datasources” folder. This file is where the iMacros script will look for the usernames to get the data for. This will be the same location as what you used on row 11 of the script. For example, I saved my CSV into “C:\Users\Chris\Documents\iMacros\Datasources”.

Now you are ready to find social media accounts. In Chrome (or FireFox), select your script in the iMacros area and simply click the “Play” button.

iMacros For Google+
Depending on how many profiles you want data for, it can take a while to complete. For example, it takes about an hour to get the data for 100 profiles. Once complete, you will have a single CSV file with the social profiles of each of your users from your Google+ profile list located in your iMacros/Datasources folder. If a user doesn’t happen to have a social profile listed, then the cell(s) will be empty. While it would be nice to find all social media accounts, if they don’t have anything listed there is not anything this approach can do about it.

I like to open the CSV file in Excel so I can easily sort and filter the data. Of course, you can use Google Docs to do this as well. You can view the raw data, or create a chart to easily see the breakdown of where your audience has social media accounts.

Social Site Breakdown

Using Your Google+ Social Media Profile Data

There are several ways to use the newfound social media data you have collected. Most notably, you can see which social channels your connections are already on. With this, you can easily locate their social profile and reach out to connect with them. Since you are already connected with them on Google+, you have a great chance of them connecting with you on other social sites.

One thing you can do specifically for Twitter is load up the profile URLs into certain tools which will then follow these users in somewhat of an automated fashion. If you are really adventurous, you can also use iMacros to do this as well. In fact, I’m confident you can do this with iMacros on Pinterest as well.

If you really wanted to dive into the Twitter profiles, you can easily build a Microsoft Excel spreadsheet that will scrape Twitter profile data.

Those are just a few ideas of how to use this social profile data from Google+. Be sure to let me know in the comments how you plan on using this data.

Chris Makara

Chris Makara

I have over 12 years of experience in Interactive Marketing & Digital Strategy, with a focus on SEO, Social Media & Demand Generation. I am an avid Football Fan, Golf Enthusiast & Ambidextrous Bowler. I can also be found on Google+, LinkedIn, and Twitter.
Chris Makara
(Visited 837 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *


I’m Chris Makara and I share my 13+ years of
Real world digital marketing experience
without the theories or concepts.