I used a Google Forms add-on Email notifications for forms, which has worked beautifully - info and instructions here, and in brief below. To do this with ease I needed to revert to the old* style of Forms, to do this click on the ? mark at the bottom right of the form and choose the 'Back to the old Forms' option.
- Install the add-on from the add-on page itself (click 'Free', top right), a blank new form will appear which you can ignore and then a pop-up will appear asking you to confirm that it can interact with your account, I said 'yes'.
- Once it's added you'll have a new field in your Add-ons menu, on old forms it looks like this
- Click on it and go through the steps, I left it mostly at the default settings. If you have several forms make sure you give each one a different name so that you can manage the emails when they arrive.
I have several work-related Google Forms which invite teachers to sign up for various things. Each time a teacher fills in a form their data is automatically stored in a Google Sheet and I get an email telling me that there's a new entry. Someone else set these up and I inherited them when they left.
Up until a few months ago these notification alert emails were useful and informative (image one), but now they look more like the second image, and are useless.
|The old style of email notification, with actually useful information in it|
|The considerably less useful type of email alert I get now|
It turns out that it's not possible to set up a notification from the forms only from the sheet - this may be something to do with the 'new' Google Forms as opposed to the old 'Legacy' version. I have been surprised to read various helpfiles telling me that it can't be done when, for months, I've been receiving them - but they mysteriously stopped in November 2016 and I've been trying to work out how to get them back. Now that I've got them I'm not awfully impressed.
I've tried adding 'add-ons' but have got nowhere with them. Is there a simple way of fixing this? I can't believe that anyone would find the info in the current notification emails an improvement on the previous one, surely everyone else is whining about this? Or is it that the person who set it up initially knew something that I didn't and have done some clever thing that I can't replicate.