Send Confirmation Email with Google Forms / Spreadsheets
- by bozdoz
I know that Google Spreadsheets includes a mass mailout option with its MailApp.sendEmail function, but, as far as I know, it can only run once a form is opened, or by manually clicking "run".
I have a Google form which includes an area for someone to put their email address. Is there a simple solution to send this data to its Google Spreadsheet and send it as a confirmation to the specified email address? It would be great if I could somehow incorporate MailApp.sendEmail into the form, instead of into the spreadsheet (which would be after the fact and manual, instead of instant and automatic).
Also, note that I will be posting with jQuery.
Any ideas?