Seamlessly Transfer Contacts from Google Sheets to Google Contacts

Description

Looking for code that syncs contacts and labels in Google Sheets with Google Contacts. Reference attachment (Excel version of Google Sheets) regarding the below requirements.

1. When an email address is added to the Google Sheets tab "Contacts" then a Google Contact is created with the accompanying information in the rest of the green highlighted headers (e.g. Company Name, Phone Number, etc.).
2. The yellow headers of the Contacts tab are the labels. When text is added to a yellow header, a label is created. If the text changes, then the old label is deleted and a new label is created.
3. Contacts are labeled in accordance with whether there is a "Yes" in the respective yellow label header column. Changes to or from "Yes" add or remove the label from the contact.
4. Edits to the information in the green columns do not create duplicate contacts. So it either edits existing contacts or deletes the old one and creates a new one.
5. When an email address is first input into a row, a time-date stamp goes into the "Date Contact Added" column and this does not change.
6. In addition to the onEdit trigger, also a manual trigger in a menu drop down.

Works with Apps

Google Sheets Google Contacts

From Ashton

Utilizing Google Apps Script, this project automates the synchronization process between Google Sheets and Google Contacts, effortlessly transferring contacts from the former to the latter. This ingenious integration ensures that your contacts are continuously updated and seamlessly accessible across both platforms.

Hire Me on Upwork

From Client

Ashton is amazing. He delivered where others could not. Easy to work with and a great work product. He's at the top of my list to rehire.

Google Apps Script Projects Shared On YouTube

Links

Work with Me on Upwork YouTube Twitter / X Automate The Boring (Blog)