help guide 

123 Toolkit for Domain contacts

Description of 123 Toolkit for Domain contacts

When to use it

Use the Google Spreadsheet™ add-on '123 Toolkit for Domain contacts' to get a list of your Domain shared contacts from the Google Directory into your Google Spreadsheet™. The add-on ensures that you have a list in the spreadsheet that you can sort / compare or filter device data when you need so. You can also perform (bulk) actions on the domain contact profiles

Some example use case; the  spreadsheet with the list can be used to:

New to 'Shared external contacts' in the Google Directory? See the Google Workspace admin help page: https://support.google.com/a/answer/9281635. More interested in the API documentation, see Google Developers help: https://developers.google.com/admin-sdk/domain-shared-contacts.

How it works

1 - Download Shared Contact

Click the button 'List contacts' to get your current Google domain shared contacts from your Google Directory into your spreadsheet. You need to be a Google Super administrator in your Google domain. 


Note: when you start with this add-on you likely have no Shared contact data in your domain. That is completely normal. You will get a message about this.

2 - Save Shared Contacts

Screenshot with data

3 - Insights

Add the sheet 'Insights' to get a dashboard on your domain shared contact data.

Requirements

Good to know:

< SCREENSHOTShows the selection in Google Admin console for Google Contacts to ensure users can find the Domain shared contact profiles in the Google Contact directory

Installation

How to add the Google Workspace extension '123 Toolkit for Domain contacts' to your spreadsheet?

Option 1: Installation from the spreadsheet

Option 2: Installation from the Google Workspace marketplace

Go to the Google Workspace marketplace: https://workspace.google.com/marketplace

FAQ - Frequently Asked Questions

Do I need to be a Google Admin

Is there a check on duplicates before adding a new contact entry to the Directory?

Any spreadsheet row that you will have "Add" in the action column will be added to the Google Directory. Even empty rows, or double contacts. There is no check on this.

To ensure that this doesn't happen follow the following steps:

Is there a product roadmap available?

Is there a version history overview?

I get the error 'The data you entered in cell I? violates the data validation rules set on this cell.'

Issue description: When you try to download all your shared domain contacts to your spreadsheet, you get the error "Error: The data you entered in cell I123 violates the data validation rules set on this cell.". The error is due to an email address in your contacts which are not recognized by Google. 

How to fix this: Select the 2 columns with email address, remove the data validation in those columns. See Google help (https://support.google.com/docs/answer/186103) for data validation functionality.

Is it possible to use the 'Contact' sheet in 2 or more Google Workspace domains?

To sync contacts to multiple Google Workspace domains (domain1.com and domain2.com), you need to follow the following approach: