Live Dashboard
ACURATE CRM · INWANG AI Career Intelligence · Real-time overview
—
Total Leads
—
New
—
Hot Leads
—
Assessed
—
Paid
—
Follow-ups
—
Duplicates
—
Revenue
Lead Sources
Monthly Leads (2026)
Recent Leads
Last 8 entries
| ID | Student | Qual | Status | Score |
|---|
Today's Follow-ups
📅
No follow-ups today
Cluster Distribution
Counsellor Load
All Leads
Loading…
| ID ↕ | Student ↕ | Mobile | Qualification ↕ | Source | Counsellor ↕ | Hot Score | Status | Actions |
|---|
Pipeline Kanban
Drag leads across stages
Follow-ups
—
| ID | Student | Mobile | Counsellor | Last Notes | Due | Status |
|---|
Assessment Results
6D Career Scoring Engine data
All Assessments
—
| ID | Student | Primary Cluster | Readiness | Analytical | Comm | Learning | Decision | Motivation | Clarity | Stage |
|---|
Career Reports
Generate & track INWANG AI career reports
Report Queue
| ID | Student | Primary Cluster | Readiness | Package | Report Status | Counsellor | Actions |
|---|
Analytics
Conversion, source & performance insights
Leads by Source
Cluster Distribution
Qualification Breakdown
State-wise Leads
Conversion Funnel
Revenue Tracker
Package-wise earnings · INWANG AI
₹0
Total Revenue
₹0
Reports (₹149)
₹0
Report+Counselling (₹249)
Premium (₹399)
Enrolled Students
| ID | Student | Package | Amount | Date | Counsellor |
|---|
Counsellor Performance
Load, conversion & activity
Duplicate Leads
Review and manage duplicate entries
| Timestamp | Student | Mobile | Parent Mobile | Existing ID | Counsellor | Status |
|---|
Events & Batches
School visits, seminars, coaching drives
Settings
🔑 Change Password
Current Password
New Password
Confirm New Password
👤 Manage Counsellors
👤 My Profile
My Email
My Mobile / WhatsApp
🔔 New Lead Notifications
WhatsApp Alert — New Lead
Naya lead aane par aapko WhatsApp message milega
Sound Alert
Naya lead aane par sound bajega
Admin WhatsApp Number (for alerts)
New lead aane par is number pe WhatsApp message jayega
🔗 Google Sheets Connection
Apps Script Web App URL
Deploy AppScript as Web App → paste URL → full live CRM
Counsellor Login Name
Set this to filter leads by counsellor automatically
📋 AppScript Web App Setup
1. Google Sheet → Extensions → Apps Script
2. Add
3. Deploy → New deployment → Web App → Anyone → Deploy
4. Copy URL → paste above
2. Add
doGet() function (code given below)3. Deploy → New deployment → Web App → Anyone → Deploy
4. Copy URL → paste above
function doGet(e) {
var action = e.parameter.action;
if(action==='leads') return getLeadsJSON();
if(action==='assessments') return getAssessJSON();
return ContentService.createTextOutput('{}');
}
var action = e.parameter.action;
if(action==='leads') return getLeadsJSON();
if(action==='assessments') return getAssessJSON();
return ContentService.createTextOutput('{}');
}