Sync Your Google Contacts With Google Sheets
Listing updated:December 26, 2023
Works with:
Administrate your Google Contacts like never before:
1) Download your Google Contacts to Google Sheets (on a daily basis)
2) Modify contacts information 
3) Upload contacts directly from Google Sheets (on a daily basis)

Currently available contact fields to read and write:
"Gender" (female, other, male),
"Prefix", "First Name", "Middle Name", "Last Name", "Full Name", "Suffix", "Nickname",
"Birthday ReadOnly",
"Address Home", "Address Work", "Address NoLabel",
"Email Home", "Email Work", "Email NoLabel",
"Website Home", "Website Work", "Website NoLabel",
"Phone Main", "Phone Home", "Phone Work", "Phone Mobile", "Phone NoLabel",
"Company", "Job Title", 
"Profile Picture ReadOnly"
"Contacts Link ReadOnly"

If you want to see all emails, companies, etc. use the „ReadOnly“ fields. Currently available:
"Addresses ReadOnly"
"Emails ReadOnly"
"Websites ReadOnly"
"Phones ReadOnly"
"Groups ReadOnly"
"Last Updated ReadOnly"

In case you see not all options, perform function 1) Create|Check Sheet

If you want to sync all of your contacts, create a label „SyncContactsAll“

To sync selected individual contacts only, create a label „SyncContacts_X“.
X equals your SyncContacts spreadsheet number. You can check it at function "2) General Information".
This way, only contacts with this label will be down-/uploaded from/to this specific Google Sheet.

After uploading contacts, it is essential to refresh your browser tab in order to visualize the changes.It is only possible to up-/download the first item of each category of contact fields -> first in the field  Email Home, first in the field Company, etc.

Sync Contacts does not delete any contacts, it only updates them. 
When a field is completely empty, no changes at the contacts field will be made. 
In order to remove a single field at a specific contact, enter phrase:
Attention: When multiple field values exist (e.g. two NoLabel mobile phone numbers) each time when DELETE NEXT UPLOAD is uploaded, the next field value will be deleted (e.g. 2nd NoLabel mobile phone number). Hence, we recommend to perform a download after deleting fields.

The only limit for down- /uploading contacts is your maximum computation time, which is 360 seconds for standard GMail users. 
Within this time you can download approximately 15000 contacts, upload 15000 and create 250 new contacts. 

GOOGLE QUOTA: There is a daily limit to the number of contacts you can CREATE: 1000 per day maximum. 

All our Add-ons are free of charge with full functionality. 
We do have upgrading options though.
For Sync Contacts you can increase the amount contact fields.
Just get in contact with us for more details.

Submit your EMail address at:
Enter Promotion Keyword: SyncContacts
Instantly receive a Lisence Key to process 15 contact fields

*This promotion is valid for a limited time only

#Contacts #Sync #Upload #Download #Bulk #Daily #Automatically #CRM #Sheets #MaintainApp
Additional information
PricingFree of charge
Privacy policy
Terms of service
Sync Contacts will ask for the permissions shown below. Learn more
Sync Contacts will need access to your Google account
This will allow Sync Contacts to :
See, edit, create, and delete all your Google Sheets spreadsheets
View and manage spreadsheets that this application has been installed in
See, edit, download, and permanently delete your contacts
See, edit, download, and permanently delete your contacts
See and download contact info automatically saved in your "Other contacts"
Display and run third-party web content in prompts and sidebars inside Google applications
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Associate you with your personal info on Google
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Humayon Qaiser
May 19, 2024
where is the license key? I cant add my phone numbers in the sheet. I am facing trouble with that.
Is this review helpful?
Profile Picture
Atik ullah Ashik
October 10, 2022
Is this review helpful?
Profile Picture
Michael Volz
March 14, 2022
*update: they fixed the error and got a hold of me. Very helpful and now it works! error everytime I try to upload contacts.
Is this review helpful?
Profile Picture
Mathew Steveson
June 14, 2021
Works really well and the support team has been magnificent when I had a question. Thanks for such a great add-in
Is this review helpful?
Profile Picture
Inter Partner
December 10, 2022
How to get the Licence Key to Add Fields?
Is this review helpful?
Profile Picture
Ahmad Mujtaba
July 6, 2021
Is this review helpful?
1-6 of 6
Clear search
Close search
Google apps
Main menu