Student Portal Webhook: Supabase Registration, Gmail Replies & CGPA

Turn a Student Portal Webhook into automated Supabase registration, AI email replies, and CGPA calculation

This n8n workflow exposes a single webhook endpoint for a student portal and routes requests by action to key student services—Supabase-backed registration/login, feedback capture with Groq-generated Gmail replies, and CGPA calculation using Mistral.

What this workflow does

• Receives a POST request on a webhook and reads an action value to determine what to run (registration, login, feedback submission, CGPA calculation, or profile update).
• Registration: validates student inputs (name, email, register number, password), inserts the record into a Supabase table, sends a Gmail confirmation email, and returns a JSON success/failure response.
• Login: looks up the student in Supabase by email, checks the submitted password, and returns JSON indicating success or invalid credentials.
• Feedback submission: normalizes student and feedback fields, stores feedback in a Supabase table, uses Groq (Llama) to generate a personalized thank-you email, sends the reply via Gmail, and returns JSON including a preview.
• CGPA calculation: sends semester GPA/credit data to a Mistral AI agent, parses and validates returned JSON, and responds with computed CGPA, total credits, and semesters used.
• Profile updates: validates required profile fields, verifies the student exists in Supabase by register number, and updates a “Student Details” table.

Use cases

• Build a student portal API where frontend actions hit one webhook URL.
• Automate feedback follow-ups with AI-assisted thank-you replies sent via Gmail.
• Compute and return CGPA results instantly from submitted semester data using Mistral.
• Keep student identity and profiles synchronized in Supabase.

Technical details

• n8n webhook router driven by action
• Nodes/logic: if, set, code, switch, webhook, gmail
• Supabase for student registration/login, feedback storage, and “Student Details” updates
• Groq (Llama) for generating Gmail reply emails; Gmail for sending them
• Mistral agent for CGPA calculation and JSON parsing