Professional Healthcare Appointment Management System
đ§ Debug Mode Active - This will help diagnose connection issues
đ§ API Connection Debugger
â Your API URL is already configured! Click "Test Connection" below.
đ Test Results
đ Schedule New Appointment
âī¸ Quick Setup Guide
đ Step 1: Prepare Your Google Sheet
Create a new Google Sheet
Create two sheets named exactly: Doctors and Appointments
Add headers as specified in the documentation
đ Step 2: Deploy Apps Script
In your Google Sheet: Extensions â Apps Script
Paste the backend code from apps-script-backend.gs
Update the SHEET_ID constant with your spreadsheet ID
Click Deploy â New deployment â Web app
Set "Who has access" to Anyone
Copy the Web App URL
đ Step 3: Configure This Page
Go to the "Debug & Test" tab
Paste your Web App URL
Click "Test Connection" to verify it works
If successful, you can start booking appointments!
đĄ
Common Issues:
âĸ Make sure deployment is set to "Anyone" access
âĸ Sheet names must match exactly (case-sensitive)
âĸ Wait a few seconds after deployment before testing
âĸ Check the Apps Script execution log for errors