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 ("myemail@mydomain.com", "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 myemail@mydomain.com.

Then I fill in the Google Form, but the email does not arrive in myemail@mydomain.com 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

    enter image description here