# Send a batch of emails based on certain criteria

**URL:** <https://community.glideapps.com/t/send-a-batch-of-emails-based-on-certain-criteria/50206>\
**Category:** Ask for Help\
**Created:** [September 26, 2022, 2:14pm UTC](https://community.glideapps.com/t/send-a-batch-of-emails-based-on-certain-criteria/50206 "2022-09-26T14:14:27Z")\
**Posts on this page:** 1\
**Showing post:** 11

<div class="post-metadata">

**Author:** ![Gary\_Willmott](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_willmott/32/837_2.png) [@Gary\_Willmott](https://community.glideapps.com/u/Gary_Willmott)\
**Post date:** [September 27, 2022, 4:56pm UTC](https://community.glideapps.com/t/send-a-batch-of-emails-based-on-certain-criteria/50206/11 "2022-09-27T16:56:24Z")

</div>

Hey Darren, this is super helpful, going to try this once Make has survived their DDOS attach 🙈

The [mini tutorial on creating JSON is incredible](https://community.glideapps.com/t/send-data-using-api/49724/4)

However I don’t understand how I would only pull the values I need?  
I created a lookup to the column and it’s pulling all users, I only need the users that follow that location?

 ![Screenshot 2022-09-27 at 18.54.04](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/f/2f3abcb49861d3712e68e93ccc43c86f21f2d65a.jpeg)  
 ![Screenshot 2022-09-27 at 18.53.56](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/e/0ef938b63f15767b421107cc2df8d24f4cd82621.png)

---

_[View the full topic](https://community.glideapps.com/t/send-a-batch-of-emails-based-on-certain-criteria/50206)._