How it works?
Import - Create - Update - Delete Google Contacts from Google Sheets™
Install the Sheet2Contact
Click here and install Sheet2Contact
OR
Go to Google sheet > open your Spreadsheet,
Go to Extension menu> Add-On> Get add-On
Search "Sheet2Contact" and install the add-on
Enable Sheet2Contact
Go to Extension > Sheet2Contact> Refresh
This is to enable this add-on for that sheet
Note: If only help menu is showing then just refresh the sheet and if that not worked then Email us
Import Google Contacts™ to Google Sheet™
Got to Sheet2Contact Menu and Click 👉 Sync with Google Contact™
Which this All the data from your Google Contacts will comes to this sheet in related columns. If more than 1 data in same field then they are joined by "|".
Note:
Don’t rename the headers of the columns.
"Contact ID", "Last Update" and "Status" Columns will be updated automatically. So please don’t enter anything in that column.
Now you have all contact data in sheet. You can...
Edit Existing Contact
To edit details of existing contact, just go to respective row and edit in that cell.
Create New Contact
To create a new contact, add data to a new row in the relevant columns. Make sure no value in "Contact ID" column of that row.
Delete Existing Contact
To Delete a Existing contact then choose 'Yes' in the 'Want to Delete?' column. Make sure in "Contact ID" column of that row not empty.
Sync the changes
Once you're done editing, it's time to sync your sheet with your Google Contacts.
Got to Sheet2Contact Menu and Click 👉 "Sync with Google Contact"
and Your changes will be synced with Google Contact
After this, don't forget to re-import your contacts using the 'Import Contact from Google Contact'.
This final step ensures that all your changes in the sheet are correctly synced with your Google Contacts.
🙏 Now, It's Your Turn 🙏
It would be greatly appreciated if you could share your experience with the add-on, such as its ease of use, speed, and accuracy.
⭐ ⭐ ⭐ ⭐ ⭐