Predict no-show risk and route reminders with Google Calendar, Sheets, Slack and OpenAI
Research & reporting workflow for n8n with 13 active steps. Starts with Schedule Trigger. Uses OpenAI. Integrations include Google Calendar, Google Sheets, OpenAI, Slack, Gmail.
What it does
13 active nodes · Starts with Schedule Trigger.
Steps in the template include:
- Daily at 9 AM (Schedule Trigger)
- Set Configuration (Edit Fields (Set))
- Get Tomorrow's Bookings (Google Calendar) — getAll
- Extract Customer Info (Edit Fields (Set))
Nodes and integrations
- Schedule Trigger
- Edit Fields (Set) ×2
- Google Calendar
- Google Sheets ×2
- Code
- Switch
- OpenAI ×2
- Slack
- Gmail ×2
See the author’s step names
- Daily at 9 AM (Schedule Trigger)
- Set Configuration (Edit Fields (Set))
- Get Tomorrow's Bookings (Google Calendar) — getAll
- Extract Customer Info (Edit Fields (Set))
- Lookup Customer History (Google Sheets)
- Calculate Risk Score (Code)
- Route by Risk Level (Switch)
- Generate Urgent Message (OpenAI)
- Send Slack Alert (Slack)
- Send Re-confirmation Email (Gmail)
- Generate Reminder (OpenAI)
- Send Reminder Email (Gmail)
- Log Low-Risk Booking (Google Sheets) — append
Accounts and credentials
- Google Calendar
- Google Sheets
- OpenAI access
- Slack
- Gmail
AI models and swaps
OpenAI · Model or API operation
gpt-4o-mini in Generate Urgent Message. Provider-specific step. A different provider requires edits and testing.
OpenAI · Model or API operation
gpt-4o-mini in Generate Reminder. Provider-specific step. A different provider requires edits and testing.
Inputs and setup options
- Setup field: calendar_id
- Setup field: history_sheet_id
- Setup field: history_sheet_name
- Setup field: manager_slack_channel
- Setup field: super_high_threshold
- Setup field: high_threshold
Resource information
- Credit basis
- Author listed by n8n
- Pricing
- Template access shown on n8n
- License
- Not specified
- Last record update
- Nov 5, 2026