Send Confirmation Email with Google Forms / Spreadsheets

Posted by bozdoz on Stack Overflow See other posts from Stack Overflow or by bozdoz
Published on 2011-01-11T05:50:51Z Indexed on 2011/01/11 5:53 UTC
Read the original article Hit count: 245

Filed under:
|
|
|

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?

© Stack Overflow or respective owner

Related posts about jQuery

Related posts about email