AIG ONBOARDING WEBSITE

Comprehensive Admin Dashboard for AI Gurukul Journey Management

The AIG Onboarding Website is a sophisticated web-based admin dashboard designed to streamline and manage the complete AI Gurukul mentee and intern journey from initial application to successful completion. This secure, professional platform provides comprehensive stage-wise management with automated workflows.

Built with modern technologies and featuring real-time data synchronization with Google Sheets, the platform ensures efficient candidate tracking, automated email notifications, and seamless administrative oversight throughout the entire onboarding process.

Key Features

🔐 Authentication & Security

  • Secure login system with environment variable-based authentication
  • 24-hour automatic session expiry
  • Route protection and unauthorized access prevention

📊 Stage Management System

  • 4-Stage journey tracking: Application → Assignment → Interview → Onboarding
  • Real-time status updates with instant Google Sheets sync
  • Status reset functionality
  • Live progress statistics for each stage

📧 Automated Email System

  • Stage-specific email templates with dynamic content
  • Automatic CC to all team members on notifications
  • Dynamic deadline calculation from current date
  • Role-based content for Mentees vs Interns

🎯 Advanced Data Management

  • Multi-sheet integration: Mentees, Interns, Mentors, Submissions
  • In-line field editing with save/clear functionality
  • Mentor assignment with dropdown selection
  • 3-month validation for completion tracking

4-Stage Workflow Process

1

Application Review

Initial application screening with Pass/Fail decisions. Pass action sends assignment email with dynamic deadlines.

2

Assignment Evaluation

Review assignment submissions with clickable links. Pass action sends interview invitation email.

3

Interview Management

Interview scheduling with mentor assignment and remarks. Pass action sends onboarding email.

4

Onboarding & Completion

3-month tracking with project assignments and feedback. Pass action sends certificate completion email.

Development Team

Yashwanth Varma

Impact & Results

80%
Reduction in manual screening time
100%
Automated email notifications
24/7
Real-time data synchronization
4
Complete stage management