What this automation does
When you enter student grades and rubric scores into a spreadsheet, this automation generates a personalized feedback comment for each student. The feedback references their specific strengths, areas for improvement, and next steps — not generic boilerplate.
Teachers spend enormous amounts of time writing individualized report card comments and assignment feedback. This automation handles the first draft, which teachers then review and personalize further. The AI adjusts tone based on the student's performance level and focuses feedback on growth rather than judgment.
Tools you need
- Google Sheets: Your gradebook or rubric data — structured with student names, scores, and criteria
- OpenAI API: Generates personalized feedback from grade data ($0.01-0.02 per student)
- Google Apps Script: Connects Sheets to OpenAI — runs the feedback generation with one click
How to set it up
Step 1: Prepare your gradebook in Google Sheets with columns for: student name, overall grade, rubric category scores (e.g., content, organization, mechanics), and any teacher notes or keywords for each student.
Step 2: Write a system prompt that specifies your feedback style: grade level, subject, tone (encouraging, direct, formal), length (2-4 sentences), and structure (start with strength, then area for improvement, then action step). Include 3-4 example feedbacks at different performance levels.
Step 3: Create a Google Apps Script that loops through each student row, sends their data to OpenAI with the system prompt, and writes the generated feedback into a 'Feedback' column. Add a menu item so you can run it with one click.
Step 4: Review every generated feedback before sharing with students. Edit for accuracy — the AI may miss nuances only you know as the teacher. After the first batch, refine the prompt based on what you changed.
Cost breakdown
| Item | Cost | Notes |
|---|---|---|
| Google Apps Script | $0 | Free with Google Workspace for Education |
| OpenAI API | $2-$8/mo | ~$0.015 per student at 150-500 students/term |
| Google Sheets | $0 | Already used for gradebooks |
| Setup time | 25-30 min | One-time per course |
| Total monthly | $2-$8/mo | Saves hours of feedback writing per term |
Frequently asked questions
When used as a drafting tool — yes. The AI generates a first draft that the teacher reviews, edits, and approves. The teacher's expertise and relationship with the student are irreplaceable. Most education organizations support AI-assisted feedback writing as long as teachers maintain oversight and the feedback is accurate.
Absolutely. The system prompt is customized per course. A 3rd-grade reading feedback prompt is very different from a 10th-grade chemistry prompt. You create one prompt per course, and it works for all students in that course. The AI adapts its vocabulary and feedback focus based on the prompt.