Skip to content

TechRepublic

  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
  • TechRepublic Premium
  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium
Join / Sign In
Cloud

Screenshots: Use Scrubly to update Google Contacts

By Andy Wolber November 18, 2013, 1:10 PM PST on Twitter awolber

Image
1
of 10

1_maxresdefault.jpg
1_maxresdefault.jpg
Screenshots: Use Scrubly to update Google Contacts

Update your Google Contacts list with social media info

Update your Google Contacts list with social media info

Thisrngallery is a supplement to a TechRepublic article.

Just keeping a mailingrnlist current can be a chore. “Between 2011 and 2012, 12 percent of peoplernin the country over the age of 1 moved at least once,” according to a December 2012rnpost at the official U.S. Census Bureau blog. That means that the address of one out of eight of your contacts needrnto be updated each year.

rnrn

Mass mailers updaterntheir address lists with services. For example, in the U.S., the NCOALinkrn(National Change of Address) service identifies address changes, and improvesrnaddress accuracy (e.g., updating five digit postal codes to morernlocation-specific nine digit codes). The mailer pays a fee for the service andrnends up with a more accurate address list.

rnrnBut your Google Contacts list contains more than justrnpeople’s mailing addresses. It contains phone numbers and email addresses. Forrnprofessional contacts, it contains company names and job titles. All of thisrninformation can change without anrnaddress change. And it takes time to maintain.

2_Header-Scrubly.png
2_Header-Scrubly.png
Screenshots: Use Scrubly to update Google Contacts

Have you updated your Contacts list with information from social networks?

Have you updated your Contacts list with information from social networks?

Scrubly

rnrn

That’s pretty muchrnwhat Scrubly is: arnweb-based updating service for Google Contacts. With your permission, Scrublyrnupdates your contact list with information drawn from Facebook, LinkedIn, andrnTwitter. It also consolidates duplicate contact information and deletes blankrncontacts. (You may manually modify Scrubly’s recommendations any time.) Scrublyrnwrites the updated information back to your Google Contacts list.

rnrn

Scrubly charges arnfee of $19.95 for a “one-time scrub” of your contacts, or $39.95 perrnyear for an unlimited number of “scrubs” during the year. If you havernfewer than 250 contacts, Scrubly is free.

rnrnIn addition to updating Google Contacts lists, Scrublyrnalso works with Outlook and Mac contact lists. With Google Contacts, Scrublyrnimports and export the data via the web. When using Scrubly to update Outlookrnor Mac address book contacts, you’ll need to install a bit of software on yourrnsystem to help with the import and export process.

rnrn

Credit: Image by AndyrnWolber for TechRepublic

a-Scrubly6StepProcess.png
a-Scrubly6StepProcess.png
Screenshots: Use Scrubly to update Google Contacts

Scrubly cleans and updates your contact list using a 6-step process

Scrubly cleans and updates your contact list using a 6-step process

Google Contacts

rnrnHere’s a look at the Scrubly contact update processrnfor Google Contacts. The steps below assume you’ve created a Scrubly account,rnlogged in, and started the six-step “scrub” process.

rnrn

Credit: Image by AndyrnWolber for TechRepublic

b-UploadContactsToScrubly.png
b-UploadContactsToScrubly.png
Screenshots: Use Scrubly to update Google Contacts

Scrubly imports your contacts while displaying amusing messages

Scrubly imports your contacts while displaying amusing messages

1. Upload

rnrnFirst, you need to give Scrubly permission to accessrnyour Google Contacts. Scrubly then imports these contacts. In my case, Scrublyrnretrieved all 1,322 of my contacts.

rnrn

Credit: Image by AndyrnWolber for TechRepublic

c-ExpressOrDeepScrub.png
c-ExpressOrDeepScrub.png
Screenshots: Use Scrubly to update Google Contacts

The Express Scrub identifies obvious duplicates; the Deep Scrub compares data in more fields

The Express Scrub identifies obvious duplicates; the Deep Scrub compares data in more fields

(During the import process – and throughout thernscrub – you’ll see various messages suggestive of the “reticulatingrnsplines” message you might remember from SimCity. Messages like “Loadingrnworld maps…”, “Checking with Strunk & White”, and “Rhythmicallyrnapplying the bubbles”.)

rnrn

Credit: Image by AndyrnWolber for TechRepublic

d-ExpressScrubResults.png
d-ExpressScrubResults.png
Screenshots: Use Scrubly to update Google Contacts

Scrubly reports Express Scrub impact after you review identified duplicates

Scrubly reports Express Scrub impact after you review identified duplicates

2. Express Scrub

rnrn

Next, you have thernchoice of an Express Scrub or Deep Scrub. The Express Scrub consolidatesrnduplicate contacts, and removes blank and “system default” contactsrn(i.e., the sample contact records that often come with new systems). The DeeprnScrub takes more time, but identifies more potential duplicates by comparingrndata in more fields. A Deep Scrub includes an Express Scrub.

rnrnWhen duplicates are identified, you have completerncontrol over how each record is handled. Scrubly prefers to preserve data, sornwhen duplicate records are consolidated no data is lost. Of course, you canrnalways choose to preserve records. You can also edit individual fields inrnrecords identified as duplicates. Scrubly works to make sure you don’t lose anyrnuseful data in the cleaning process.

rnrn

Credit: Image by AndyrnWolber for TechRepublic

e-DeepScrubRules.png
e-DeepScrubRules.png
Screenshots: Use Scrubly to update Google Contacts

You choose the rules that Scrubly uses for Deep Scrub duplicate detection

You choose the rules that Scrubly uses for Deep Scrub duplicate detection

3. Deep Scrub

rnrn

Before a Deep Scrubrnbegins, you select rules for Scrubly to use. For example, one rule looks for: “Scansrnfor matching names. The contact name plus email address, phone number orrnaddress must match. Phone numbers are matched across Work, Home and Other.”

rnrnPotential duplicates are identified and presented forrnyour review. The review process may take some time, as you really should lookrnat each individual case. The Deep Scrub sometimes identifies contacts asrnduplicates when they are not. For example, I have two contacts named “HollyrnRoss”. Scrubly identifies these as possible duplicates, yet I’m confidentrnthat they are two distinct people. The review process lets me keep bothrnrecords.

rnrn

Credit: Image by AndyrnWolber for TechRepublic

f-PrioritizeSocialInfo.png
f-PrioritizeSocialInfo.png
Screenshots: Use Scrubly to update Google Contacts

Choose how Scrubly updates your contacts' information from Facebook, LinkedIn and/or Twitter

Choose how Scrubly updates your contacts' information from Facebook, LinkedIn and/or Twitter

In this phase,rnScrubly removes duplicate data within contactrnrecords. This eliminates the problem of having the same email address or phonernnumber listed in multiple fields within a contact record.

rnrn

Scrubly alsornstandardizes all your phone number fields to a format you specify. I choosernXXX-XXX-XXXX, but you might also select several other standard phone numberrnformats (e.g., XXX.XXX.XXX, (XXX) XXX-XXXX, etc.). 

rnrn

5. Social Update

rnrn

Next, Scrubly canrnpull information from social networks you use to update your contact list. Thisrnlets you add more current information to your contacts list. A colleague mightrnhave updated their job title on LinkedIn or Facebook. This process lets you addrnthat information to their contact record.

rnrn

If you use multiplernsocial networks, you’ll need to prioritize the information. For example,rnScrubly can import a contact’s photo from any of the three networks to which itrnconnects: LinkedIn, Facebook, or Twitter. You need to decide which photo tornuse. Since I use my contact list primarily for business purposes, I prioritizernthe networks in exactly that order (LinkedIn first, Facebook second, andrnTwitter last).

rnrnDuring this step you may choose to allow Scrubly tornOverwrite your existing information. If your contact list is quite out of date,rnit may be smart to select the “Overwrite” box for fields likely to bernout of date, such as Job Title and Company Name. Similarly, if you don’t havernphotos of most of your contacts, you might allow the Photo field to “Overwrite”rnexisting data. (I ran Scrubly once without Overwrite selected on most of these fields,rnthen re-ran it with Overwriternselected. I was happier with the results with Overwrite selected. My contactsrntended to have provided more accurate information on social networks than I hadrnin my contacts list.)

rnrn

Credit: Image by AndyrnWolber for TechRepublic

g-FullReportBeforeReplace.png
g-FullReportBeforeReplace.png
Screenshots: Use Scrubly to update Google Contacts

Review a full report before sending the scrubbed data to your account

Review a full report before sending the scrubbed data to your account

6. Download

rnrnFinally, Scrubly provides a full report of changesrnbefore sending the scrubbed contacts list back to your account. The finalrnprocess deletes all of your existing contacts, and then replaces them with thernscrubbed data. Importantly, Scrubly saves your original data. Should yournrealize later that the scrubbed data was somehow faulty you can always returnrnto Scrubly and choose to restore your original data.

rnrn

Credit: Image by AndyrnWolber for TechRepublic

h_star_trek_classic_communicator.jpg
h_star_trek_classic_communicator.jpg
Screenshots: Use Scrubly to update Google Contacts

In an ideal world, communication would be like Star Trek

Image: Mark Kaelin/TechRepublic

In an ideal world, communication would be like Star Trek

Bottom line

rnrn

I’ve found Scrublyrnuseful in two different scenarios. In one, Scrubly helped me quicklyrnconsolidate multiple digital contact lists: I could import lists from severalrnsources to Google Contacts, then rely on Scrubly to help me consolidate andrndelete duplicates. In the other case, I rely on Scrubly about once a year tornupdate contact information for my contacts from social networks. I like havingrncurrent photos and job contact information right in my contact list.

rnrnIn an ideal world, communication would be like Star Trek: we would simply speak a contact name and arncommunication channel would automatically open. In the meantime, I’ll rely onrnScrubly to clean up and update my Google Contacts with information from socialrnnetworks.

Image: Mark Kaelin/TechRepublic
  • Cloud
  • Account Information

    Share with Your Friends

    Screenshots: Use Scrubly to update Google Contacts

    Your email has been sent

Share: Screenshots: Use Scrubly to update Google Contacts
Image of Andy Wolber
By Andy Wolber
As a consultant, Andy helps nonprofit organizations understand and leverage technology. He taught the Nonprofit and Government Technology class for Grand Valley State University's Public Administration program for several years. His prior experience
  • Account Information

    Contact Andy Wolber

    Your message has been sent

  • |
  • See all of Andy's content

TechRepublic Premium

  • TechRepublic Premium

    OneDrive Cloud Usage Policy

    This OneDrive Cloud Usage Policy, courtesy of TechRepublic Premium, defines the practices and behaviors organization representatives must follow when using any Microsoft OneDrive cloud file storage account to execute organization services, process organization data, or access or store organization information. From the policy: No organization representative should ever install a personal OneDrive account on any ...

    Downloads
    Published:  October 1, 2023, 4:00 PM EDT Modified:  October 2, 2023, 9:00 AM EDT Read More See more TechRepublic Premium articles
  • TechRepublic Premium

    Hiring Kit: Video Game Designer

    One of the most common and most requested jobs listed by the video game industry is the job of video game designer. Depending on the company, the platform, the project and the company’s specific development process, the job of a video game designer can mean many different things. But at its base level, a game ...

    Published:  October 1, 2023, 4:00 PM EDT Modified:  October 2, 2023, 9:00 AM EDT Read More See more TechRepublic Premium articles
  • TechRepublic Premium

    Environmental Policy

    For businesses, sustainability means maintaining the ecological, economic and holistic well-being of present and future clients. This entails taking into account the demands and necessities of individuals and society without jeopardizing the growth or wellness of the generations that follow. As an accountable business entity, this policy from TechRepublic Premium defines the company’s commitment to ...

    Downloads
    Published:  October 1, 2023, 4:00 PM EDT Modified:  October 2, 2023, 8:58 AM EDT Read More See more TechRepublic Premium articles
  • TechRepublic Premium

    Best of Confluent Current 2023: The State of Data Streaming

    TechRepublic Premium was at Confluent’s Current 2023 event, held in San Jose, California, September 26-27. Our coverage of the event comprises an analysis of data streaming, interviews, the role of stream governance and a look at Apache Flink. From the download: Confluent used the Current 2023 ‘next generation of Kafka Summit’ event in San Jose ...

    Downloads
    Published:  September 27, 2023, 4:00 PM EDT Modified:  September 28, 2023, 1:00 PM EDT Read More See more TechRepublic Premium articles

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information
  • Careers

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2023 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice