StudyFlow - WhatsApp Automated Study Reminder System

4th Semester DBMS Mini Project

A full-stack web application that automates the scheduling and delivery of study materials and reminders directly to WhatsApp groups using Green API.

Problem Statement

Engineering students often forget to revise important topics on time or struggle to share notes with classmates. Manually sending reminders and PDFs via WhatsApp is time-consuming and easy to miss.

Features

• Upload and organize PDF study materials by subject
• Interactive calendar view for scheduling reminders
• Support for multiple WhatsApp groups
• Automated delivery of text + PDF attachments
• Real-time delivery Log Book with success/failure tracking
• Clean responsive dashboard with analytics
• Google Drive PDF link support

Tech Stack

• Frontend: HTML, Tailwind CSS, EJS, FullCalendar.js
• Backend: Node.js + Express.js
• Database: MySQL (5 normalized tables)
• Automation: node-cron + Green API
• Key Concepts: Relational Database Design, Cron Jobs, API Integration

How It Works

1. Users upload materials and schedule reminders via the dashboard.
2. A cron job checks due tasks every minute.
3. The system sends messages/PDFs to WhatsApp groups.
4. All deliveries are logged with status.

Screenshots

1. Welcome page and dashboard

---

2.Scheduling page and calendar page

---

3.Log book page and filling of a new schedule

---

4.Database(MYSQL) and result in WhatsApp group

What I Learned

• Full-stack development with Node.js and MySQL
• Database normalization and API integration
• Building practical automation tools for students