Contacts+ (formerly FullContact)

Google Sheets

Here's a request we get often at PieSync. 

> Can I use PieSync to sync contacts data from and to a [Google Sheets](https://www.piesync.com/googlesheets/)? 

![sheetsnotavailable](//images.ctfassets.net/f2ysq090txql/1f48Lv7tGKasEqgigcISUA/a35966a9121380d1ed7d8784f14776e9/sheetsnotavailable.gif)


It's an intriguing request because Google Sheets is no ordinary app. Yet, for many SMB's, it is often used as an important data source, and sometimes in fact acting as the main CRM. Here's the truth: a direct sync with Google Sheets through PieSync is not yet available - we're still working on that. 

But in this article I will propose a valid workaround.

## Why would you want to sync with Google Sheets?
A spreadsheet offers *great flexibility* to store contacts data. You are totally free to choose the structure in which you want to store your contacts data. Columns, rows, formula's... all up to you. Whether it is existing customers data, or newly obtained contacts... chances are you do find yourself often processing that data in a sheet. Some people like to call this *massaging*. 

The flexibility of a spreadsheet, however, becomes its greatest weakness when you consider Google Sheets as an app to start a 2-way sync with. [In the many apps that PieSync supports](https://www.piesync.com/connections), the common denominator is that they share a preset *contacts object* in their database. 

MaiChimp has subscribers. Hubspot has contacts. Salesforce has leads. Xero has customers. Whichever the app, it's a data object that comes with predictable names, emails, phone numbers,... This comes with the great advantage that PieSync has stored & mapped out the contacts schema for each and every app! This is what makes syncing any app to any other app possible through PieSync. 

![Screen Shot 2018-11-20 at 14.56.09](//images.ctfassets.net/f2ysq090txql/4WXKSgtmN2oyQEIasmCGOa/af982e65ca71d3057241f2a034669b7a/Screen_Shot_2018-11-20_at_14.56.09.png)

Google Sheets does not come with such a clear & predictable layout. In fact, it's quite the opposite. One sheet may have clearly titled columns "first name" "last name" and "email"... Another sheet may have completely different labels, or not come with any labels at all. Luckily, there still is a way to have Google Sheets sync with any of your favorite apps, and the solution is provided by our good friends over at [FullContact](https://www.fullcontact.com).  

## Sync your app with FullContact, which in turn syncs with a sheet

Unfamiliar with FullContact? It is a powerful contact management tool that I sometimes like to think of as Google Contacts on steroids. FullContact also offers an enrichment API for big datasets, but in this case you'll only need their [free web interface which also comes with handy iOS & Android apps](https://app.fullcontact.com/register). It's free limited to 1000 contacts and affordable if you go over.

![fullcontacintro](//images.ctfassets.net/f2ysq090txql/7daY0IlXuEm64aYYEkSk0I/a72ab266b7f69f8cb9e580696da5b60b/fullcontacintro.gif)

FullContact is a straightforward interface to store & process your personal & business contacts. Most interestingly, FullContact comes with a wide array of [integrations](https://www.fullcontact.com/integrations/app). One of those integrations is FullContact's ability to sync, 2-way (!), with a Google Sheets. And that's the workaround. If you want to sync [your app](https://www.piesync.com/connections) to a Google Sheets, sync it to FullContact instead. Then, in turn, have FullContact sync with Google Sheets and you've essentially set up a 2-way sync to Google Sheet in a controlled fashion.

![ezgif-4-c9834a84b16f](//images.ctfassets.net/f2ysq090txql/2kHg86UIfqoAgswiagg6Yu/45fab23b7cdebb7339e9a64d8009d218/ezgif-4-c9834a84b16f.gif)

If you have FullContact installed, [hop on over to their integrations page to install the Google Sheets plugin. ](https://www.fullcontact.com/integrations/fullcontact-google-sheets). The sync between FullContact & Google Sheet gives the possibility to bulk edit FullContact contacts inside a dedicated Google Sheets. Having a 2-way sync setup with that very same FullContact account essentially makes those changes sync all the way through.

![fulcontactinsheet](//images.ctfassets.net/f2ysq090txql/63HNOq0r1CKCa06M0AEcI4/cfebfb281457d6f7c8f2104649226c55/fulcontactinsheet.gif)

![sync](//images.ctfassets.net/f2ysq090txql/6BnDH0a3MA68WC4CoQgkOm/bc948c0c63cb9c4e96d37eb340cad2e9/sync.gif)

One thing to note though is that you do need to have your contacts data properly formatted inside the layout of FullContact's templated sheet. However, with a little bit of spreadsheet magic you can go a long way. Linking cells on external sheets or workbooks, concatenating cells, ... The FullContact sheet acts as a simple communication bridge inside your Google Sheets environment, to make whatever source data you have sync directly with contacts in your other apps. 

![finalresult](//images.ctfassets.net/f2ysq090txql/5j4sVklW7mi2kuusgeeGUO/69c0f66052bd8c17cd395d3bbf8523ff/finalresult.gif)

Is your app available to sync with FullContact? Then it is available to sync with Google Sheets too. 
<Widget type="piesync-widget" left="fullcontact" size="compact" />




A spreadsheet offers great flexibility to store contacts data. You are totally free to choose the structure in which you want to store your contacts data. Columns, rows, formula's... all up to you. However, this flexibility becomes its greatest weakness...

Syncing contacts data with Google Sheets

Google sheets is a cloud-based productivity tool for creating and managing spreadsheets. Designed to create, modify, and share spreadsheets in real-time. Pre-made templates, chatting and commenting are available.

Goolge Sheets

Supported Apps

GETTING STARTED GUIDE : How to set up a new connection?. ALL FEATURES EXPLAINED : All our features/functionality explained in detail - no app-specifics.. Google Contacts is an easy-to-use (free) cont…

Google Contacts

Popular sync combinations

HubSpot is the marketer's number one inbound marketing tool. Your phone’s address book however runs on a different cloud. Google Contacts for instance. To get these 2 apps to talk to one another, the…

Google Contacts & HubSpot

In the PieSync dashboard, choose Google Contacts and FollowUpBoss. Authorize your apps.. FollowUpBoss requires an "API Key" to be authorized. You can find this key in FollowUpBoss when you go to your…

FollowUpBoss and Google Contacts

Google Contacts is the easy-to-use (free) contact management tool that is part of the Google Apps Suite. While its web interface (contacts.google.com) is less known, it’s the fact that smartphones na…

Google Contacts and Copper

Podio helps create long-lasting relationships with your customers as a CRM it forms a complete up-to-date database of all the leads and contacts of your company. The source of truth. Your phone’s add…

Google Contacts and Podio

Want to learn more?

By default, an iPhone will store contacts on iCloud, or, if you've opted out from iCloud, it will store them locally on your phone. How do you get these contacts synced up to other services? It all d…

Setting up your iPhone to sync with Google Contacts

Setup Guide

ADDITIONALLY SYNC YOUR CONTACTS TO 'MY CONTACTS'. When you have a connection setup with Google Contacts, you can additionally sync your contacts to the Google Contacts group 'My Contacts’. This featu…

My Contacts

Learn more by reading our Free E-books ! . The ultimate guide to contact management. Beginner's guide to CRM. The ultimate guide to Google Contacts. The ultimate guide to Outlook people. PieSync guid…

Check out our Free E-Books!

GETTING STARTED GUIDE : How to set up a new connection?. ALL FEATURES EXPLAINED : All our features/functionality explained in detail - no app-specifics.. Clarabridge Engage (formerly CX Social) is a…

Clarabridge Engage (CX Social)

A connection is any pair of apps you link up to sync contact data. A connection may sync contacts 2-way or 1-way. Some important side notes: As you need to allow PieSync to sync across your contact d…

What is a connection?

1CRM-logo-box

1CRM Cloud

AT & T

AT&T Office@Hand

aweber

AWeber

act!

Act! 365

actpremium

Act! Premium Cloud

activecampaign

ActiveCampaign

activedemand

ActiveDEMAND

activetrail-1502192111-logo

ActiveTrail

Acumatica

Acumatica CRM

agendor_logo

Agendor

agilecrm

Agile CRM

aircall-icon@2x (1)

Aircall

allclients

AllClients

apptivo

Apptivo

aproplan

Aproplan

autopilot

Autopilot

btcloudphone

BT Cloud Phone

batchbook

Batchbook

benchmark

Benchmark

bigcommerce

BigCommerce

bigcontacts

BigContacts

bitrix

Bitrix24 CRM

bombbomb

BombBomb

bookeo

Bookeo

boomtown

BoomTown

bpmonline

Bpm'online

Brivity CRM

bullhorn

Bullhorn

campaignmonitor

Campaign Monitor

campaigner

Campaigner

capsulecrm

Capsule

chargebee

Chargebee

logo-cin7

Cin7

cxsocial

Clarabridge Engage

Classy-icon-coral

Classy

clio

Clio

companyHub

CompanyHub

connectwisemanage

ConnectWise Manage

constantcontact

Constant Contact

Contactlab Marketing Cloud

Contacts+ Logo Mark (1)

contactually

Contactually

Copper-icon-circle-pink

Copper

Crisp

currentrms

Current RMS

datavalidation

DataValidation

daylite

Daylite

d-logo-L-transparent

Debitoor

Delivra

desk

Desk

logo-digitaleo

Digitaleo

directmailmac

Direct Mail for Mac

dotloop

Dotloop

Drift Logo

Drift

drip

Drip

ERPNext logo

ERPNext

eztexting

EZ Texting

easybill

EasyBill

efficycrm

Efficy CRM

Elastic Email

emma

Emma

espocrm

EspoCRM

eventbrite 2018

Eventbrite

facebook-lead-ads

Facebook Lead Ads

facten

Facten

fastbill

FastBill

finfolio

FinFolio

flexmail

Flexmail

followupboss

Follow Up Boss

freeagent

FreeAgent

freshbooks

FreshBooks

FreshBooks Classic

freshdesk icon sf

Freshdesk

freshsales

Freshsales

front

Front

funnelflare

FunnelFLARE

getresponse

GetResponse

Gist (formerly ConvertFox)

google contacts logo

GreenRope

g-invert-box-hires-01

Greenhouse

groove

Groove

blog hd blog icoon

HelloDialog

helpscout

Help Scout

highrise

Highrise

hubspot logo

HubSpot

HubSpot Marketing Hub

HubSpot Service Hub

infusionsoft_by_keap_logo

Infusionsoft by Keap

insightly

Insightly

intercom

Intercom

Syncing Google Sheets is currently on our roadmap.

Start syncing Google Sheets with one of our 198 apps

Accurate & real-time data

Save time

Easy & Secure

Free Trial

Help Articles related to syncing Google Sheets