I maintain the different blog directories and i accepts entries through a simple Google Form. The workflow is something like this – when someone submits the Google Form, an automatic confirmation email arrives in their inbox informing them that their details have been successfully submitted.
These are similar to canned responses in Gmail but for Google Forms. You may use the trick for sending welcome messages, acknowledge support requests, and more. Here’s a sample confirmation email generated and sent through Google Forms:

A sample auto confirmation email sent through Google Forms

Send a Confirmation Email to the Form Submitter

The other day I got an email from N.Vamsi asking me how to setup these auto-responders using Google Forms?

Would you mind telling me how you have set up auto email updater for inputs taken from Google forms. I have seen your video tutorial on setting up Google forms and getting input values to an email address but auto email responder is something new! Do you have any tutorials for that as well?

This is easy and you can  add the auto-reply feature to your Google Forms in less than a minute. Here are the steps involved:

  1. Go to your Google Drive and create a new Google Form. Add any number of fields to the form but make sure you have a field called “Email Address” where the submitter will input their email address.
  2. Assuming that you are saving your Google Form responses in a separate spreadsheet, open that sheet and choose the Script Editor option under the Tools menu.
  3. Copy-paste the following script into the script editor and hit the floppy icon to save the script.
  4. Inside the Script Editor, choose Run – Initialize and authorize the script to send emails on your behalf.

That’s it. When anyone submits the form, they’ll get an automatic confirmation email in HTML. You will be included in the CC.

Google Script – Send Mail to Form Submitter

    1. /* Send Confirmation Email with Google Forms */
    2. function Initialize() {
    3. var triggers = ScriptApp.getScriptTriggers();
    4. for (var i in triggers) {
    5. ScriptApp.deleteTrigger(triggers[i]);
    6. } ScriptApp.newTrigger(“SendConfirmationMail”)
    7. forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet())
    8. .onFormSubmit()
    9. .create();
    10. }
    11. function SendConfirmationMail(e) {
    12. try {
    13. var ss, cc, sendername, subject, columns;
    14. var message, value, textbody, sender;
    15. // This is your email address and you will be in the CC
    16. cc = Session.getActiveUser().getEmail();
    17. // This will show up as the sender’s name
    18. sendername = “Your Name Goes Here”;
    19. // Optional but change the following variable
    20. // to have a custom subject for Google Docs emails
    21. subject = “Google Form Successfully Submitted”;
    22. // This is the body of the auto-reply
    23. message = “We have received your details.<br>Thanks!<br><br>”;
    24. ss = SpreadsheetApp.getActiveSheet();
    25. columns = ss.getRange(1, 1, 1, ss.getLastColumn()).getValues()[0];
    26. // This is the submitter’s email address
    27. sender = e.namedValues[“Email Address”].toString();
    28. // Only include form values that are not blank
    29. for ( var keys in columns ) {
    30. var key = columns[keys];
    31. if ( e.namedValues[key] ) {
    32. message += key + ‘ :: ‘+ e.namedValues[key] + “<br />”;
    33. }
    34. }
    35. textbody = message.replace(“<br>”, “n”);
    36. GmailApp.sendEmail(sender, subject, textbody,
    37. {cc: cc, name: sendername, htmlBody: message});
    38. } catch (e) {
    39. Logger.log(e.toString());
    40. }
    41. }


Please enter your comment!
Please enter your name here