This article covers how to import contacts with a Google Spreadsheet Connector. It is very important to format your Spreadsheet correctly or the integration will not work. Use the following Google Spreadsheet Template as a starting point.
Name your contacts file and put it in your desired location in Google Drive.
Do not change the names of the header columns
Format your US or Canada phone numbers in the following way (###) ###-####
If you have an international numbers you can foromat them +##########
Sync between Slack and Google Sheets is NOT instantaneous, it can take up to a few minutes for the contacts to appear.
Each contact can belong to multiple groups. Just separate them with a comma. For example (NYC, SF).
Make sure to select Comma-separated values (.csv) file type and Automatically republish when changes are made.
Copy the following URL as you will need it in the next step.
Connecting your google contacts to Clerk is easy. There are a few steps to set it up Launch out your Clerk menu by typing
/clerk and click on Integrations.
Re-connect if you already tried connecting your Google Sheets.
Paste the URL from the previous step.
*Note: If you are getting an error make sure that you have selected Comma-separated values (.csv) file type when publishing from Google Sheets.*
If you are still having issues pulling your contacts from a google sheet there are a few things that you can check:
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.