# Reduce appointment no-shows and refill slots with Google Calendar, Sheets, Twilio, Gmail and OpenAI

> Quick Overview This workflow monitors Google Calendar appointments, uses Google Sheets as a client/waitlist database and log, and sends confirmations, waitlist offers, and recall messages via Twilio SMS or Gmail email, using OpenAI to classify incoming replies and update bookings and reporting. How it works 1. Runs every 15 minutes on a schedule and also reacts immediately to inbound replies received through Twilio (SMS) or Gmail (email). 2. Loads Clients, Services, Waitlist, and Log tabs from Google Sheets, then reads upcoming Google Calendar events for the configured time window. 3. Plans the next actions by logging confirmations (including a 48-hour ask and 24-hour nudge), freed-slot waitlist offers in batches, recall messages, and daily/weekly staff reports based on calendar state and prior log history. 4. Appends all planned actions to the Google Sheets Log first, then sends the resulting outbound messages via Twilio SMS or Gmail email depending on each recipient’s available chann

- **Domain**: `n8n-workflow-20316.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/20316
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20316.n8n.io
- Documentation: https://n8n.io/workflows/20316