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 …

You could just do it with a Google Script and bypass Zapier. [image] Notification (email) when forms submitted @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 …

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.

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 locati…

[image] 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 compo…

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 fle…

[image] 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…

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 wou…

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 lis…

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 …

[image] 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 …

How to send email to a list of user using Zapier in Glide?

Ask for Help

George_B March 6, 2020, 7:20pm 2

You could just do it with a Google Script and bypass Zapier.

Topic		Replies	Views
Send email to filtered users Ask for Help	14	291	December 1, 2022
:zap: Glide with Zapier! General	41	5870	January 29, 2021
📱📨 How to Send Email Notifications from Glide With Zapier Community Resources tutorial	10	1256	January 5, 2023
Zapier usecases? Ask for Help	21	1458	May 9, 2020
How can I email user results from an app? Ask for Help	5	736	February 4, 2022

How to send email to a list of user using Zapier in Glide?

Related topics