Basirah AI

n8n logic workflow

✨ Inspiration

The primary inspiration for Basirah AI came from the realization that educators often spend more time analyzing spreadsheets than actually teaching. We noticed a significant gap between collecting exam data and translating that data into meaningful educational interventions. We wanted to build a "second eye" for teachers—a tool that doesn't just show numbers, but provides actionable insights to improve student outcomes.

🛠️ How We Built It

Basirah AI is built on a seamless integration of modern No-Code and AI technologies:

Frontend: Built with Glide, providing a user-friendly mobile interface for educators to upload CSV files and view interactive dashboards.
Automation Engine: n8n acts as the brain, orchestrating the complex data flow between different services via Webhooks.
Logic & Processing: Custom JavaScript nodes within n8n process raw data to calculate performance metrics and detect maximum scores dynamically.
AI Integration: Powered by the cutting-edge OpenAI GPT-5.2 model, which analyzes the processed data to generate high-precision pedagogical recommendations tailored to the students' needs.
Database: Airtable serves as our dynamic database, storing student results and AI insights in real-time.

📊 Methodology & Math

To ensure accuracy, the system calculates the overall class performance ($P$) using the formula:

$$P = \left( \frac{\sum_{i=1}^{n} S_i}{n \times M} \right) \times 100$$

Where:

$S_i$ is the total score of student $i$.
$n$ is the number of students.
$M$ is the maximum possible score (detected dynamically from the dataset).

🚀 Challenges We Faced

The Learning Curve (First-Time Users): This was our most significant challenge; our team had never used n8n, Airtable, Glide, or OpenAI APIs before this hackathon. Mastering the orchestration of these diverse tools in such a short timeframe required intense learning and rapid prototyping.
Dynamic Data Parsing: Building a robust logic in n8n to automatically handle variable CSV column names (e.g., "Total Score" vs "Score") without manual intervention was a technical hurdle we overcame using custom JavaScript.
Workflow Orchestration: Synchronizing multiple tools to ensure that the dashboard updates instantly after a file upload required precise error handling and sequential execution.

🏆 What We Are Most Proud Of

We are incredibly proud of the fact that we built a fully functional, AI-integrated platform from scratch, using a completely new tech stack that we mastered within the duration of this hackathon. Leveraging the power of GPT-5.2 to provide real-time educational insights is a milestone we are thrilled to have achieved.

🧠 What We Learned

Beyond the technical skills in automation and AI, we learned the importance of User-Centric Design in education. We discovered that AI is most powerful when it simplifies complex data into human-readable, supportive advice for teachers.