Send AI pre-op reminders with Google Calendar, Gmail, Sheets, Slack and GPT-4o
Ready for 3.0What this workflow does
This AI workflow has 16 nodes and runs on a schedule (cron 0 9 * * *) (plus 2 other triggers). Along the way it connects Google Calendar, Azure OpenAI Chat Model, Gmail and Google Sheets and 1 more.
How it runs
Trigger: On a schedule (cron 0 9 * * *) (plus 2 other triggers).
- Google Calendar: get many
- Parse Query Params + Mark Confirmed (patient_id, uniqueId, confirmedAt) (Code): runs custom JavaScript code
- Google Sheets: uses Google Sheets
- Extract Surgery Events + Patient Fields (Code): runs custom JavaScript code
- Google Sheets: append or update
- If: checks a condition and branches into true / false
- Build Unique Confirmation Link (confirmUrl) (Code): runs custom JavaScript code
- Slack: uses Slack
- Clean Patient Fields (Name/Email/Phone/ID) (Code): runs custom JavaScript code
- AI: Generate Pre-Op Checklist Email (Subject + HTML Body) (AI Agent): runs an AI agent, with model: LLM: Azure OpenAI Chat Model (gpt-4o); output parser: Parse AI Output (Subject/Body JSON)
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Calendar
n8n-nodes-base.googleCalendar - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Gmail
n8n-nodes-base.gmail - Webhook
n8n-nodes-base.webhook - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack
From the author
📘 Description This workflow automates end-to-end pre-surgery checklist reminders and confirmation tracking for healthcare operations teams. It ensures patients receive timely preparation instructions, can confirm completion with a single click, and allows…