Predict no-show risk and route reminders with Google Calendar, Sheets, Slack and OpenAI

Who is this for Business owners and service providers who want to reduce no-show rates for appointments booked via Google Calendar.

What this workflow does This workflow fetches tomorrow's Google Calendar bookings, looks up each customer's no-show history from Google Sheets, and calculates a risk score (0-100) from four weighted signals. Based on the score, it routes to three automated responses: a Slack alert plus AI re-confirmation email for super high risk, a friendly AI reminder email for high risk, and a silent log for low risk.

Setup 1. Create a Google Sheets file with a tab named customerhistory (columns: customeremail, customername, totalbookings, noshowcount, lastbookingdate, laststatus) 2. Open the Set Configuration node and fill in your Sheet ID and Slack channel 3. Connect Google Calendar, Google Sheets, Gmail, Slack, and OpenAI credentials 4. Activate the workflow

Requirements - Google Calendar with appointment bookings - Google Sheets for customer history - Slack workspace for alerts - OpenAI API key (used only for generating email text) - Gmail account with OAuth2 access

How to customize - Adjust the risk thresholds in Set Configuration (default: 70 for Super High, 40 for High) - Edit the AI prompts in Generate Urgent Message and Generate Reminder nodes to match your tone - Replace Slack with Discord webhook if preferred

Important note Risk scoring is 100% rule-based. AI is used only for generating reminder text, never for the risk judgment itself.