Here is a potential reference in python http://www.jose-vidal.com/2009/06/how-to-email-rows-from-google.html
I'm not sure if google spreadsheets can be scripted (via its own scripting library) or if I could use ActionMailer(rails component). Furthermore the authentication is in question. Would the user have type in a password for each email sent? Can oauth be used when that is implemented? Can it be signed with the token? Sending email on a users behalf should something that is approached with caution.