Get Google Forms Data in an Email

Google Forms can send email notifications as soon as people submit your online form but 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.

Here is script from Amit@labnol.org that you can use to achieve the same:

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

1. /*

2.   Send Google Form Data by Email v4.2

3.   Written by Amit Agarwal amit@labnol.org

4.   Source: http://labnol.org/?p=20884

5. */

6.  

7. /**

8. * @OnlyCurrentDoc

9. */

10.  

11. function Initialize() {

12.  

13.  try {

14.  

15.    var triggers = ScriptApp.getProjectTriggers();

16.  

17.    for (var i in triggers)

18.      ScriptApp.deleteTrigger(triggers[i]);

19.  

20.    ScriptApp.newTrigger("EmailGoogleFormData")

21.      .forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet())

22.      .onFormSubmit().create();

23.  

24.  } catch (error) {

25.    throw new Error("Please add this code in the Google Spreadsheet");

26.  }

27. }

28.  

29. function EmailGoogleFormData(e) {

30.  

31.  if (!e) {

32.    throw new Error("Please go the Run menu and choose Initialize");

33.  }

34.  

35.  try {

36.  

37.    if (MailApp.getRemainingDailyQuota() > 0) {

38.  

39.      // You may replace this with another email address

40.      var email = "amit@labnol.org";

41.  

42.      // Enter your subject for Google Form email notifications

43.      var subject = "Google Form Submitted";

44.  

45.      var key, entry,

46.        message = "",

47.        ss = SpreadsheetApp.getActiveSheet(),

48.        cols = ss.getRange(1, 1, 1, ss.getLastColumn()).getValues()[0];

49.  

50.      // Iterate through the Form Fields

51.      for (var keys in cols) {

52.  

53.        key = cols[keys];

54.        entry = e.namedValues[key] ? e.namedValues[key].toString() : "";

55.  

56.        // Only include form fields that are not blank

57.        if ((entry !== "") && (entry.replace(/,/g, "") !== ""))

58.          message += key + ' :: ' + entry + "\n\n";

59.      }

60.  

61.      MailApp.sendEmail(email, subject, message);

62.    }

63.  } catch (error) {

64.    Logger.log(error.toString());

65.  }

66. }

67.  

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