Follow us on Facebook

Get Google Forms Data in an Email Message

Whether you want a simple “Contact Me” form for your website or need to create 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 in line #25 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 #28.
  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
  1. /* Send Google Form Data by Email v3.0 */
  2. /* Source: */
  4. /**
  5. * @OnlyCurrentDoc
  6. */
  8. function Initialize() {
  10. var triggers = ScriptApp.getProjectTriggers();
  12. for (var i in triggers)
  13. ScriptApp.deleteTrigger(triggers[i]);
  15. ScriptApp.newTrigger("SendGoogleForm")
  16. .forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet())
  17. .onFormSubmit().create();
  18. }
  20. function SendGoogleForm(e) {
  22. if (MailApp.getRemainingDailyQuota() < 1) return;
  24. // You may replace this with another email address
  25. var email = "";
  27. // Enter your subject for Google Form email notifications
  28. var subject = "Google Form Submitted";
  30. var s = SpreadsheetApp.getActiveSheet();
  31. var columns = s.getRange(1, 1, 1, s.getLastColumn()).getValues()[0];
  32. var message = "";
  34. // Only include form fields that are not blank
  35. for (var keys in columns) {
  36. var key = columns[keys];
  37. if (e.namedValues[key] && (e.namedValues[key] !== "")) {
  38. message += key + ' :: ' + e.namedValues[key] + "\n\n";
  39. }
  40. }
  42. MailApp.sendEmail(email, subject, message);
  43. }
  45. /* For support, contact the develop at */
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 to your Google Drive via an HTML form.
Share on Google Plus

About Naresh Sahu

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.
    Blogger Comment
    Facebook Comment


Post a Comment

Blog Archive