{"product_id":"student-onboarding-ai-exam-grading-workflow-n8n-gmail-sheets","title":"Student Onboarding + AI Exam Grading Workflow (n8n, Gmail, Sheets)","description":"\u003ch3\u003eAutomate student onboarding, timed exam reminders, and AI grading with n8n\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eStudent Onboarding + AI Exam Grading Workflow\u003c\/strong\u003e in \u003cstrong\u003en8n\u003c\/strong\u003e delivers a complete, end-to-end pipeline: enroll a student, send onboarding emails on a schedule, automatically grade new exam responses with \u003cstrong\u003eOpenAI\u003c\/strong\u003e, and generate \u0026amp; email a \u003cstrong\u003ePDF certificate\u003c\/strong\u003e for passing students.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCaptures enrollment\u003c\/strong\u003e: A new course enrollment submitted via an \u003cstrong\u003en8n Form\u003c\/strong\u003e is received and student details are normalized.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRecords and notifies\u003c\/strong\u003e: The enrollment is appended to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, a welcome email is sent via \u003cstrong\u003eGmail\u003c\/strong\u003e, and a new-enrollment notification is posted to a \u003cstrong\u003eSlack\u003c\/strong\u003e channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns timed onboarding\u003c\/strong\u003e: The workflow \u003cstrong\u003ewaits 25 days\u003c\/strong\u003e, sends an exam reminder email, then \u003cstrong\u003ewaits again\u003c\/strong\u003e and emails the final exam access link via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers on exam submissions\u003c\/strong\u003e: When a new exam response row is added to a Google Sheets responses spreadsheet, it looks up the matching enrollment by email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks eligibility\u003c\/strong\u003e: It verifies the student is enrolled and ensures eligibility by calculating whether at least \u003cstrong\u003e30 days\u003c\/strong\u003e have passed since enrollment.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI-based grading\u003c\/strong\u003e: For eligible students, the exam response JSON is sent to \u003cstrong\u003eOpenAI\u003c\/strong\u003e for automated grading. The workflow parses the returned evaluation JSON.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates results\u003c\/strong\u003e: It emails a detailed HTML result report via \u003cstrong\u003eGmail\u003c\/strong\u003e and updates the student’s \u003cstrong\u003epass\/fail status\u003c\/strong\u003e in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCertificate generation on pass\u003c\/strong\u003e: If the student passes, it copies a \u003cstrong\u003eGoogle Docs\u003c\/strong\u003e certificate template, replaces the placeholder name, exports the document as a \u003cstrong\u003ePDF\u003c\/strong\u003e from \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and emails the certificate as an attachment. If the student fails, it emails a failure notice, then waits \u003cstrong\u003e4 days\u003c\/strong\u003e (before the next step in the flow).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCourse operators who need automated student follow-up and exam logistics without manual outreach\u003c\/li\u003e\n  \u003cli\u003eSaaS teams running cohort onboarding with scheduled email reminders and results tracking in Google Sheets\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who want an n8n workflow that combines Sheets lookups, OpenAI grading, and Drive-based certificate delivery\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Forms\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (enrollments + exam responses)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e (welcome, reminders, exam link, HTML result, certificate\/failure emails)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e (new enrollment notification)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e (AI exam grading using submitted exam response JSON)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Drive\u003c\/strong\u003e + \u003cstrong\u003eGoogle Docs\u003c\/strong\u003e (template copy, placeholder replacement, PDF export)\u003c\/li\u003e\n  \u003cli\u003eCore n8n workflow nodes include \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, and \u003cstrong\u003ewait\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938164236467,"sku":"N8N-19049","price":76.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/UKN9lsGRqxcn4jFzcdNcB_PRTsAB5O.png?v=1788339814","url":"https:\/\/buyflowscripts.com\/products\/student-onboarding-ai-exam-grading-workflow-n8n-gmail-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}