{"product_id":"n8n-gym-churn-prediction-whatsapp-win-backs-openai-clickup","title":"n8n Gym Churn Prediction + WhatsApp Win-Backs (OpenAI, ClickUp)","description":"\u003ch3\u003ePredict gym churn risk automatically—and win back members on WhatsApp with ClickUp follow-ups\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors your Google Sheets gym data daily, scores each member’s churn risk, then generates personalized WhatsApp win-back\/renewal messages using OpenAI. It also creates the right ClickUp tasks for trainers and intelligently handles incoming WhatsApp replies by classifying intent and updating logs.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns every day at 7 AM\u003c\/b\u003e to load gym settings plus member, check-in, and offer history from \u003cb\u003eGoogle Sheets\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCalculates a churn-risk score\u003c\/b\u003e per active member based on visit drop-off, \u003cb\u003edays since last check-in\u003c\/b\u003e, and \u003cb\u003emembership expiry\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eSelects eligible members who are \u003cb\u003enot opted out\u003c\/b\u003e and \u003cb\u003enot in a cooldown window\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGenerates personalised WhatsApp messages\u003c\/b\u003e (including trainer call notes) with \u003cb\u003eOpenAI\u003c\/b\u003e, sends the offer via WhatsApp, and creates a \u003cb\u003eClickUp\u003c\/b\u003e follow-up task for the assigned trainer.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLogs every outreach\u003c\/b\u003e to the Google Sheets \u003cb\u003e“Offer Log”\u003c\/b\u003e (offer code, send status, cooldown timing).\u003c\/li\u003e\n  \u003cli\u003eBuilds and sends \u003cb\u003edaily WhatsApp digests\u003c\/b\u003e to the owner and each trainer from the scoring summary, and appends a snapshot to the Google Sheets \u003cb\u003e“Retention Daily”\u003c\/b\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eTriggers on incoming WhatsApp messages\u003c\/b\u003e, looks up the member and latest offer in Google Sheets, uses \u003cb\u003eOpenAI\u003c\/b\u003e to classify intent (accept, freeze, callback, stop, or question\/other), drafts a reply, and updates offer\/member status accordingly.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate daily churn outreach for gym memberships without manual segmentation.\u003c\/li\u003e\n  \u003cli\u003eRoute win-back actions to trainers in \u003cb\u003eClickUp\u003c\/b\u003e with clear, timely follow-ups.\u003c\/li\u003e\n  \u003cli\u003eHandle member WhatsApp replies (accept\/freeze\/callback\/stop) while keeping Google Sheets offer logs accurate.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n nodes\/workflow logic:\u003c\/b\u003e if, code, switch, ClickUp, WhatsApp, Sticky Note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eData source\/recording:\u003c\/b\u003e Google Sheets (“Offer Log” and “Retention Daily”)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAI:\u003c\/b\u003e OpenAI for personalized WhatsApp messaging and intent classification\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46228902019251,"sku":"N8N-20876","price":32.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/WmFoSD5K4lxDWZbuvZDap_E6jSJ9hd.png?v=1792056287","url":"https:\/\/buyflowscripts.com\/products\/n8n-gym-churn-prediction-whatsapp-win-backs-openai-clickup","provider":"N8N Commerce","version":"1.0","type":"link"}