Whether you are looking to add a simple “Contact Me” form on your website or need to create a complex online poll, Google Forms are an excellent tool. They offer a variety of themes, the form data is save in a spreadsheet that can be easily exported and, unlike other polling software, your Google Forms can accept any number of responses and they’re absolutely free.

There’s one limitation though. Google Forms can send email notifications as soon as people submit your online form but, as shown in the screenshot, the actual form data isn’t included in the email message. You’ll have to open the corresponding Google Spreadsheet that is collecting the form responses to see the form data which is not always a very convenient option.

Receive Google Forms data In Email

Should you wish to receive Google Form data in an email message as soon as a user submits the online form, there’s an easy workaround as explained in this video tutorial .

What we can do is create a simple Google Script that triggers as soon as a user submits the form. The script will read the form values entered by the user and sends them in an email message to your email address.

Awesome Google Scripts → Custom Google Scripts →

Here’s how you can add email capabilities to any Google Form in few easy steps:

  1. Create a new form in Google Docs or you can use any of your existing Google forms. Inside the form editor, click “View Responses” to open the Google Spreadsheet that is collecting the responses of your your Google Form.
  2. While you are inside the spreadsheet, go to Tools –> Script Editor, remove any existing code and copy-paste the following snippet. Press Ctrl+S Save the code and give your project any name (say “Send Google Forms by Email”).
  3. Go to Run and choose Initialize. Google Docs will now require you to authorize the script – just click the Accept button and you’re done
/* Send Google Form by Email v2.0 */
 
/* For customization, contact the developer at amit@labnol.org */
 
/* Tutorial: http://www.labnol.org/?p=20884 */
 
function Initialize() {
 
  var triggers = ScriptApp.getScriptTriggers();
  
  for(var i in triggers) {
    ScriptApp.deleteTrigger(triggers[i]);
  }
  
  ScriptApp.newTrigger("SendGoogleForm")
  .forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet())
  .onFormSubmit()
  .create();
  
}
 
function SendGoogleForm(e) 
{  
  try 
  {      
    // You may replace this with another email address
    var email = Session.getActiveUser().getEmail();
    
    // Optional but change the following variable
    // to have a custom subject for Google Form email notifications
    var subject = "Google Docs Form Submitted";  
    
    var s = SpreadsheetApp.getActiveSheet();
    var columns = s.getRange(1,1,1,s.getLastColumn()).getValues()[0];    
    var message = "";    
    
    // Only include form fields that are not blank
    for ( var keys in columns ) {
      var key = columns[keys];
      if ( e.namedValues[key] && (e.namedValues[key] != "") ) {
        message += key + ' :: '+ e.namedValues[key] + "\n\n"; 
      }
    }
        
    // This is the MailApp service of Google Apps Script
    // that sends the email. You can also use GmailApp for HTML Mail.
    
    MailApp.sendEmail(email, subject, message); 
    
  } catch (e) {
    Logger.log(e.toString());
  }
    
}

If you need to disable notifications, open the script editor again and choose Resources -> Current Script Triggers and delete the Form trigger associated with the “On Form Submit” action.

Send Google Forms by Email – Premium Edition

The premium version of the Send Google Forms by Email script (PDF Manual) includes more features including:

  1. Send form data in plain text, rich HTML or even as PDF attachments.
  2. Send a copy of the form to the form submitter for confirmation.
  3. Send the form notifications to one or more email addresses.
  4. Support for Gmail aliases – send mail from any email connected to your Google account.
  5. Support for replyTo in the email header to quickly respond to a form.
  6. Customize the email subject and message body of the notification.


Also see: Perform Mail Merge in Gmail using Google Docs