Sync your warehouse with Mattermost and push business metrics and user activity data to Mattermost in real-time
Overview
- Notify your customer success teams when product usage for a key account suddenly drops
- Notify an account executive when product usage surpasses a certain threshold
- Send a daily summary of the number of sign ups, compared to the same day last month
- Send a daily summary on the adoption of a core feature
Setup
- In Mattermost, click your icon in the top right and go to Profile to access your personal settings
- Click the Security tab in the modal that appears
- Click Personal Access Tokens and create the token
Sending Mattermost Messages (Added / Changed / Removed)
- You want to write a query, and have Hightouch detect the added and removed rows
- You want a custom message sent per each added and removed rows
Channel Selection

Added, Changed, and Removed Messages
- When a row is added in your query results, Hightouch will send the row added content.
- When a row is changed in your query results, Hightouch will send the row changed content.
- When a row is deleted in your query results, Hightouch will send the row deleted content.

Sending Mattermost Messages (All Results)
- You want to write a query, and have Hightouch push a message containing all rows, formatted as a message, to Mattermost
- You don't want Hightouch to detect added and removed rows, but instead want to send all rows on each query run
Channel Selection

Header, Body, and Footer Content

Templating Messages
Liquid Templating
User with name {{ row["name"] }} and email {{ row["email"] }} has signed up
Tagging Mattermost Users (@...)
- Tagging by username: tag by username by writing
<@{{ row["username"] }}>
where username is the column that contains the user's Mattermost username, just as using Liquid templating. If the username is a static value, you can write something like<@exampleuser>
. - Tagging by Email: tag by email by writing
<@{{ row["email"] | mattermost_user_lookup }}>
where email is the column that contains the user's email used in Mattermost. If the email is a static value, you can write something like<@{{ "example@gmail.com" | mattermost_user_lookup }}>
.
Unfurling Links and Blocking Unfurl
https://www.hightouch.com/
Table
- You want to write a query, and have Hightouch push a message containing all rows, formatted as a table, to Mattermost
- You don't want Hightouch to detect added and removed rows, but instead want to send all rows on each query run
Channel Selection

Using webhooks
Name | Description |
---|---|
Icon Image URL | URL of 48x48 image of the icon that you wish to use |
Icon Emoji | Mattermost emoji (e.g. :sweat_smile: ), this will overwrite icon image URL |
Bot Name | Display name of bot |
- Connection issues with your data warehouse?
- Confusing API responses from destination systems?
- Unsupported destination objects or modes?
- Help with complex SQL queries?
Need help?
Our team is relentlessly focused on your success. We're ready to jump on a call to help unblock you.
or
Feature Requests?
If you see something that's missing from our app, let us know and we'll work with you to build it!
We want to hear your suggestions for new sources, destinations, and other features that would help you activate your data.