{"product_id":"student-portal-webhook-supabase-registration-gmail-replies-cgpa","title":"Student Portal Webhook: Supabase Registration, Gmail Replies \u0026 CGPA","description":"\u003ch3\u003eTurn a Student Portal Webhook into automated Supabase registration, AI email replies, and CGPA calculation\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow exposes a single \u003cstrong\u003ewebhook endpoint\u003c\/strong\u003e for a student portal and routes requests by \u003cem\u003eaction\u003c\/em\u003e to key student services—\u003cstrong\u003eSupabase-backed registration\/login\u003c\/strong\u003e, \u003cstrong\u003efeedback capture with Groq-generated Gmail replies\u003c\/strong\u003e, and \u003cstrong\u003eCGPA calculation using Mistral\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a POST request\u003c\/strong\u003e on a webhook and reads an \u003ccode\u003eaction\u003c\/code\u003e value to determine what to run (registration, login, feedback submission, CGPA calculation, or profile update).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRegistration:\u003c\/strong\u003e validates student inputs (name, email, register number, password), inserts the record into a \u003cstrong\u003eSupabase\u003c\/strong\u003e table, sends a \u003cstrong\u003eGmail confirmation email\u003c\/strong\u003e, and returns a JSON success\/failure response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogin:\u003c\/strong\u003e looks up the student in \u003cstrong\u003eSupabase\u003c\/strong\u003e by email, checks the submitted password, and returns JSON indicating success or invalid credentials.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFeedback submission:\u003c\/strong\u003e normalizes student and feedback fields, stores feedback in a \u003cstrong\u003eSupabase\u003c\/strong\u003e table, uses \u003cstrong\u003eGroq (Llama)\u003c\/strong\u003e to generate a personalized thank-you email, sends the reply via \u003cstrong\u003eGmail\u003c\/strong\u003e, and returns JSON including a preview.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCGPA calculation:\u003c\/strong\u003e sends semester GPA\/credit data to a \u003cstrong\u003eMistral AI agent\u003c\/strong\u003e, parses and validates returned JSON, and responds with computed CGPA, total credits, and semesters used.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProfile updates:\u003c\/strong\u003e validates required profile fields, verifies the student exists in Supabase by register number, and updates a “Student Details” table.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuild a student portal API where \u003cstrong\u003efrontend actions\u003c\/strong\u003e hit one webhook URL.\u003c\/li\u003e\n  \u003cli\u003eAutomate \u003cstrong\u003efeedback follow-ups\u003c\/strong\u003e with AI-assisted thank-you replies sent via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCompute and return \u003cstrong\u003eCGPA results\u003c\/strong\u003e instantly from submitted semester data using \u003cstrong\u003eMistral\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eKeep student identity and profiles synchronized in \u003cstrong\u003eSupabase\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n webhook\u003c\/strong\u003e router driven by \u003ccode\u003eaction\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003eNodes\/logic: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e, \u003cstrong\u003ewebhook\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupabase\u003c\/strong\u003e for student registration\/login, feedback storage, and “Student Details” updates\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroq (Llama)\u003c\/strong\u003e for generating Gmail reply emails; \u003cstrong\u003eGmail\u003c\/strong\u003e for sending them\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMistral\u003c\/strong\u003e agent for CGPA calculation and JSON parsing\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45850514915507,"sku":"N8N-18302","price":19.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/lHO6GnPKcFDmyc8YPGTvi_BzcXlGaJ.png?v=1786870997","url":"https:\/\/buyflowscripts.com\/products\/student-portal-webhook-supabase-registration-gmail-replies-cgpa","provider":"N8N Commerce","version":"1.0","type":"link"}