Contact person: Business Client

Phone:Show

Email:Show

Location: Cabo San Lucas, Mexico

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"I am so close to launch a website on google sites, and need some help with google app script, the website is for course booking and payments but I am struggling with:

The Enrollment System
Replaced the old Google Form with a custom multi-step Enrollment Form integrated directly into the site.
Fetches real course dates from Google Calendar, shows “Request to open this course” for unscheduled ones, and stores submissions in Supabase.
Includes all state-required legal and compliance fields per document.
Features smooth navigation, multiple Enroll Now CTAs, validation, and a success confirmation flow.

Calendar Integration
Initially integrated an interactive Google Calendar + Supabase schedule system with real-time booking and email confirmations.
Later simplified and replaced with an embedded Google Calendar iframe showing all course events in a monthly view (Pacific Time), fully responsive.

Email Automation
Implemented automated confirmation and reminder emails (via Resend API and Supabase Edge Functions):
Immediate confirmation with course details and calendar invite
Reminders 7 days and 1 day before the course

Infrastructure
Used Supabase Edge Functions for secure data handling (fetching calendar events, processing enrollments, and sending emails).
Integrated professional HTML email templates and ensured seamless API/" (client-provided description)