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 Create a Google Sheets file with a tab named customer_history (columns: customer_email, customer_name, total_bookings, no_show_count, last_booking_date, last_status) Open the Set Configuration node and fill in your Sheet ID and Slack channel Connect Google Calendar, Google Sheets, Gmail, Slack, and OpenAI credentials 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.