My app allows users to favorite certain items and I have created a page that displays a user-specific page that displays recent updates for each item that the signed-in user has favorited.
In the user table I have a column that creates a template that combines each of those same items that have recent updates and makes them into a list, using some of the techniques described on here for emailing a CSV of data.
What I want to be able to do is periodically email that list to each user. Since each user’s list is different, I want to be able to basically send a unique email to each row in the user list, with the contents of my template column as the body. The result would be each user getting an email that shows them only the items unique to them.
How might I accomplish this, using Make or the built in email function in glide? So far, the techniques I’ve tried seem to only work either to send one unique email to one person at a time or to send the same info to multiple people using a list of comma separated email addresses.
Currently, this is not possible if you’re using a user specific glide table to form the CSV. I’ve been able to accomplish this, using a formula in google sheets, and then Make to send the email. Glide will soon be offering timed based/condition-based actions, but I don’t know if this will work for user specific values. It’s uncharted territory.
When you say “user specific glide table” you’re referring to the fact that I’m using the user table? I’m not wedded to using the user table as the source if that matters…
Also, have you documented your procedure for doing this in Google Sheets? If not, I’ll await the arrival of time-based actions from Glide…
I saw your oroginal post that you had created a user-specific screen based off a template column so I assumed that the CSV that you’re creating is user specific and not in any sort of query-able field.
If you’re not using a Google sheet, the only way to grab that value from outside of glide on any sort of timed-based action would be if you were using a get all rows API call using the Glide API, but I don’t know if you can grab that user specific value if it’s within a template column.
If by user specific, if you mean that each user simply has their own CSV value within that template column column, then you might be able to get away with it in Make and then iterate through each of the CSV values to send the email one at a time for every user.
As I tend to do, I think I provided too much detail, and made my question more confusing instead of less confusing.
Let me narrow my question to start. You may have answered it, but I want to be sure.
Is it possible for me to hit a button in glide and have it send emails to multiple users at once? And if so is it possible for the information in the email to be different for each user?
A simple example would be: say in the user table, there is a column called home address and I want to click a button and send everyone in the user table an email that says “this is what we have for your home address. Can you confirm that it’s still current?” And then the email that is sent it would display for each user a different value, namely, the value in the home address column for their row in the user table.
You might have to loop through your table in order to do that. To do that in an integration with Make:
Create a button in Glide that triggers a webhook. You don’t need to send any special values here, just any value to trigger the scenario.
Have a Google Sheets module to search all rows that have “home address” column not being empty.
Add an email module to send an email to all found rows.
There might be another way of constructing a JSON inside Glide, send that through the webhook and loop through that JSON object inside Make to send the emails.
I do not use google sheets as connected data. I used it as unlimited unconnected data, much bigger and faster than Glide tables
You don’t need to build Glide App on Google Sheets to use google scripts.
Yes! great results, so fast… if you are dealing with data over 10K rows… Glide is visibly slower than fetching computed results from google sheets… as you know, my App… with an English dictionary for pages… I can find and sort and fetch 160K rows much faster them my other apps that have only 5K rows
Gotcha. It’s an interesting technique—and certainly can be useful in the right situation, but when users are in the forum here looking for assistance with Glide, I’m assuming they’re looking for a more native solution than a clever workaround that isn’t intuitive to a novice no-code developer.
Make is not the native solution… so same thing… plus it will make it even slower…
In my opinion… the time and effort non-code users spend to learn other integrations platforms… is similar to learning simple codes… and results are worth putting view minutes or even hours more.
Don’t worry @Robert_Petitto, your not missing anything. Google Script Queries are not very secure. Especially when used with Glide, and especially when critical data is involved. As most of us know, it’s about as secure as placing an API key in a javascript column. The API key, as well as the Google Script url and keys, are fully exposed to the end user, and anybody can maliciously use it to scrape more data from the google sheet, or maliciously call it…even outside of Glide. I wouldn’t recommend it if data needs to be protected.
You don’t place the key in Glide. Placed in google script, then pulled out only selected data through fetch JSON, @Jeff_Hager are you saying that this is less secure than the Glide owner row?
switch to the scripts, which are much faster and free.