Google Contacts

Google Sheets + Google Contacts Integration

Query from Google Contacts into Google Sheets or Post data from Google Sheets into Google Contacts or Synchronize data between Google Sheets & Google Contacts

What is Sheet Director?

Sheet Director is a Google Workspace add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho etc. 


It is available in the Google Workspace Marketplace. Please check the Installation instructions to install the add-on. 

What is Google Contacts?

Google Contacts is Google's contact management tool that is available in its free email service Gmail, as a standalone service, and as a part of Google's business-oriented suite of web apps Google Apps. 

Google Contacts to Google Sheets: Use Case(s)

> Pull the Google Contacts and present them in Google Sheet - Get Contacts

> Push data from Google Sheet to Google Contacts - Post Contacts

> Synchronize data between Google Sheets and Google Contacts - Synchronize

Google Contacts

Sheet Director

Google Sheets

Demo Video: How to integrate Google Sheets and Google Contacts?

Setting up Google Contacts into Sheet Director

Choosing App and Service:


Query - Google Contacts to Google Sheet

Google Contacts Configuration:

Destination Settings:

Scheduler Settings:

Notification Settings:

Sample Output:

The below image shows the data that is obtained from Google Contacts.

Post - Google Sheet to Google Contacts


Source Sheet

(the default value is A1, if you change the value you need to refresh the header by clicking on refresh icon on side)


Mapping

Sample Output

It will show the count of number of records posted successfully and failed to post.

Synchronize - Google Contacts and Google Sheets

Synchronize settings:

Synchronization Keys:

The keys will be used for matching rows in Google Sheet with data in Google Contacts.

Conflict Resolution: 

Google Contact Wins: Latest data from Google Contact will be updated into Google Sheet.

Sheet Wins: Latest data from Google Sheet will be updated into Google Contact.

Note: The major requirement in synchronization is the synchronize keys. If any of the keys is not having a value in the Google Sheet then Sheet Director will create it first and then the service will be executed.

Google Contact Wins


Sample Output

Sheet Wins

Sample Output