📝

Email Lists

You can use a "List" generated from an existing block as part of your destination. This can be used for tasks like:

  • Sending an email to a set of users that meet certain criteria in your database or a Google Sheet
  • Triggering a Slack notification or
    Stories
    for each row of a SQL result
  • Assigning tasks or sending data driven messages to a group of internal customers / coworkers

💡
We're using the term "List Block" to refer to the block you're using to get your list and the term "Action Block" for the one that's going to "do something", e.g. send an email.

Demo

Email

  1. Select Email as the type and Use a block
  2. image
  3. Select the block from the drop down (you can search to filter the list)
  4. Add
    Parameters
    from the List Block into the Action Block using the same name as the column name in the List Block (keep the parameter type as the default "value"). Make sure there are no spaces in the column name, e.g. some_column
  5. select '{{email}}' as assigned_to, u.channel, u.plan, u.email as user_email
    from dummy.users as u
    where 1=1
    and u.channel = '{{channel}}'
  6. If you're using the "send to" email as a parameter in the query (e.g. {{email}}), you can set a default email which will send an "audit email" (e.g. so you know it ran). If you don't want this email, set the default to "NA". You can change this at any time.
  7. image
    image
  8. Run the block! Once it's complete, check your email for the reports.

💡
There is a 500 row limit on Destination Lists. If you need that limit removed, please contact us at contact@seekwell.io

Case Study

An apparel company wanted to email a sample of customers who abandoned their cart to three of their product managers daily. Each PM is responsible for a separate channel and should only see customers from their channel.