Respond to feedback from students in a course

Use Apps Script to quickly create draft email replies to course feedback via Google Forms.

Last updated: September, 2019

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.

Generate draft Gmail replies to Google Form Responses automatically

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

  1. Create a copy of the sample
  2. Click on Enable auto draft replies under the Form Reply Tool custom menu
  3. Grant permissions to the script by following the prompts
  4. Open the form from the Form then Go to live form menu
  5. Submit a form
  6. Check your draft folder of Gmail to view the draft email
  7. Review the form feedback in the draft email and add any additional comments
  8. 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 original solution

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

Feedback

Were you able to get the solution up and running?

If you have an idea for another solution you'd like to see featured in our gallery submit a request on the GitHub issue tracker.