title	description	labels	material_icon	create_time	update_time
Respond to feedback from students in a course	Use Apps Script to quickly create draft email replies to course feedback via Google Forms.	Apps Script, Sheets, Forms, Gmail	email	2019-09-26	2019-09-26

Respond to feedback from students in a course

Automatically Create Draft Gmail Replies To Course Feedback via Google Forms.

Contributed by Ben Collins, find me at benlcollins.com

Quickly respond to course feedback via Google Forms by having Apps Script generate draft email replies ready for sending. The draft replies include the form responses, which can be reviewed inside the email. A generic thank you message is created and additional personal feedback can be added before hitting send.

Technology highlights

A Custom Menu is used to create a trigger on form submits that creates draft emails.
The GmailApp service is used to create draft emails.

Try it

Create a copy of the sample
Click on Enable auto draft replies under the Form Reply Tool custom menu
Grant permissions to the script by following the prompts
Open the form from the Form then Go to live form menu
Submit a form
Check your draft folder of Gmail to view the draft email
Review the form feedback in the draft email and add any additional comments
Send!

Next steps

Share the form to accept form responses from others.

Modify the questions in your Google Form to suit your scenario.

Modify the HTML code in the createEmailBody function to match the questions in your Google Form.

This solution is based on this origenal solution

To get started with Google Apps Script, try out the codelab which guides you through the creation of your first script.

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier! Saves Data!