Just FYI -
https://gsuite.google.com/marketplace/app/magic_cell_notifications/886834937346
I just set it up so that I get an email when a certain column has new data.
I also use it for getting notified when a new user signs in (or an old user on a new device.
I just use it VERY basically to get an email. I have not really delved deep into what it can do.
5 Likes
Great info. My mind was already blown away by Glide and now you are sprinkling it with candy dust and asking that I put on some 3D glasses.
2 Likes
The magic cell notification was very useful in setting up notifications. Provides lot of variations to the notification. One issue is that the google sheet gets attached with every notification. If this could be avoided it would be good.
You can use a script to send email
Not anything native to Glide or Google Sheets but you could write a script to do it. Sending the actual email is pretty easy. https://developers.google.com/apps-script/reference/mail
MailApp.sendEmail({
to: "youremail@whatever.com",
subject: "New Form Added",
body: "This is the body of the email."
});
What you would do is set up a timed trigger that runs a function that checks for the additional row that a Form added. You would create a column that holds a…