Predict gym member churn and send WhatsApp win-backs with OpenAI and ClickUp
Ready for 3.0What this workflow does
This AI workflow has 30 nodes and runs on a schedule (cron 0 7 * * *) (plus 1 other trigger). Along the way it connects Google Sheets, OpenAI, WhatsApp Business Cloud and ClickUp.
How it runs
Trigger: On a schedule (cron 0 7 * * *) (plus 1 other trigger).
- GymOS Config (Code): runs custom JavaScript code
- Parse Reply (Code): runs custom JavaScript code
- Read Members (Google Sheets): uses Google Sheets
- Find Member (Google Sheets): uses Google Sheets
- Read Check-ins (Google Sheets): uses Google Sheets
- Find Member Offers (Google Sheets): uses Google Sheets
- Read Offer Log (Google Sheets): uses Google Sheets
- Build Reply Context (Code): runs custom JavaScript code
- Score Churn Risk (Code): runs custom JavaScript code
- AI Classify Intent (OpenAI): uses OpenAI
…plus 18 more steps. 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 (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Switch
n8n-nodes-base.switch - OpenAI
@n8n/n8n-nodes-langchain.openAi - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - ClickUp
n8n-nodes-base.clickUp - WhatsApp Trigger
n8n-nodes-base.whatsAppTrigger - If
n8n-nodes-base.if
From the author
Quick overview This workflow scores gym members’ churn risk using Google Sheets data, sends personalised WhatsApp win-back or renewal offers generated by OpenAI, creates follow-up tasks in ClickUp, and handles incoming WhatsApp replies by classifying intent,…