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

<aside> 💡 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.

</aside>

Demo

https://www.youtube.com/watch?v=yNzQMcRgF3M

Email

Select Email as the type and Use a block
Select the block from the drop down (you can search to filter the list)
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
```
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}}'
```
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.

<aside> 💡 There is a 500 row limit on Destination Lists. If you need that limit removed, please contact us at [email protected]

</aside>

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.