Create student report cards from Google Forms
End of term means dozens of report cards. With AutoDoc, teachers enter grades and a comment per student in a Google Form and each submission becomes a formatted report card, saved by class and optionally shared with the parent.
| Student | {{Student Name}} |
| Class | {{Class}} |
| Issued | {{_date}} |
| Subject | Grade |
|---|---|
| Mathematics | {{Maths}} |
| Science | {{Science}} |
| English | {{English}} |
How to automate report cards from Google Forms
Four steps, all inside Google Workspace. Output: PDF.
Build the form
Copy the ready-made form, or create a Google Form with questions like these. The question titles become your placeholders.
| Question title | Type | Example answer |
|---|---|---|
| Student Name | Short answer | Ethan Lim |
| Class | Dropdown | 5 Bestari |
| Term | Multiple choice | Term 2 |
| Maths | Short answer | A |
| Science | Short answer | B+ |
| English | Short answer | A- |
| Teacher Comment | Paragraph | Ethan is curious and works well in groups. |
Design the Google Docs template
Start from our Google Docs template (make a copy) or the .docx, or use your own. Type a placeholder wherever an answer should appear. It must match the question title exactly, in double braces. Built-ins such as {{_date}} and {{_responseId}} work too.
Connect it in AutoDoc
Open the form → Add-ons → AutoDoc. Pick the template and a Drive folder, choose PDF, and set the file name pattern:
{{Class}} - {{Student Name}} - {{Term}}Result: 5 Bestari - Ethan Lim - Term 2.pdf
Add a conditional document (optional)
Conditions support AND / OR groups and 13 operators, including equals, contains, exists, matches regex, > and >=.
Submit, and it’s delivered
Every new response creates the document in seconds.
Email is optional. Here, files are simply saved to Drive, ready to print or share.
Tips for report cards
- Pre-fill the form link per student so teachers only enter grades.
- Save report cards in one folder per class using a folder per form.
- Share the PDF with the parent’s email (collected in the form) as a viewer, with downloads allowed.
Who uses this
Frequently asked questions
Do I need one form per student?
No. One form, one response per student. Pre-filled links speed this up.
Can parents receive it?
Yes. Share with a parent email collected in the form, or email it.
Is there a limit?
Free generates 20 documents a day. A whole year group may need the Individual or Business plan.