Stop Losing Contacts – Consolidate on Google Contacts



When I wrote up the piece on backing up your photos I mentioned how this is a regular complaint on Facebook.  The other thing that I don’t understand in this era is losing contacts.  Currently in my cleaned and trimmed address book I have over 2600 contacts.   At my high point I had over 4000, until I standardized, cleaned up, and backed up everything.   I took the pain so you don’t have to.   This article should give you a shortcut for what took me many years to learn.

Android has the feature to directly integrate with Google Contacts.  The people that lose contacts at that platform just must have set their contacts to only be stored locally.   The first step for Android folks is to make sure this integration is configured before going forward in this article on consolidating your contacts across platforms.

If you are using IOS – Google created this help document on getting Google Integration on your device.  This integration configures syncing of Gmail, Google Calendar, and Google Contacts.  If you weren’t using Google before, the contact use case might be enough of a reason to join now.   I’ve standardized on Gmail and Google Calendar for those types of services and all my data is synced across my laptops and mobile devices.


Getting Contacts From Other Services

EcWNlRB9Google isn’t the only place you have contacts.  This is especially true if you are not a heavy Gmail user.  For the other Web/Mobile services you use, you will want those contacts included into your address book.  Full Contact is the primary method you are going to use to sync and add these contacts from other services.

Full contact supports the following web services Google Contacts, LinkedIn (more on this in a second), Twitter, Facebook, Foursquare, Instagram, iCloud, Angel list, and Xing.  The last three services I don’t use at all, so I haven’t configured them.  If you want to use iCloud you can skip over Google Contacts completely (I think), but it will make cleanup much more painful in the long run.   I mentioned that it supports LinkedIn, but this functionality is not native.  It requires you export a file from the LinkedIn service and then import it in manually.  So LinkedIn connections are going to be an ongoing task depending on how often you add in new connections.

Something you are going to have to consider once you start using Full Contact is how you interact with these different services and how you want the contacts from those services included into your address book.  For each service there are two options.  The first option is to add contacts to your address book.  Whenever you add a new connection on any of these services, a new contact will be created in your address book (we will get to handle duplicates later).   The other option is to update information from existing contacts with the information from these other services.  Google and iCloud (I believe) offer a full sync option on top of the two.

The problem I’ve run across is that some of this contact information is useless.   For example if you have an Instagram contact that doesn’t have an email or phone number, that isn’t very useful to you.   I have my services configured in the following manner:

  • Google Contacts – Sync
  • Linkedin – Add Contacts
  • Facebook – Add Contacts
  • Twitter – Update Contacts
  • Foursquare – Update Contacts
  • Instagram – Update Contacts

Both LinkedIn and Facebook can get me real and usable contact information.  Since the other do not, that’s why I do not use the other services as a full contact source.  This is all dependent on how you interact and want your contacts.  If you are restrained on social media, you might be able to add all the individual contacts.   The free version of Full Contact limits you to 5000 contacts or less (after they have been deduplicated) so keep that under consideration if you have a larger address book than me.


Currently I’m using Zapier for a single purpose.  Zapier automates tasks that you do online.  It performs these actions in the background.   It is similar to IFTTT, but for the needs relevant in this article Zapier had one function that IFTTT doesn’t.   Zapier has a recipe combination that allows you to save Office 365 contacts to Google Contacts.   Since Google is my primary source, I rarely add contacts into Office 365.   For the contacts that do get created there, Zapier is happy enough to make sure they get added to Google Contacts silently in the background.


We have all the data from your contacts in one place.  How do we clean them up? Thankfully we can start with de-duplication.   There are two different tools we can use for this.  The first is Full Contact.   Full Contact will churn through and identify duplicate contacts.  The web interface will alert you on how many duplicates are found and give you an option to merge them.   On the merging screen you can verify that the contacts are related and can be merged together.  Once you have done this – the contacts are merged and you are done.

The second de-duplication you do inside of the Google Contacts.  On the left hand side there is a tab that states find duplicates.   This will again churn through all your connections and find any remaining duplicates.   Google seems to find a handful that Full Contact misses.  After running both of these tools though, I haven’t noticed any blaring duplications.

Here is the pain point for many long time Gmail users.  The manual cleanup.   I used the web interface, and this took sometime.  Lifehacker had an old article that documented dumping the contacts to a spreadsheet to clean up your Google contacts.  It all depends on how many contacts you have.  I removed any contact that did not have either an email address or a phone number.   The exception to this is Facebook friends had a reprieve.  I assume in some far off day that I’ll have their contact information to add later.  I also fixed any instances where the first and last name were reversed, the first name was an email address, or other blatant issues.  I now have a clean contact list.

Backing Up Contacts for Retrieval

While Google isn’t likely to go away anytime soon, it is good not to rely on it being around forever.   Now that everything is merged and clean, it good to do an export now.   This allows you to import it into another address book program if Google should ever depart this world.


If you install IFTTT’s mobile application, you can create rules that will run whenever you add a new contact.   The most common use is to dump new contacts into a spreadsheet.   Once you set this up, basically you forget about it and it will always run in the background.  This will allow you to log all new contacts that come in.  Currently I don’t use this – but between Full Contact, Google Contacts, and having it locally, I’m no longer worried about losing my contacts.