Sample Google Apps Script functions for Gmail.
This tutorial shows an easy way to collect information from different users in a spreadsheet using Google Forms, then leverage it to generate and distribute personalized emails.
This tutorial shows how to use Spreadsheet data to send emails to different people.