ABCDEFGHIJKLMNOPQRSTUVWX
1
Credits to :https://www.refractiv.co.uk/news/create-global-shared-contacts-google-apps-via-spreadsheet-sync/
2
Shared Address Book Settings
3
From the toolbar, you may select the action as follows:
- Domain Settings
- Upload
- Update
- Lists All
- Delete All
4
Domain SettingsSelect Shared Address Book >> Domain Settings
5
Upload All Contacts1. Edit Source, fill in the required information.
2. Select Shared Address Book >> Upload.
3. All data that selected with Upload action will be processed.

*For the first-time user, a dialog box appears that prompts the user for domain settings.
6
Update All Contacts1. Select Shared Address Book >> Update.
2. Updates all the actions from Source.

*For the first-time user, a dialog box appears that prompts the user for domain settings.
7
List All Shared ContactsSelect Shared Address Book >> List All.

*For the first-time user, a dialog box appears that prompts the user for domain settings.
8
Delete All Shared ContactsSelect Shared Address Book >> Delete All.

*For first-time user, a dialog box appears that prompts the user for domain settings.
9
Notes
10
Show Shared Address BookTo view shared contact information in Google Contacts:

Search 'directory settings' in the Google Contacts' search bar then select Directory Settings.

Contact Sharing
·Enable contact sharing.
·Check “Show all email addresses”.
·Check “Show both domain profile and domain shared contacts”.

External Directory Sharing
·Check “Domain and public data”.

Directory Visibility
·Check “All users”.

*Changes for Contacts Sharing may take up to 24 hours to take effect.
11
Functions
12
Domain SettingsSelect Shared Address Book >> Delete All.

*For the first-time user, a dialog box appears that prompts the user for domain settings.
13
Upload All ContactsFrom Source tab, retrieve and import all information to Google Shared Address Book.

*Spreadsheet can be internal (current Google Sheets) or external (other Google Sheets)
14
List All Shared ContactsList all information from Google Shared Address Book on Download tab.
15
Delete All Shared ContactsDelete all information from Google Shared Address Book.
16
Source
17
Fill in all the required nformation (spreadsheet can be internal or external)
18
SubjectEnter a subject to represent the Google Sheet.
19
Sheet IDFill in the details below (for external spreadsheet only)

-Sheet ID can be retrieved from Google Sheet's URL.
(Not required for internal spreadsheet)

E.g.
https://docs.google.com/spreadsheets/d/1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps/edit#gid=0

*The bold part will be the Sheet ID.

20
Sheet NameEnter the name of the sheet that contains the contact information.
21
Spreadsheet TitleAuto-generated by the system.

*To confirm the accuracy of data.
22
RowAuto-generated by the system.

*To show the total rows displayed.
23
ActionSelect upload or update to perform an action.
24
Status ColumnNot required
25
Ignore Entries WithNot required
26
First Name → Country/RegionComplete the required information.
27
Data Template
28
1. Reference for the Source tab.
2. Fill in the contact details for data import use (internal spreadsheet).
29
Download
30
Select List All to show all contacts that are listed in this spreadsheet.
31
UpdatedTo display last modified date.
32
IDAll contacts that are imported to Google Shared Address Book contain a unique identifier.
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100