Notifications by mail

Hi, is there a way (may be with a script in a sheet) to receive notification by mail where a row is added in a sheet ? (waiting for push notifications)

1 Like

Does this help?

https://support.google.com/docs/answer/91588?co=GENIE.Platform%3DDesktop&hl=en

1 Like

Yes it’s pretty straight forward to do it in a script. Check out this: https://developers.google.com/apps-script/articles/sending_emails

You would tweak it for your spreadsheet and modify it to check a given sheet for the Last row. Save that value off to to the properties and then check to see if that changed. You would set it up with a timed trigger.

Hi, thank’s for the link.
I’d like to adapt the script for send mail to a group of users (their email addresses are in another tab). Someone could help me to do that ?