Below is the form I'm using as an example of this process. It is linked to the spreadsheet that holds the personal information.
Here's the spreadsheet that holds the data from the form. Sheet1 holds the data including name, homeroom, parent email address, student email address and anything else that I want to pre-fill into the form.
At the risk of repeating myself, anything you need from Sheet1 data MUST be one of the questions on the form, and MUST be pre-filled.
Form Responses 1 holds the information from the respondents.
(Copy of Sheet1 is just an example with the pre-filled links completed.)
Below is a sample template . Originally this was set up as a rubric. I entered my comments and scores on a form, then used autoCrat to email the merged doc to the student. Links to other templates are here–see step 2.
And there's More Resources.