Sending an email from a column on Google Sheets when I enter X in the last column

Question

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?

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.rowStart in the event object, and uses MailApp.sendEmail() to send a message to that address.

See sendEmailNotificationAndInsertTimestamp_ for sample code.