Google Tips & Tricks:
Developer Scripts & Tutorials:
https://developers.google.com/apps-script/

Sending e-Mail from Google Spreadsheets:
https://developers.google.com/apps-script/articles/sending_emails