Google Apps Script: Sending emails from Google Spreadsheets

[sehwag4]

The code is Wrong dude

[seattlesteve4]

weetcka,why the hostility

Thanks for the code.

What I'd like to know is if there is a way to automate the calling of a google script from within the spreadsheet. I'm not too hopeful there is a way, since I'd need a way to automate the opening of the spreadsheet too. I'd like to email myself a message if a date cell in the spreadsheet reaches a particular milestone date.

[josteurs]

where can I find these scripts? I´m not smart enough to write them myself, Maybe I can buy a ready made package of these add in´s

[mongrel73]

@josteurs I think you just have to type up what you see at 1:01

[ozhamada]

Regarding the email at the 52 second mark. Email was not sent by Hugo (as he purports to be doing) but instead sent to him. The email address starting with "templates@" is intended by the Apps Script to have been a reciepient yet Hugo shows us an email that "templates@" has sent the email to Hugo (or "me").

[weetcka]

that was 2 clicks, dumbass