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

You can buy the Premium version using your credit card or PayPal. It is a flat one-time fee (not a subscription) and you can use the program for life. You also get free technical support over email for 6 months.

The Platinum version has all the features of premium and includes one-on-one support over phone, Skype or Google Hangouts for 12 months.

Refunds can be requested within 6 hours of purchase. Should you have any questions, or require customization, send an email at amit@labnol.org or visit our services page.


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)


  } 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) {

/* 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.

Comments »