You have a Google Form and you would like to send confirmation emails to the person as soon as they submit the form. The email will inform them that form details have been successfully submitted and, while this is optional, you can also include the various form fields in the email message.

These auto-responders 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

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 send these confirmation emails 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 can add the auto-reply feature to your Google Forms in less than a minute. Here are the steps involved:

  1. Create a new Google Form with one or more fields. You can also use an existing form but do make sure you have a field called “Email Address” in the form where the submitter will input their email address. This should be a mandatory field.
  2. Open the Google Spreadsheet that is storing the form responses, go to the Tools menu and choose the Script Editor option.
  3. Copy-paste the Google Script below into the script editor and press (ctrl+s) or click the floppy icon to save the script. You can give it any name.
  4. You need to make a few adjustments to the script. For instance, add your email address in line #26, put your name in line #29 and add the custom message in line #36.
  5. While you are inside the Script Editor, choose the Run menu and select Initialize. Authorize the script and it will now send confirmation emails on your behalf.

That’s it. When anyone submits the Google Form, they’ll get an automatic confirmation email in HTML format and you will be included in the CC list so you are in the loop.

For more advanced options, see this tutorial on send Google Forms data in email. You can see the Google Scripts support site for premium support and customization.

Google Script – Send Mail to Form Submitter

/* Send Confirmation Email with Google Forms */

function Initialize() {

  var triggers = ScriptApp.getProjectTriggers();

  for (var i in triggers) {



function SendConfirmationMail(e) {

  try {

    var ss, cc, sendername, subject, columns;
    var message, value, textbody, sender;

    // This is your email address and you will be in the CC
    cc = "";

    // This will show up as the sender's name
    sendername = "Your Name Goes Here";

    // Optional but change the following variable
    // to have a custom subject for Google Docs emails
    subject = "Google Form Successfully Submitted";

    // This is the body of the auto-reply
    message = "We have received your details.<br>Thanks!<br><br>";

    ss = SpreadsheetApp.getActiveSheet();
    columns = ss.getRange(1, 1, 1, ss.getLastColumn()).getValues()[0];

    // This is the submitter's email address
    // Make sure you havea  field called Email Address in the Google Form
    sender = e.namedValues["Email Address"].toString();

    // Only include form values that are not blank
    for (var keys in columns) {
      var key = columns[keys];
      var val = e.namedValues[key] ? e.namedValues[key].toString() : "";
      if (val !== "") {
        message += key + ' :: ' + val + "<br />";

    textbody = message.replace("<br>", "\n");

    GmailApp.sendEmail(sender, subject, textbody, {
      cc: cc,
      name: sendername,
      htmlBody: message

  } catch (e) {


Comments »