Search documentation...

K

Overview

With the SMTP Email destination, Hightouch can serve as a notifier for various changes. This is a very flexible integration, but here are a few example use cases:

  1. Notify your customer success teams when product usage for a key account suddenly drops
  2. Notify an account executive when product usage surpasses a certain threshold
  3. Send a daily summary of the number of sign ups, compared to the same day last month
  4. Send a daily summary on the adoption of a core feature

Sending Emails (Added / Changed / Removed)

Hightouch will not send any emails on the initial run to prevent a flood of emails to your channel. Emails will start after the this initial sync.

Hightouch supports sending emails based on rows that have been added, changed, or removed since the last sync run. Each row is sent as an individual email and can be sent to different channels and templated with Liquid.

Email formatting is best when the following conditions are met:

  1. You want to write a query, and have Hightouch detect the added and removed rows
  2. You want a custom email sent per each added and removed rows

Recipient Selection

Hightouch supports both sending emails to specific static recipients, or an email each row. Enable the "Use column" toggle in order to dynamically set the target email(s). Hightouch also supports CC and BCC so that multiple recipients can be included on the email chain.

The recipient, cc, and bcc sections all support a single email or a comma-separated list of emails

Added, Changed, and Removed Emails

Hightouch allows you to template the content you would like to send in your email.

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

This content can be templated.

Sending Emails (All Results)

The batch message mode is similar to the normal message mode, except it sends all rows in the query results rather than only added, changed, and removed rows since the last sync.

This mode also allows you to specify how many rows are sent per email, which can range from 1 to 20. With 1 row per email, it would be similar to the message mode, whereas 20 rows per email would be similar to a tabular representation.

This format is good for the following scenarios.

  1. You want to write a query, and have Hightouch send an email containing all rows
  2. You don't want Hightouch to detect added, changed, and removed rows, but instead want to send all rows on each query run

Recipient Selection

The batch message only supports sending your emails to a static email or list of emails. Hightouch also supports CC and BCC so that multiple recipients can be included on the email chain.

The recipient, cc, and bcc sections all support a single email or a comma-separated list of emails

Subject and Body Content

For each email, Hightouch allows setting the subject and row content. Only the row content is required. The row content is repeated per row in the email and has access to the row values via templating.

This content can be templated.

Templating Emails

Liquid Templating

For both the message and batch message modes, Liquid templating is supported. The most important implication of this is that columns from the added or removed row can be accessed as part of the message body. Here is an example message making use of Liquid to insert a column into the message.

User with name {{ row["name"] }} and email {{ row["email"] }} has signed up

Table

Table formatting sends all of your query results formatted as a text table. This mode is recommended only for small sets of data.

This format is good for the following scenarios.

  1. You want to write a query, and have Hightouch send an email containing all rows, formatted as a table
  2. You don't want Hightouch to detect added and removed rows, but instead want to send all rows on each query run

Recipient Selection

The batch message only supports sending your emails to a static email or list of emails. Hightouch also supports CC and BCC so that multiple recipients can be included on the email chain.

The recipient, cc, and bcc sections all support a single email or a comma-separated list of emails

    Need help?

    Our team is relentlessly focused on your success. We're ready to jump on a call to help unblock you.

    • Connection issues with your data warehouse?
    • Confusing API responses from destination systems?
    • Unsupported destination objects or modes?
    • Help with complex SQL queries?

    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.

On this page

OverviewSending Emails (Added / Changed / Removed)Recipient SelectionAdded, Changed, and Removed EmailsSending Emails (All Results)Recipient SelectionSubject and Body ContentTemplating EmailsLiquid TemplatingTableRecipient Selection

Was this page helpful?