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 and the form data is saved in a Google spreadsheet that can be easily exported in other formats like PDF or CSV. Also, 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 submitted data which is not always a very convenient option.

If you wish to receive the submitted Google Forms data in an email message, Google Scripts can help. The script will trigger as soon as a user submits the form, it reads the form values entered by the user and sends them in an email message to your email address video.

Receive Google Forms data in Email

The Google Script is available in free and premium editions. The latter includes more features and you can opt for direct support over email, Skype or Google Hangouts.

Features Free Premium Premium+
Works with Gmail & Google Apps Yes Yes Yes
Can send confirmation emails to form submitter No Yes Yes
Customize forms email subject and message body No Yes Yes
Send forms data as Text, HTML or PDF No Yes Yes
Send Form notifications to multiple email addresses No Yes Yes
Send form notification emails from another Gmail alias No Yes Yes
Set the reply-to address for emails as the form submitter’s address No Yes Yes
Installation Manual (PDF) included No Yes Yes
Support options Support Forums Email Support One-to-one support over Skype or Google Hangouts
Forever Free Get Premium Get Premium+
You may make payments through PayPal or your credit and debit cards. You can request a refund within 24 hours of purchase.

Send Google Forms by Email

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

  1. Create a new form in Google Drive 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 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 (or Cmd+S on Mac) to save the code and give your project any name (say “Send Google Forms by Email”).
  3. Go to the Run menu and choose Initialize. The Google Script 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. You can also schedule Google Forms to stop accepting responses after a given date.