Score churn risk and send retention emails with Google Sheets and Gmail

Description

Who's it for

This template is for gyms, fitness studios, and membership-based businesses that want to automatically detect at-risk members and act before they cancel. Ideal for operations teams and retention managers who want to replace manual follow-ups with a systematic, automated process.

How it works

The workflow fetches member records from Google Sheets and passes them through a JavaScript scoring engine that assigns each member a churn risk level: Critical, High, Medium, or Low.

A Switch node routes each member into the appropriate path:
Critical and High risk** members receive a personalised retention email via Gmail and their action is logged in Google Sheets
Medium risk** members are logged for later monitoring
Low risk** members are ignored automatically

How to set up

Copy the sample Google Sheet (link in the sticky note) and connect it to the Google Sheets nodes
Connect your Gmail account to the email nodes
Adjust the scoring logic in the Calculate Churn Risk code node to match your business rules
Replace the manual trigger with a Schedule Trigger for daily automated runs

Requirements

Google Sheets account
Gmail account
Basic understanding of JavaScript to customise the scoring logic