A fully automated weekly booking system built using Google Sheets and Google Apps Script. The system dynamically generates a structured booking form for each available Friday time slot using dropdown menus. Whenever a user selects a time slot, the system instantly updates the main Google Sheet, ensuring live, real-time visibility for all collaborators.
Key Features:
- Live booking updates directly inside Google Sheets
- Automatic Friday schedule generation
- Apps Script–powered form creation with dropdown selectors
- Real-time syncing between form selections and the sheet
- Weekly auto-reset system (clears bookings, preserves user notes, prepares sheet for next cycle)
- Controlled access—anyone with sheet access can see or enter bookings
- Error handling to prevent double-booking
- Lightweight, cloud-based solution with no external backend needed