Get Google Forms Data in an Email Message

Whether you need a simple “Contact Me” form for your website or are trying to build a complex online poll, Google Forms are a perfect tool. You can customize Google forms with themes, the forms are mobile-friendly and the form data is automatically saved in a Google spreadsheet that can be easily exported to other formats like PDF or CSV.

Unlike other polling software, Google Forms can accept unlimited responses and they are absolutely free. You can also schedule Google Forms to stop accepting responses after a given date. 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 associated Google Spreadsheet that is collecting the form responses to see the submitted data which is not always a very convenient option.

If you however wish to receive the submitted Google Forms data in an email message, Google Scripts can help. The simple 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 for sending form notification emails is available in free and premium editions. The latter includes more features and you can opt for one-on-one support too.

Features	Free	Premium
Works with Gmail & Google Apps	Yes	Yes
Personalize Form Emails with Logo & HTML formatting	No	Yes
Send confirmation emails to the form submitter	No	Yes
Customize the email subject and message body of notification emails	No	Yes
Attach form data as PDF file	No	Yes
Send Form notifications to multiple email addresses	No	Yes
Send form notification emails from another Gmail alias	No	Yes
Set the reply-to address for notification emails as the form submitter’s address	No	Yes
Installation Manual (PDF) included	No	Yes
Support options	None	Email
	Forever Free	Premium

Send Google Forms Data by Email

Here’s how you can add email notifications 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 form. 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. Replace amit@labnol.org in line #40 with your own email address where the notifications will arrive. You can add multiple email addresses too separated by commas. You may also change the subject in line #43.
4. 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 Data by Email v4.2
   Written by Amit Agarwal amit@labnol.org
   Source: http://labnol.org/?p=20884
*/
 
/**
 * @OnlyCurrentDoc
 */
 
function Initialize() {
 
  try {
 
    var triggers = ScriptApp.getProjectTriggers();
 
    for (var i in triggers)
      ScriptApp.deleteTrigger(triggers[i]);
 
    ScriptApp.newTrigger("EmailGoogleFormData")
      .forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet())
      .onFormSubmit().create();
 
  } catch (error) {
    throw new Error("Please add this code in the Google Spreadsheet");
  }
}
 
function EmailGoogleFormData(e) {
 
  if (!e) {
    throw new Error("Please go the Run menu and choose Initialize");
  }
 
  try {
 
    if (MailApp.getRemainingDailyQuota() > 0) {
 
      // You may replace this with another email address
      var email = "amit@labnol.org";
 
      // Enter your subject for Google Form email notifications
      var subject = "Google Form Submitted";
 
      var key, entry,
        message = "",
        ss = SpreadsheetApp.getActiveSheet(),
        cols = ss.getRange(1, 1, 1, ss.getLastColumn()).getValues()[0];
 
      // Iterate through the Form Fields
      for (var keys in cols) {
 
        key = cols[keys];
        entry = e.namedValues[key] ? e.namedValues[key].toString() : "";
 
        // Only include form fields that are not blank
        if ((entry !== "") && (entry.replace(/,/g, "") !== ""))
          message += key + ' :: ' + entry + "\n\n";
      }
 
      MailApp.sendEmail(email, subject, message);
    }
  } catch (error) {
    Logger.log(error.toString());
  }
}
 
/* For support, contact developer at www.ctrlq.org */

Please make note that you need to paste the Google Script inside the Script Editor of the Responses Google spreadsheet and not the Google Form.

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.

One more thing. Google Forms do not allow file uploads but you can use Google Scripts to allow anyone to upload files via a form to your Google Drive.

SHARE

Manohar Mohanta

Hi, I am Designer of computer solutions. I am CEO/Founder of computer hardware and software solutions. I am Creative Art Director, Web Designer, VHDL Programer, Interaction Designer, Industrial Designer, Web Developer, Business Enthusiast, StartUp Enthusiast, Speaker, Writer and Photographer. Inspired to make things looks better.

• 
• 
• 
• 
•