Student Onboarding + AI Exam Grading Workflow (n8n, Gmail, Sheets)

Automate student onboarding, timed exam reminders, and AI grading with n8n

This Student Onboarding + AI Exam Grading Workflow in n8n delivers a complete, end-to-end pipeline: enroll a student, send onboarding emails on a schedule, automatically grade new exam responses with OpenAI, and generate & email a PDF certificate for passing students.

What this workflow does

• Captures enrollment: A new course enrollment submitted via an n8n Form is received and student details are normalized.
• Records and notifies: The enrollment is appended to Google Sheets, a welcome email is sent via Gmail, and a new-enrollment notification is posted to a Slack channel.
• Runs timed onboarding: The workflow waits 25 days, sends an exam reminder email, then waits again and emails the final exam access link via Gmail.
• Triggers on exam submissions: When a new exam response row is added to a Google Sheets responses spreadsheet, it looks up the matching enrollment by email.
• Checks eligibility: It verifies the student is enrolled and ensures eligibility by calculating whether at least 30 days have passed since enrollment.
• AI-based grading: For eligible students, the exam response JSON is sent to OpenAI for automated grading. The workflow parses the returned evaluation JSON.
• Updates results: It emails a detailed HTML result report via Gmail and updates the student’s pass/fail status in Google Sheets.
• Certificate generation on pass: If the student passes, it copies a Google Docs certificate template, replaces the placeholder name, exports the document as a PDF from Google Drive, and emails the certificate as an attachment. If the student fails, it emails a failure notice, then waits 4 days (before the next step in the flow).

Use cases

• Course operators who need automated student follow-up and exam logistics without manual outreach
• SaaS teams running cohort onboarding with scheduled email reminders and results tracking in Google Sheets
• Automation engineers who want an n8n workflow that combines Sheets lookups, OpenAI grading, and Drive-based certificate delivery

Technical details

• n8n Forms, Google Sheets (enrollments + exam responses)
• Gmail (welcome, reminders, exam link, HTML result, certificate/failure emails)
• Slack (new enrollment notification)
• OpenAI (AI exam grading using submitted exam response JSON)
• Google Drive + Google Docs (template copy, placeholder replacement, PDF export)
• Core n8n workflow nodes include if, set, code, and wait