Search code examples
google-apps-scriptgoogle-forms

How do I send an email when a Google Form is submitted?


How do I send a notification email after a form has been submitted?

I have a Google Form, I open it and I go to menu More->Script Editor and add a script:

function OnSubmit(e) {
  MailApp.sendEmail ("[email protected]", "Form Submited: Foo feedback " + Date.now(), "Form Submited: Foo feedback");
}

I save the script and test it works by pressing the run button. The email gets delivered to [email protected].

Then I fill in the Google Form, but the email does not arrive in [email protected] mailbox.

P.S. I do not want to use "Email Notifications for Forms" plugin because it requests access to to many privileges. I do not want to use "Form Notifications" because for some reason it does not work for me (the emails do not get delivered).


Solution

  • Finally found it, well hidden under

    • Edit form mode
    • Responses tab
    • ... menu button
    • Get email notifications for new responses.

    enter image description here