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
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 ?