Clinical Decompression Automated Session‑Buffer System
Scheduling workflow that watches new session intake rows in Google Sheets, routes high‑intensity cases through a conflict‑protected buffer booking, creates timezone‑aware buffer events in Google Calendar, and marks the sheet row as processed, with dedicated email alerts for sheet or calendar failures.
Make · workflow canvasproduction build
Context
Clinical teams needed a way to automatically reserve protected buffer time around high‑intensity decompression sessions while avoiding double bookings and manual date/time handling, especially across timezones.
Approach
Built a single Make.com scenario that watches a session intake sheet, parses and formats each row, splits high‑intensity sessions from the fallback path, searches the calendar for conflicts, applies a duplicate/conflict guard, builds timezone‑aware datetimes, creates a buffer event, and updates the source row to ‘processed’, with error handlers that email the team if either the sheet or calendar step fails.
Architecture
Watch New Session Intake (Google Sheets)
Parse & Format Session Data
Send Google Sheet Error Alert on failure
High Intensity Route
Calendar - Search Events
Duplicate/Conflict Guard
Built Timezone Aware Datetimes
Create Event (Buffer Block)
Sheets - Update Row (Mark as Processed)
High‑intensity path ends; Non‑high‑intensity
fallback
Send Google Calendar Error Alert on calendar‑side failure
Send Google Sheet Error Alert on sheet‑side failure
