{"product_id":"college-whatsapp-ai-receptionist-with-openai-supabase-n8n","title":"College WhatsApp AI Receptionist with OpenAI \u0026 Supabase (n8n)","description":"\u003ch3\u003eTurn your college admissions WhatsApp into an AI receptionist—powered by OpenAI + Supabase (built for n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow ingests your college documents into a Supabase vector store and then runs a WhatsApp-based admissions receptionist that can answer \u003cstrong\u003etext, voice notes, and image enquiries\u003c\/strong\u003e. It retrieves relevant information, reviews the response with a second OpenAI step, logs everything in Supabase, and sends the final reply back to the student via WhatsApp.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a WhatsApp message\u003c\/strong\u003e and detects whether the user sent \u003cem\u003etext\u003c\/em\u003e, a \u003cem\u003evoice note\u003c\/em\u003e, or an \u003cem\u003eimage\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTranscribes voice notes\u003c\/strong\u003e: fetches the WhatsApp media URL, downloads the audio, and uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to convert speech into text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUnderstands images\u003c\/strong\u003e: fetches the media URL, downloads the image, and uses \u003cstrong\u003eOpenAI Vision\u003c\/strong\u003e to extract readable content (combined with any image caption).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes input into a single “question” format\u003c\/strong\u003e, then creates a conversation record in \u003cstrong\u003eSupabase\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a draft reply with retrieval\u003c\/strong\u003e: an OpenAI chat agent uses the \u003cstrong\u003eSupabase vector-store retriever\u003c\/strong\u003e to find relevant college information (while chat history is stored in Postgres).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReviews and validates the answer\u003c\/strong\u003e: a second OpenAI reviewer checks the draft against the same Supabase knowledge base—then approves it, retries once with correction instructions, or falls back to a safe response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the final WhatsApp reply\u003c\/strong\u003e and updates the Supabase conversation record.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProspective students asking admission FAQs on WhatsApp (documents like brochures, eligibility notes, or course details pre-indexed).\u003c\/li\u003e\n  \u003cli\u003eStudents sending voice notes for guidance; the workflow transcribes, retrieves, and responds.\u003c\/li\u003e\n  \u003cli\u003eStudents uploading screenshots of requirements or forms; the workflow extracts text via Vision and answers using retrieval.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/workflow components:\u003c\/strong\u003e if, set, code, switch, Supabase, WhatsApp.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e WhatsApp Cloud API (WhatsApp trigger + WhatsApp nodes), \u003cstrong\u003eOpenAI\u003c\/strong\u003e (chat, transcription, Vision), \u003cstrong\u003eSupabase vector store\u003c\/strong\u003e (retrieval + Postgres chat history).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore logic:\u003c\/strong\u003e document ingestion → vector indexing → multimodal input handling → retrieval-augmented response → OpenAI reviewer step → Supabase logging → WhatsApp delivery.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45916245885107,"sku":"N8N-18798","price":4.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/jt86nD76aXVrpZMdb6q2b_nGPWAdAC.png?v=1788013516","url":"https:\/\/buyflowscripts.com\/products\/college-whatsapp-ai-receptionist-with-openai-supabase-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}