# Send email to filtered users **URL:** \ **Category:** Ask for Help\ **Created:** [December 1, 2022, 12:11am UTC](https://community.glideapps.com/t/send-email-to-filtered-users/55270 "2022-12-01T00:11:51Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![liam\_putra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/liam_putra/32/46372_2.png) [@liam\_putra](https://community.glideapps.com/u/liam_putra)\ **Post date:** [December 1, 2022, 12:11am UTC](https://community.glideapps.com/t/send-email-to-filtered-users/55270/1 "2022-12-01T00:11:51Z")
So i’ve built a way to multi filter my users based on their age and location. Now what i want to do is to send those filtered users an email. I already know how to use zapier, make etc. I just need to get those filtered user’s email. How do i do this ? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 1, 2022, 12:19am UTC](https://community.glideapps.com/t/send-email-to-filtered-users/55270/2 "2022-12-01T00:19:04Z")
use google script… is faster and free, join the filtered emails, and set a trigger column with that joined list… then have an onChange trigger to run the script… script will split that value, and send emails ---
**Author:** ![liam\_putra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/liam_putra/32/46372_2.png) [@liam\_putra](https://community.glideapps.com/u/liam_putra)\ **Post date:** [December 1, 2022, 12:23am UTC](https://community.glideapps.com/t/send-email-to-filtered-users/55270/3 "2022-12-01T00:23:19Z")
My problem right now is that the filtered list is only shown on the UI, how do i extract those values ? with traditional programming, we can filter those list on the client side and push them into an array. But with glide i do not know how to do this. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 1, 2022, 12:25am UTC](https://community.glideapps.com/t/send-email-to-filtered-users/55270/4 "2022-12-01T00:25:45Z")
use Glide table editor, if-else columns, to filter users, and then join column to join the filtered values ---
**Author:** ![liam\_putra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/liam_putra/32/46372_2.png) [@liam\_putra](https://community.glideapps.com/u/liam_putra)\ **Post date:** [December 1, 2022, 12:29am UTC](https://community.glideapps.com/t/send-email-to-filtered-users/55270/5 "2022-12-01T00:29:01Z")
okay, so i have users table and i should create a column lets say “selected users” with if-else type. when i run the filter → i need to find a way to make the “selected users” column checked ? if yes → how do we automatically check those filtered users ? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 1, 2022, 12:31am UTC](https://community.glideapps.com/t/send-email-to-filtered-users/55270/6 "2022-12-01T00:31:20Z")
no, you don’t check users… example: if user age is greater than 18 show user email for multiple conditions use multiple if else columns but this time instead of showing the user email… show 1 then use math column to add results… if sum equal number of filters then show user email ---
**Author:** ![liam\_putra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/liam_putra/32/46372_2.png) [@liam\_putra](https://community.glideapps.com/u/liam_putra)\ **Post date:** [December 1, 2022, 12:34am UTC](https://community.glideapps.com/t/send-email-to-filtered-users/55270/7 "2022-12-01T00:34:47Z")
i understand how to show the user email on the UI, but how do i send emails to those users that are greater than 18 ? i need to get only those users data and trigger a webhook → then use zapier to send email from those emails ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 1, 2022, 12:35am UTC](https://community.glideapps.com/t/send-email-to-filtered-users/55270/8 "2022-12-01T00:35:54Z")
are you using google sheets? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 1, 2022, 12:37am UTC](https://community.glideapps.com/t/send-email-to-filtered-users/55270/9 "2022-12-01T00:37:28Z")
Put your conditional logic in the table with an IF column. Not a filter. Then you can create a Joined List column to merge all emails into a single column that you can pass with a webhook. ---
**Author:** ![liam\_putra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/liam_putra/32/46372_2.png) [@liam\_putra](https://community.glideapps.com/u/liam_putra)\ **Post date:** [December 1, 2022, 12:39am UTC](https://community.glideapps.com/t/send-email-to-filtered-users/55270/10 "2022-12-01T00:39:14Z")
No, i use only glide tables. i’ll come back in a few minutes with a loom video to show what i mean ---
**Author:** ![liam\_putra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/liam_putra/32/46372_2.png) [@liam\_putra](https://community.glideapps.com/u/liam_putra)\ **Post date:** [December 1, 2022, 12:39am UTC](https://community.glideapps.com/t/send-email-to-filtered-users/55270/11 "2022-12-01T00:39:32Z")
let me try and come back ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 1, 2022, 12:41am UTC](https://community.glideapps.com/t/send-email-to-filtered-users/55270/12 "2022-12-01T00:41:09Z")
if you don’t have google sheets connected (BIG mistake!), then you need to create a webhook like @Jeff_Hager said ---
**Author:** ![liam\_putra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/liam_putra/32/46372_2.png) [@liam\_putra](https://community.glideapps.com/u/liam_putra)\ **Post date:** [December 1, 2022, 12:45am UTC](https://community.glideapps.com/t/send-email-to-filtered-users/55270/13 "2022-12-01T00:45:43Z")
Do you have a sample app that you can share regarding this issue uzo ? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 1, 2022, 12:50am UTC](https://community.glideapps.com/t/send-email-to-filtered-users/55270/14 "2022-12-01T00:50:44Z")
yes… many of them 😉 > **[Templates Market - ready to use app templates, with google scripts and CSS codes](https://templates-market-sa.glideapp.io/full)** > > ready to use templates, with google scripts and CSS codes ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 1, 2022, 12:53am UTC](https://community.glideapps.com/t/send-email-to-filtered-users/55270/15 "2022-12-01T00:53:25Z")
I can write specific codes for your issue… > **[Schedule Paid Appointment](https://schedule-appointment.glideapp.io/dl/6471c6)** > > Schedule paid appointments, for Google Meet, get calendar reminders, block booked dates and time slots, auto adjust duration to the booked time slots, custom stripe checkout