Executive Clinical Portal · Dr. Bhatt's Physiotherapy & Advanced Rehab

Total Clinic Leads

Unified Records Across All Channels

Action Needed (Pending)

Awaiting Staff Confirmation / Call

Confirmed Bookings

Scheduled OPD & Home Visits

AI Bot Consultations

Interactive Patient Triage Sessions

Quick Views:

Live Patient Submissions & Bookings

Showing 0 entries

Time & Token	Patient & Direct Connect	Center & Timing	Chief Concern / Clinical Query	Type	Status Workflow	Actions
Loading clinical submissions...

AI Chatbot Interaction Transcripts

Every live conversation conducted by prospective patients on the website.

Loading chat sessions...

Google Sheets Live Sync Configuration

Direct spreadsheet synchronization for real-time lead capture and email alerts.

radheymohanmishra13@gmail.com

Webhook Connection Status: Checking...

Live 8-Column Architecture (Clean & Intuitive):

1. Date & Time

2. Patient Name

3. Phone Number

4. Health Concern

5. Clinic Center

6. Timing Slot

7. Booking ID

8. Status

Google Apps Script Code (Code.gs)

Copy & deploy in Extensions → Apps Script

/* Click button above to copy full Google Apps Script Code */

Clinical Protocols & Knowledge Base

These verified clinical facts guide both Dr. Bhatt's AI Assistant and staff answering patient queries.

Loading clinical protocols...

Portal Maintenance & Database Controls

Administrative utilities for database management and resetting dummy records.

Reset Dummy & Test Records

Clears all dummy test enquiries, mock conversations, and dummy CSV records so your portal starts fresh with only genuine patient leads.

Security & Session Status

• Authentication: HMAC-SHA256 Token (7-Day Duration)

• Server State: Persistent — Restarts do not log out admin

• Lead Storage: Dual-tier (Local SQLite Database + Real-time Google Sheets Webhook)

Clinical Command