I use something similar to this on our help desk application. It has to be triggered manually, but as long as you've captured the teacher's email address somewhere in the form, it should be doable. You select the row that contains the information and then hit the send button from a custom menu item. The script handles the rest of it.

Here's the link to the Google Developer tutorial site that we built our help desk around.

Nick Clark
Information Technology Technician
Champlain Valley Union HS

On Tue, Dec 10, 2013 at 2:31 PM, Drew Blanchard <[log in to unmask]> wrote:

We have a Google Form, used by our tutors, to enter information about students' work and other relevant details when they provide extra help after school.  The spreadsheet side of the Form has been shared with the teachers, so they can see what their students have worked on - and also see comments/feedback from the tutors.  Many teachers have said they'd like to be automatically notified when information relevant to them has been entered via the Form.  Ideally, they'd like the text entered on the form to be included in this email (instead of a generic "information relevant to you has been entered on the tutoring Form").  This is out of my area of expertise.  Is there a way to accomplish this by creating a script of some sort?

Thanks, eh!


Drew Blanchard, MAT
Technology Integration Specialist
Winooski City Schools
70 Normand Street
Winooski, VT 05404
(802) 383-6073