# How to send email to a list of user using Zapier in Glide? **URL:** \ **Category:** Ask for Help\ **Created:** [March 6, 2020, 5:51pm UTC](https://community.glideapps.com/t/how-to-send-email-to-a-list-of-user-using-zapier-in-glide/5247 "2020-03-06T17:51:35Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![DAG](https://avatars.discourse-cdn.com/v4/letter/d/6f9a4e/32.png) [@DAG](https://community.glideapps.com/u/DAG)\ **Post date:** [March 6, 2020, 5:51pm UTC](https://community.glideapps.com/t/how-to-send-email-to-a-list-of-user-using-zapier-in-glide/5247/1 "2020-03-06T17:51:36Z")
Hello, I would like to send an email to a list of users. They are displayed as a list in the Data. I wanted to use Zapier to fill the Value 1 with the list of the email addresses. But the list, I created in Glide via the Data menu, is not displayed in the values I can select in my Zap. Any idea of what I can do? Thanks in advance for your help! ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [March 6, 2020, 7:20pm UTC](https://community.glideapps.com/t/how-to-send-email-to-a-list-of-user-using-zapier-in-glide/5247/2 "2020-03-06T19:20:41Z")
You could just do it with a Google Script and bypass Zapier. > [@Notification (email) when forms submitted](https://community.glideapps.com/t/notification-email-when-forms-submitted/1206/4): > > @kyleheney If you know javascript you are way ahead of the game. Google script is basically a clone of Javascript. I put together this bare bones spreadsheet and script as a demo. Make a copy and give it a try. Go into Tools/Script Editor. Then run it using the debugger (icon of a bug). You can set up breakpoints by clicking just to the left of the line numbers. You will see a red dot. If it’s the first time trying a script search YouTube for a short beginner tutorial. You will have … ---
**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:** [March 7, 2020, 6:32pm UTC](https://community.glideapps.com/t/how-to-send-email-to-a-list-of-user-using-zapier-in-glide/5247/3 "2020-03-07T18:32:07Z")
Is it an array of multiple columns? You can’t use an array of multiple values to fill a single value. You would probably have to create a template column or an arrayformula in the sheet to load all emails separated by comma’s into a single cell. ---
**Author:** ![Mattora](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattora/32/17144_2.png) [@Mattora](https://community.glideapps.com/u/Mattora)\ **Post date:** [February 22, 2022, 10:44am UTC](https://community.glideapps.com/t/how-to-send-email-to-a-list-of-user-using-zapier-in-glide/5247/4 "2022-02-22T10:44:23Z")
I would like to figure out how to set up a zap to email multiple users as well. E.g. Glide is able to calculate the distance of users via their current location to a specified coordinates of a place, e.g. a flea market. I would like to allow the organizer to send an email to users whose last location is within 3 kilometers of the flea market. Any idea how do I go about setting that up with Glide and Zapier? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 22, 2022, 2:26pm UTC](https://community.glideapps.com/t/how-to-send-email-to-a-list-of-user-using-zapier-in-glide/5247/5 "2022-02-22T14:26:33Z")
> [@Mattora](#): > > Glide is able to calculate the distance of users via their current location to a specified coordinates of a place This is calculated on the user’s device, so organizers will never have access to that data. You can’t save users’ “last location” unless you use a location component and hard-code it somewhere in your data, let’s say a column in your Users table. Of course, it won’t be updated by time and must require user interaction. If you still want the hard-code way, you can theoretically create a distance column from the users’ hard-coded locations, then pitch that against a fixed location based on the signed-in organizer. Only one location can be used, though. Then from that data, you can filter out the emails that match your condition, join them using a joined list column, and send that data to Zapier for further processing. ---
**Author:** ![Mattora](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattora/32/17144_2.png) [@Mattora](https://community.glideapps.com/u/Mattora)\ **Post date:** [February 24, 2022, 6:34am UTC](https://community.glideapps.com/t/how-to-send-email-to-a-list-of-user-using-zapier-in-glide/5247/6 "2022-02-24T06:34:50Z")
Thanks very much for your reply @ThinhDinh, really appreciate it. Yep I understand that the user’s location won’t be updated real-time unless they open up the app and use it. We could write in the email that we are keeping them posted given that their last location was detected to be near this flea market. I’ve seen your other post on joint list but I don’t quite understand how to do it in my context, i.e. 1. pulling the last location of users, 2. filtering it and 3. pulling their email addresses into a single column and trigger a zap to this list of reciepients Could you kindly explain how to do this? For step 1, I believe I’ll have to create a column and create a ‘use my location’ button to get their current coordinates? At present I have loaded the flea market coordinates so it’ll show the distance from the user when they open the app. – I’m thinking if another solution might work - assuming that there are different events in an area and flea market is one of them, the users could then follow ‘favorite’ this event and we will have a list of followers, we’ll then zap an email to this list of users, as opposed to the last location we have on them. But how do we get the list of users who favorite this particular event "flea market; into a joint list or cell column? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 24, 2022, 2:04pm UTC](https://community.glideapps.com/t/how-to-send-email-to-a-list-of-user-using-zapier-in-glide/5247/7 "2022-02-24T14:04:18Z")
> [@Mattora](#): > > For step 1, I believe I’ll have to create a column and create a ‘use my location’ button to get their current coordinates? Yes, you have to require their interaction to get that data. However, to be honest it’s not very practical, users might never update their location again (they have to switch the location switch on and off to update it, I believe). > [@Mattora](#): > > the users could then follow ‘favorite’ this event and we will have a list of followers, we’ll then zap an email to this list of users, as opposed to the last location we have on them. You have to write the “favorite” data to a new table, since the native favorite is a user-specific column and you can’t access different users’ data that way. If you have them as separate rows with an event ID, you can do a relation and join list to take the emails back. ---
**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:** [February 24, 2022, 2:50pm UTC](https://community.glideapps.com/t/how-to-send-email-to-a-list-of-user-using-zapier-in-glide/5247/8 "2022-02-24T14:50:31Z")
Since an exact location of the user may not be needed, I suppose you could get away with using the distance column, and through a user action, the user profile row could be updated with the business that was closest (had the smallest distance) at the time that action was performed. That way you wouldn’t need a location component. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 24, 2022, 11:34pm UTC](https://community.glideapps.com/t/how-to-send-email-to-a-list-of-user-using-zapier-in-glide/5247/9 "2022-02-24T23:34:51Z")
Yeah, this would be a better approach, maybe populates a list of business IDs to the user profiles sheet, and get that action to as many places as possible within the app. Then, in the businesses table, create a relation to a split text column of the list above, a joined list column would get a list of emails to send to Zapier. ---
**Author:** ![Mattora](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattora/32/17144_2.png) [@Mattora](https://community.glideapps.com/u/Mattora)\ **Post date:** [February 28, 2022, 9:28am UTC](https://community.glideapps.com/t/how-to-send-email-to-a-list-of-user-using-zapier-in-glide/5247/10 "2022-02-28T09:28:38Z")
Thanks Jeff and Thinh. I tried to create the array columns but bumped into an issue. Essentially I created a ‘favorite sheet’ so that a new row will be created whenever a user fav or unfavorite the place or event (e.g. ABC flea market). I would then do 2 lookup for the email in the [places] sheet - one for the list of ‘fav emails’ and another for ‘unfav emails’, and then use the [Array - remove elements] to get the final list of followers email addresses. However if a user were to favorite a place, unfavorite it, and favorite again (perhaps sometime in the future), the [Array - remove elements] unfortunately doesn’t capture the email again because the email is previously captured in the ‘unfav emails’ column. So essentially what I want is if the same email appears more times in the ‘fav emails’ vs the ‘unfav emails’, then the final data would indicate that this user is following this place. Apologies if this issue has been covered somewhere else but I can’t seem to find the solution in any thread. If there is a better way to achieve my intended outcome, I’m all ears as well! 🙂 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 28, 2022, 2:04pm UTC](https://community.glideapps.com/t/how-to-send-email-to-a-list-of-user-using-zapier-in-glide/5247/11 "2022-02-28T14:04:44Z")
> [@Mattora](#): > > Essentially I created a ‘favorite sheet’ so that a new row will be created whenever a user fav or unfavorite the place or event (e.g. ABC flea market). I think you just stick to this extra table. Create a relation from the Places table to the Favorites table, and return all the emails through a joined list column. For favoriting/unfavorting: Favoriting: Add a row to the Favorites sheet, containing the signed-in user’s email and the Places ID. Unfavoriting: - Add a template column in the Places table containing the email of the signed-in user and the Places ID. Let’s say it would look like: [a@gmail.com](mailto:a@gmail.com) - ID. - Add a template column in the Favorites table with the same structure as above. - Create a relation using the pair of columns above, from the Places table to the Favorites table. - When people click an “Unfavorite” button, you delete the row using the relation. That way, you can just always refer to the list of emails I mentioned at the top to pass to Zapier, no need to care about adding/removing elements from arrays. ---
**Author:** ![Mattora](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattora/32/17144_2.png) [@Mattora](https://community.glideapps.com/u/Mattora)\ **Post date:** [March 4, 2022, 7:58am UTC](https://community.glideapps.com/t/how-to-send-email-to-a-list-of-user-using-zapier-in-glide/5247/12 "2022-03-04T07:58:25Z")
> When people click an “Unfavorite” button, you delete the row using the relation. That way, you can just always refer to the list of emails I mentioned at the top to pass to Zapier, no need to care about adding/removing elements from arrays. I don’t quite understand this step fully, could you kindly explain this further? Essentially I have 2 sheets - one for [places], and the other is [favorite] sheet. I also have a tab for people to search for places, and then favorite them. I followed the step till the last part on deleting the row, because the tab is being linked to the [places] tab so I would be deleting the row containing the place details, latlng etc. For the Fav button, I could easily reference a sheet (i.e. [fav sheet]) and have it create a row, but to delete a row there’s no option to reference a sheet, which means it would be deleting the row in the [places] sheet which is not ideal. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 4, 2022, 8:24am UTC](https://community.glideapps.com/t/how-to-send-email-to-a-list-of-user-using-zapier-in-glide/5247/13 "2022-03-04T08:24:15Z")
> [@ThinhDinh](#): > > Create a relation using the pair of columns above, from the Places table to the Favorites table. If you have created this relation, you can use it in a “delete row” action. ---
**Author:** ![Mattora](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattora/32/17144_2.png) [@Mattora](https://community.glideapps.com/u/Mattora)\ **Post date:** [March 5, 2022, 10:35am UTC](https://community.glideapps.com/t/how-to-send-email-to-a-list-of-user-using-zapier-in-glide/5247/14 "2022-03-05T10:35:47Z")
Not sure why it didn’t show up previously but I just tried again and saw the option to delete the relation item, thanks so much @ThinhDinh !