If you use Google Forms for surveys or to quiz your students in class, you may have found yourself wishing that you could get notifications each time someone submits your form. Logging into Google and checking your Results Sheet often can take a lot of time. Fortunately, there is a way to set up notifications and eliminate unnecessary checks on your Results Sheet.

Google App Scripts

Google App Scripts are a really handy way to extend what Google tools are able to do, but Scripts can seem intimidating. Fortunately, there are some really handy pre-made scripts you can set up for your projects. One of those scripts sends email notifications each time someone submits a form. This can be very useful if you are using a Google Form to collect information for a survey or as a platform for quizzing with your students. Each time someone submits your form you will be notified via email once you set up this short script.

Getting Started

  1. To get started build your Google Form.
  2. Copy the code below.
    function myEmailNotificationFunction() {
    MailApp.sendEmail(“youremail@google.com”,”Your title – You Have a Form Response”,”What you want your notification email to say”);
    }
  3. Go to the Response Sheet for your form and find the Tools menu.
  4. Select Script Editor and Blank Project, remove the existing code, then paste the above code into the window.
    Copy AppScript Code
  5. Edit your email address.
    CustomizedCode
  6. Edit the title of your email.
  7. Edit the text for your email.
  8. Save the script and give it a name.
    RenameProject
  9. Go to Resources -> Current Project’s Triggers;
    CurrentProjectTriggers
  10. Add the trigger.
    AddTriggers
  11. Authorize the app when notified to do so.

    AuthorizeApp
  12. Test the script by running it.
    RunTheScript

Tips/Best Practices:

Be sure to title your email and change the email text in the script so that it is customized enough that you can tell which form you are being notified about.

Download this Teaching Tip