Library / CRM & Sales Pipeline
CRM & Sales Pipeline
Send WhatsApp win-back offers to at-risk gym members with OpenAI and ClickUp
Each morning, scores active gym members' churn risk from Google Sheets visit data, then sends OpenAI-written WhatsApp offers and ClickUp call tasks to trainers for at-risk members.
What it does
# GymOS: churn win-back on WhatsApp ## How it works Every morning at 7 AM the workflow reads your members, check-ins and past offers from Google Sheets and scores each active member's churn risk from visit drops, expiring plans and lapsed memberships. At-risk members who aren't on cooldown or opted out get a personalised WhatsApp offer written by OpenAI, and their trainer gets a ClickUp call task. The owner and trainers also get a daily digest. A second flow listens for WhatsApp replies. OpenAI works out what the member wants (accept, freeze, call back, stop or a question), the offer log is updated, the right ClickUp task is created, the member gets an answer and staff are pinged when a person needs to step in. ## Setup steps 1. Create a Google Sheet with the tabs Members, Checkins, Offer Log and Retention Daily, then paste its ID into every Google Sheets node. 2. Edit GymOS Config with your gym name, timezone, staff numbers, renewal link and offers. 3. Add credentials for Google Sheets, OpenAI, WhatsApp Business Cloud and ClickUp, then fill in the phone number ID and ClickUp list in those nodes. 4. Test the daily flow manually with a few sample members. 5. Activate the workflow so the reply trigger starts listening.
The steps
- Daily 7 AM1
- GymOS Config1
- Read Members1
- Read Check-ins1
- Read Offer Log1
- Score Churn Risk1
- Route: Outreach or Summary1
- AI Personalise Message1
- Compose Outreach1
- WhatsApp: Send Offer1
- ClickUp: Trainer Follow-up1
- Log Offer1
- Build Trainer & Owner Digests1
- WhatsApp: Send Digests1
30 steps in total.
Similar automations
Email AutomationSend Daily Win-Back Offers to At-Risk Customers with Gemini12 stepsData Sync & ETLSend weekly Shopify RFM win-back offers with GPT-4o-mini, Klaviyo and WhatsApp22 stepsLead Generation & EnrichmentNurture Gym Leads from Facebook Ads with WhatsApp Follow-Ups26 stepsEmail AutomationGenerate Win-Back Offers with Gemini and Send Them via Gmail13 steps