How it worksDemo data
The funnel, the build phases and the technology behind the dashboard.
Lead journey
What happens to every person who shows interest
1
Capture
QR at meeting desk · Visit form · WhatsApp “Hi” · member referral · Instagram link · event standee
2
Create lead
Duplicate check by phone → chapter & owner assigned → stage New
3
Welcome (automatic)
WhatsApp welcome + invite within a minute → stage Contacted
4
Confirm & remind
Visitor taps Confirm → Invited · reminder the day before · location + host 2 hours before
5
Visit
QR check-in at the venue → Visited · thank-you + rating message
6
Follow-up
Day 3 membership message · owner calls · Day 7 success story
7
Close
Application → fee → induction → Member (or Lost with a reason)
8
Grow
Renewal reminders · sponsorships · events · referrals between members
Build phases
Phase 1 — Demo
1 weekThis dashboard with demo data, to agree on what BNI Jodhpur needs.
Phase 2 — Capture + WhatsApp
2 weeksFastAPI + Supabase backend, forms and QR codes, WhatsApp Cloud API sequences, webhook for replies and read receipts.
Phase 3 — Live dashboard
1–2 weeksThis UI on real data, logins for Director / chapter leadership / team, edit stage, notes and owners.
Phase 4 — Posters + events
1–2 weeksMahotsav-style sponsor and member post generator, auto-send to sponsor, Instagram publish, event tickets with QR entry.
Phase 5 — AI layer
ongoing“Who can help me with X?” member-finder bot, lead scoring, weekly AI summary to the Director.
Technology
- Dashboard
- Astro (this app)
- Backend API
- Python · FastAPI
- Database & login
- Supabase (Postgres)
- Meta WhatsApp Cloud API (official)
- Scheduler
- APScheduler → Celery + Redis
- Posters
- HTML templates → Playwright → PNG
- AI
- LLM API for captions, scoring and the member-finder bot
- Hosting
- Cloudflare / Railway
Privacy: consent on every form, “STOP” opt-out on WhatsApp, data stays in BNI Jodhpur's own database, role-based access.
Demo build · every name, number and amount is fictional.