Slack
Turn analytics signals and insights into Slack alerts to help GTM teams identify opportunities, personalize outreach, and prevent churn. All without writing a single line of code.
In this guide, we will show you how to connect Slack to Census.
- Have your Census account ready. If you need one, start a free trial now (or take a look at our pricing for paid plans).
- Have your Slack account ready.
- Have the proper credentials to access to your data source. See our docs for each supported data source for further information.
In the Destinations page in Census, Click the New Destination button in the top right, and select Slack.
If you are not already logged in to Slack, you will be redirected to a page to log in to Slack to authorize your account to use Census. Once you are logged in, you'll see a page like the image below, confirming you want to authorize Census.
Once you've authorized Census, you'll be redirected back to the Destinations page in Census and you should see your Slack connection there.
Navigate to the Models page in Census and click the Add Model button.
Here you can a write SQL query to select the data you want to send to Slack.
Once you have created your model, give it a useful name, and click Save Model.
You'll need to start by specifying how to identify entries in your data warehouse that should trigger a Sync:
- For Source > Connection, select the data warehouse you connected in step 2.
- For Source > Source, select the model you created in step 3.
- For Destination > Connection, select Slack
- For Destination > Object, Message should be auto-selected
- Next, pick the column that uniquely identifies each record in your data source. Census will use this to identify new records that need to be used to send messages to Slack.
- Select the Slack channel you'd like to send messages to.
- Finally, use the text editor to customize the message that you wish to send.
- To embed values from the trigger columns or to mention users or channels from your Slack account, use the dropdown that will appear. If the list is long, try the search function.
- Click the Run Test button to see a single random record sent to your destination. For testing, you may want to temporarily change the destination message yourself.
- Click the Finish button and you'll be taken to your new notification. You can now Schedule the sync to run on a schedule or run it manually yourself.
Configure your new Notification to run on a set schedule or run it manually.
Reminder: Census will send records to a Slack channel one at a time.
Object Name | Supported? | Identifiers |
|---|---|---|
Message | ✅ | Custom message template. |
Census can send data to all public channels and any private channels that Census has been explicitly invited to (e.g.
/invite @census).Behaviors | Supported? | Objects |
Append | ✅ | channel |
Census will only write new records to a specific channel when new records appear in your data warehouse.
Last modified 1mo ago