Students will build an AI chatbot integrating WhatsApp, N8N, OpenAI, Supabase, and RAG, culminating in a live demo presentation. Each class includes theory, hands-on practice, and assignments.
The final project is graded on 100 points, distributed as follows:
Stage | Task | Points | Grading Criteria |
---|---|---|---|
Class 1 | Define chatbot scope & set up infrastructure | 10 pts | Clear definition, proper setup of N8N & Supabase |
Class 2 | Connect WhatsApp API & process messages | 15 pts | Successful message reception & logging in Supabase |
Class 3 | Integrate OpenAI (GPT-4) for chatbot responses | 15 pts | AI-generated responses with well-structured prompts |
Class 4 | Implement Retrieval-Augmented Generation (RAG) | 15 pts | Proper knowledge base integration & query retrieval |
Class 5 | Store chat history & analyze conversations | 15 pts | Well-structured Supabase storage & insightful analytics |
Class 6 | Automate workflows using N8N | 15 pts | Successful chatbot automation & scheduled tasks |
Class 7 | Deploy & fine-tune chatbot | 15 pts | Optimized chatbot performance & deployment setup |
Class 8 | Live demo & final presentation | 10 pts | Clear explanation, working chatbot, innovation |
✔ Late submissions: -2 points per day delay.
✔ Extra credit: Up to +5 pts for outstanding creativity or business impact.
Each class is 2 hours long, blending theory and hands-on activities.
🎯 Objective: Understand chatbot fundamentals & set up the project.
🛠 Hands-On:
- Define chatbot purpose, audience & workflows.
- Set up N8N, Supabase & obtain WhatsApp API credentials.
📌 Assignment:
- Write a Chatbot Project Summary (business goal, features, users).
- Install & configure N8N and Supabase.
🎯 Objective: Integrate WhatsApp API with N8N to receive messages.
🛠 Hands-On:
- Set up WhatsApp API & test message reception.
- Create an N8N workflow for WhatsApp message logging.
📌 Assignment:
- Ensure WhatsApp API is fully configured.
- Build an N8N workflow to log messages in Supabase.
🎯 Objective: Use OpenAI (GPT-4) for chatbot responses.
🛠 Hands-On:
- Set up OpenAI API & integrate it into N8N.
- Experiment with prompt engineering to refine responses.
📌 Assignment:
- Test different prompt styles to enhance chatbot responses.
- Store chat history in Supabase for personalization.
🎯 Objective: Improve chatbot intelligence using knowledge retrieval.
🛠 Hands-On:
- Set up a vector database for RAG.
- Implement document embeddings & query processing.
📌 Assignment:
- Upload sample knowledge base documents.
- Test retrieval accuracy with sample queries.
🎯 Objective: Store and analyze chatbot conversations in Supabase.
🛠 Hands-On:
- Design a chat history table in Supabase.
- Implement querying & analytics to improve interactions.
📌 Assignment:
- Visualize chat statistics (most common queries, response time).
- Generate insights on how to enhance chatbot interactions.
🎯 Objective: Automate chatbot interactions and tasks.
🛠 Hands-On:
- Create automated chatbot actions based on user intent.
- Implement scheduled tasks (e.g., follow-ups, reminders).
📌 Assignment:
- Develop an automated response flow for common user interactions.
- Configure alerts for unanswered queries.
🎯 Objective: Deploy the chatbot for real-world use & optimize performance.
🛠 Hands-On:
- Deploy chatbot for external testing.
- Optimize response speed and database queries.
📌 Assignment:
- Collect user feedback & iterate chatbot improvements.
- Ensure chatbot is ready for final demo.
🎯 Objective: Showcase chatbot functionality & key learnings.
🛠 Hands-On:
- Each student/team presents their chatbot.
- Showcase real-time interaction & workflow automation.
📌 Final Submission:
- Final report (architecture, features, challenges, improvements).
- GitHub repository with chatbot code.
- Live demo evaluation based on chatbot functionality & creativity.
By the end of the course, students will have a fully functional AI chatbot integrated with WhatsApp, OpenAI, Supabase, and N8N, capable of retrieving information via RAG, storing conversations, and automating interactions.
Each student/team will pitch their chatbot and demonstrate it working live.
✔ Bonus: Up to +5 pts for exceptional performance, innovation, or UX design.