{"product_id":"n8n-workflow-google-sheets-churn-risk-sms-with-gemini-twilio","title":"n8n Workflow: Google Sheets Churn Risk SMS with Gemini \u0026 Twilio","description":"\u003ch3\u003eRun weekly churn-risk SMS campaigns from your Google Sheets—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow analyzes Google Sheets attendance data, computes a 0–100 churn risk score, and uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to generate a personalized re-engagement SMS. Eligible members are messaged via \u003cstrong\u003eTwilio\u003c\/strong\u003e, and every outreach is logged back to your Google Sheets—so you can turn churn signals into action without manual work.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules weekly\u003c\/strong\u003e to keep your re-engagement outreach timely.\u003c\/li\u003e\n  \u003cli\u003ePulls all \u003cstrong\u003eactive members\u003c\/strong\u003e from the Google Sheets tab \u003cstrong\u003e“Members”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFetches each member’s attendance history from the Google Sheets tab \u003cstrong\u003e“Attendance”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates churn metrics\u003c\/strong\u003e: visits in the last 30 days vs. prior 30 days, attendance drop percentage, and days since the last visit—then derives a \u003cstrong\u003ecapped 0–100 churn risk score\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters recipients\u003c\/strong\u003e to members with a churn signal and a \u003cstrong\u003erisk score ≥ 60\u003c\/strong\u003e; others are skipped.\u003c\/li\u003e\n  \u003cli\u003eLoads member details from \u003cstrong\u003e“MemberProfiles”\u003c\/strong\u003e and sends profile + churn metrics to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eGemini returns:\n    \u003cul\u003e\n      \u003cli\u003ea short internal diagnosis,\u003c\/li\u003e\n      \u003cli\u003ea \u003cstrong\u003e≤300-character SMS message\u003c\/strong\u003e,\u003c\/li\u003e\n      \u003cli\u003ean \u003cstrong\u003eSMS eligibility flag\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eIf eligible, sends the message via \u003cstrong\u003eTwilio\u003c\/strong\u003e (SMS\/MMS\/WhatsApp).\u003c\/li\u003e\n  \u003cli\u003eAppends outreach details (sent message, timestamp, member ID, risk score) to \u003cstrong\u003e“OutreachLog”\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate re-engagement for gym or fitness subscriptions when attendance drops.\u003c\/li\u003e\n  \u003cli\u003eReduce churn by sending targeted outreach only to members with meaningful risk signals (score ≥ 60).\u003c\/li\u003e\n  \u003cli\u003eGenerate personalized SMS copy at scale using Gemini while keeping messages within 300 characters.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e via n8n using a \u003cstrong\u003eService Account credential\u003c\/strong\u003e shared to the spreadsheet: \u003cem\u003e“Gym Member Management \u0026amp; Outreach Tracker”\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e (Google PaLM) for chat-based SMS generation and eligibility flagging.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTwilio\u003c\/strong\u003e node to send SMS\/MMS\/WhatsApp and track delivery execution.\u003c\/li\u003e\n  \u003cli\u003en8n workflow logic nodes: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eno op\u003c\/strong\u003e, \u003cstrong\u003elimit\u003c\/strong\u003e, plus documentation notes via \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46105997181107,"sku":"N8N-19961","price":71.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/WZknmonw0sZ6ss8m1aPJt_M4hWJE1M.png?v=1790500143","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-churn-risk-sms-with-gemini-twilio","provider":"N8N Commerce","version":"1.0","type":"link"}