I am a high school teacher looking to streamline my late work process. I have a google form the students fill out telling me their name, hour, email, and what assignment was late. I added a column at the end for me to enter "x" in once I have graded their assignment and entered it into our gradebook. I would like to be able to have the sheet auto-send an email to that student using the email they entered in Column C with a generic "your late work has been updated" message.

Is this even possible?


1 Answer 1


You need a script that runs on an installable "on edit" trigger, picks the email address from column C on the row given by e.range.rowStart in the event object, and uses MailApp.sendEmail() to send a message to that address.

See sendEmailNotificationAndInsertTimestamp_ for sample code.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.