LogoLogo
  • 🦩Overview
  • 💾Datasets
    • Overview
    • Core Concepts
      • Columns & Annotations
      • Type & Property Mappings
      • Relationships
    • Basic Datasets
      • dbt Integration
      • Sigma Integration
      • Looker Integration
    • SaaS Datasets
    • CSV Datasets
    • Streaming Datasets
    • Entity Resolution
    • AI Columns
      • AI Prompts Recipe Book
    • Enrichment Columns
      • Quick Start
      • HTTP Request Enrichments
    • Computed Columns
    • Version Control
  • 📫Syncs
    • Overview
    • Triggering & Scheduling
    • Retry Handling
    • Live Syncs
    • Audience Syncs
    • Observability
      • Current Sync Run Overview
      • Sync History
      • Sync Tracking
      • API Inspector
      • Sync Alerts
      • Observability Lake
      • Datadog Integration
      • Warehouse Writeback
      • Sync Lifecycle Webhooks
      • Sync Dry Runs
    • Structuring Data
      • Liquid Templates
      • Event Syncs
      • Arrays and Nested Objects
  • 👥Audience Hub
    • Overview
    • Creating Segments
      • Segment Priorities
      • Warehouse-Managed Audiences
    • Experiments and Analysis
      • Audience Match Rates
    • Activating Segments
    • Calculated Columns
    • Data Preparation
      • Profile Explorer
      • Exclusion Lists
  • 🧮Data Sources
    • Overview
    • Available Sources
      • Amazon Athena
      • Amazon Redshift
      • Amazon S3
      • Azure Synapse
      • ClickHouse
      • Confluent Cloud
      • Databricks
      • Elasticsearch
      • Kafka
      • Google AlloyDB
      • Google BigQuery
      • Google Cloud SQL for PostgreSQL
      • Google Pub/Sub
      • Google Sheets
      • Greenplum
      • HTTP Request
      • HubSpot
      • Materialize
      • Microsoft Fabric
      • MotherDuck
      • MySQL
      • PostgreSQL
      • Rockset
      • Salesforce
      • SingleStore
      • Snowflake
      • SQL Server
      • Trino
  • 🛫Destinations
    • Overview
    • Available Destinations
      • Accredible
      • ActiveCampaign
      • Adobe Target
      • Aha
      • Airship
      • Airtable
      • Algolia
      • Amazon Ads DSP (AMC)
      • Amazon DynamoDB
      • Amazon EventBridge
      • Amazon Pinpoint
      • Amazon Redshift
      • Amazon S3
      • Amplitude
      • Anaplan
      • Antavo
      • Appcues
      • Apollo
      • Asana
      • AskNicely
      • Attentive
      • Attio
      • Autopilot Journeys
      • Azure Blob Storage
      • Box
      • Bloomreach
      • Blackhawk
      • Braze
      • Brevo (formerly Sendinblue)
      • Campaign Monitor
      • Canny
      • Channable
      • Chargebee
      • Chargify
      • ChartMogul
      • ChatGPT Retrieval Plugin
      • Chattermill
      • ChurnZero
      • CJ Affiliate
      • CleverTap
      • ClickUp
      • Constant Contact
      • Courier
      • Criteo
      • Crowd.dev
      • Customer.io
      • Databricks
      • Delighted
      • Discord
      • Drift
      • Drip
      • Eagle Eye
      • Emarsys
      • Enterpret
      • Elasticsearch
      • Facebook Ads
      • Facebook Product Catalog
      • Freshdesk
      • Freshsales
      • Front
      • FullStory
      • Gainsight
      • GitHub
      • GitLab
      • Gladly
      • Google Ads
        • Customer Match Lists (Audiences)
        • Offline Conversions
      • Google AlloyDB
      • Google Analytics 4
      • Google BigQuery
      • Google Campaign Manager 360
      • Google Cloud Storage
      • Google Datastore
      • Google Display & Video 360
      • Google Drive
      • Google Search Ads 360
      • Google Sheets
      • Heap.io
      • Help Scout
      • HTTP Request
      • HubSpot
      • Impact
      • Insider
      • Insightly
      • Intercom
      • Iterable
      • Jira
      • Kafka
      • Kevel
      • Klaviyo
      • Kustomer
      • Labelbox
      • LaunchDarkly
      • LinkedIn
      • LiveIntent
      • Loops
      • Mailchimp
      • Mailchimp Transactional (Mandrill)
      • Mailgun
      • Marketo
      • Meilisearch
      • Microsoft Advertising
      • Microsoft Dynamics
      • Microsoft SQL Server
      • Microsoft Teams
      • Mixpanel
      • MoEngage
      • Mongo DB
      • mParticle
      • MySQL
      • NetSuite
      • Notion
      • OneSignal
      • Optimizely
      • Oracle Database
      • Oracle Eloqua
      • Oracle Fusion
      • Oracle Responsys
      • Orbit
      • Ortto
      • Outreach
      • Pardot
      • Partnerstack
      • Pendo
      • Pinterest
      • Pipedrive
      • Planhat
      • PostgreSQL
      • PostHog
      • Postscript
      • Productboard
      • Qualtrics
      • Radar
      • Reddit Ads
      • Rokt
      • RollWorks
      • Sailthru
      • Salesforce
      • Salesforce Commerce Cloud
      • Salesforce Marketing Cloud
      • Salesloft
      • Segment
      • SendGrid
      • Sense
      • SFTP
      • Shopify
      • Singular
      • Slack
      • Snapchat
      • Snowflake
      • Split
      • Sprig
      • Stripe
      • The Trade Desk
      • TikTok
      • Totango
      • Userflow
      • Userpilot
      • Vero Cloud
      • Vitally
      • Webhooks
      • Webflow
      • X Ads (formerly Twitter Ads)
      • Yahoo Ads (DSP)
      • Zendesk
      • Zoho CRM
      • Zuora
    • Custom & Partner Destinations
  • 📎Misc
    • Credits
    • Census Embedded
    • Data Storage
      • Census Store
        • Query Census Store from Snowflake
      • General Object Storage
      • Bring Your Own Bucket
        • Bring your own S3 Bucket
        • Bring your own GCS Bucket
        • Bring your own Azure Bucket
    • Developers
      • GitLink
      • Dataset API
      • Custom Destination API
      • Management API
    • Security & Privacy
      • Login & SSO Settings
      • Workspaces
      • Role-based Access Controls
      • Network Access Controls
      • SIEM Log Forwarding
      • Secure Storage of Customer Credentials
      • Digital Markets Act (DMA) Consent for Ad Platforms
    • Health and Usage Reporting
      • Workspace Homepage
      • Product Usage Dashboard
      • Observability Toolkit
      • Alerts
    • FAQs
Powered by GitBook
On this page
  • Getting Started
  • 📋 Prerequisites
  • 1️⃣ Connect Census to Slack
  • 2️⃣ Connect Census to your data source
  • 3️⃣ Create your first Census dataset
  • 4️⃣ Create your Census Sync
  • 🎚 Setup your Source, Destination, and Sync Key
  • 💬 Setup your Message
  • 🧪 Test your Slack message
  • ☑️ Finishing touches
  • Dynamic User Mentions
  • Hyperlinks
  • ️ Supported Objects and Sync Behaviors
  • Need help connecting to Slack?

Was this helpful?

  1. Destinations
  2. Available Destinations

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.

PreviousSingularNextSnapchat

Last updated 2 months ago

Was this helpful?

Getting Started

‌In this guide, we will show you how to connect Slack to Census.

📋 Prerequisites

  • Have your Census account ready. If you need one, (or take a look at our ).

  • Have your Slack account ready.

  • Have the proper credentials to access to your data source. See our for each supported data source for further information.

1️⃣ Connect Census to Slack

In the 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.

2️⃣ Connect Census to your data source

3️⃣ Create your first Census dataset

Navigate to the Dataset page in Census and click the Add Dataset button.

Here you can a write SQL query to select the data you want to send to Slack.

Once you have created your dataset, give it a useful name, and click Save Dataset.

4️⃣ Create your Census Sync

🎚 Setup your Source, Destination, and Sync Key

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 dataset 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.

💬 Setup your Message

  • 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.

🧪 Test your Slack message

  • 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.

☑️ Finishing touches

  • 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.

Reminder: Census will send records to a Slack channel one at a time.

Dynamic User Mentions

The Member ID can be used to mention specific channel members in a Slack message.

Example:

select '<@U012345>' as USER_MENTION_1
        ,'@U012345' as USER_MENTION_2

Hyperlinks

To add hyperlinks there are a couple of ways to include them based on your goal.

  • If you have a static list that won't be changing from record to record the template editor supports highlighting the text you want linked and copy and pasting the link to automatically hyperlink.

  • If you want dynamic hyperlinks that vary based on the record you can create a column within your source data formatted like the below and reference the hyperlink column in your message template.

SELECT '<http://example.com/test | Text to display>' as hyperlink

️ Supported Objects and Sync Behaviors

Object Name

Supported?

Identifiers

Behaviors

Message

✅

Custom message template.

Send

Census can send data to all public channels and any private channels that Census has been explicitly invited to (e.g. /invite @census).

Census will only write new records to a specific channel when new records appear in your data warehouse.

Need help connecting to Slack?

See our for each supported data source for further information.

Navigate to the page in Census and click the New Sync button.

Learn more about all of our sync behaviors in our documentation.

if you want Census to support more Slack objects and/or behaviors.

via support@getcensus.com or start a conversation with us via the chat.

If you have questions about our privacy policy, you can check it out .

🛫
docs
Syncs
Syncs
Contact us
Contact us
in-app
here
start a free trial now
pricing for paid plans
docs
Destinations
Configure your new Notification to run on a set schedule or run it manually.
User Mention Example
View in message template editor
Slack message output