Rescue at-risk gym members using Google Sheets, Gemini, and Twilio SMS

Description

Quick overview Youtube Video: https://youtu.be/YNinqI84rNw This workflow runs weekly to analyze Google Sheets member attendance, calculate churn risk scores, and use Google Gemini to generate personalized re-engagement SMS copy, then sends eligible messages via Twilio and logs the outreach back to Google Sheets. How it works Runs weekly on a schedule. Pulls all active members from a Google Sheets “Members” tab and fetches each member’s attendance history from a Google Sheets “Attendance” tab. Calculates churn metrics per member (visits in the last 30 days vs. prior 30 days, attendance drop percentage, days since last visit) and derives a capped 0–100 risk score. Filters to members with a churn signal and a risk score of at least 60, and skips the rest. Looks up the member’s profile details in a Google Sheets “MemberProfiles” tab and sends the profile plus churn metrics to Google Gemini to produce a short internal diagnosis, a ≤300-character SMS message, and an SMS eligibility flag. If the member is marked SMS-eligible, sends the generated message to the member via Twilio (SMS/MMS/WhatsApp) and appends the sent message, timestamp, member ID, and risk score to a Google Sheets “OutreachLog” tab. Setup Set up a Google Sheets Service Account credential in n8n and share the “Gym Member Management & Outreach Tracker” spreadsheet with the service account email. Add a Google Gemini (Google PaLM) API credential for the Gemini chat model used by the AI Agent. Add a Twilio credential, set a valid Twilio “From” number, and confirm the workflow’s message type (SMS vs. WhatsApp) matches your Twilio configuration. Update the Google Sheet document ID/sheet tabs as needed and ensure your sheets include the expected columns (e.g., member_id, status, join_date, visit_date, phone) plus an “OutreachLog” tab for appends. Adjust the churn threshold (risk score ≥ 60) and weekly schedule timing to match your retention policy and outreach volume limits. An n8n automation workflow template by iamvaar.

Community Metrics

Categories

• Automation
• AI

Tags

• n8n
• workflow
• google-sheets
• twilio
• code
• ai-agent
• structured-output-parser
• google-gemini-chat-model

Capabilities

• 6 nodes

Information