This article covers how to import contacts with a Google Spreadsheet Connector. We've made the connection seamless and secure for the users.
Navigate to clerk Dashboard by typing
clerkand pressing Enter.
Click on the 📓 Contacts
Click on 📁 Import Contacts
Under Google Sheets click on Import
Authenticate with Google by selecting your account
Allow a secure access to a GSheet File
firstname: First Name
lastname: Last Name
phone: Phone Number
groups: cohorts of users (used in bulk sms)
Each contact can belong to multiple groups.
Just separate them with a comma. For example (NYC, SF).
Clerk uses a pull mechanism to sync the contacts from your existing data source with Slack. Once connected and contacts have been added to your google sheet you need to explicitly:
🔄 Re-Sync Contacts
Once completed you will get a notification message inside of your Slack channel.
You can access the created google sheet in two different ways.
Google Drive and open
Clerk Contacts google sheet.
Clerk Address Book
If you are still having issues pulling your contacts from a google sheet there are a few things that you can try:
Force re-sync your contacts from the Address Book modal.
Make sure that First & Last Name are both populated. If they are missing in your GSheet, Clerk will skip importing those contacts.
Due to the limitation of Slack search, we suggest limiting your group character size to 10 characters.
Slack search is not ideal. When searching for a contact or a group do it one character at a time.
If you are still having issues please reach out to our support team at [email protected]