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 for each row of a SQL resultStories
- 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
- Select Email as the type and Use a block
- Select the block from the drop down (you can search to filter the list)
- Add 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.Parameters
some_column
- 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. - Run the block! Once it's complete, check your email for the reports.
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}}'
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.