Tools used: Google Apps Script, Google Calendar, Google Sheets

🧾 Overview

This project automated the extraction of relevant consult bookings from a Google Calendar into a structured Google Sheet, helping operational and clinical teams stay updated with upcoming consults over a rolling 30-day period.

The goal was to surface only the consult types that required action or monitoring — while filtering out irrelevant events like internal sessions or shadowing blocks.

🧩 Key Features

✅ Calendar Integration

• Connected directly to the [email protected] calendar
• Pulled all events within the next 30 days
• Parsed event details including:
  • Title
  • Start date and time
  • Guest email
  • Event type (Initial, Progress, Express, etc.)

✅ Filtering & Labeling Logic

• Used regex and keyword logic to detect consultation-type events
• Skipped events with blocked phrases like “Jennifer Davies” or “Video Consult”
• Canceled events were marked accordingly
• Titles were mapped to internal labels:
  • “Initial Consultation” → POST CP
  • “Health Progress Consultation” → Health Progress
  • “Express Booking” → Express
  • “Priority Booking” → Priority ⭐️
  • “Extended Follow Up” → Extended
  • “Support Plus Consult Booking” → Support Plus
  • Canceled Consults → Canceled

✅ Sheet Syncing and De-duplication

• Used the event ID to prevent duplicates