Quick overview
Quick overview This workflow runs daily to pull 30-day account usage from your product API, compute a health score, and use OpenAI to classify churn risk and recommend a retention play, then routes actions to Slack, Gmail, HubSpot, and Google Sheets. How it works Runs every morning at 7am on a schedule. Requests the last 30 days of account usage metrics from your product API. Calculates a 0–100 health score per account from usage and support signals. Sends the account context to OpenAI (GPT-4o) to classify churn risk (high/medium/low) and recommend one retention play. Routes high-risk accounts to a Slack alert for the #customer-success channel, medium-risk accounts to a nurture email via Gmail, and low-risk accounts to a CRM update in HubSpot. Appends the account’s signals, score, and chosen action to a Google Sheets “Churn Signals” tab for tracking and reporting. Setup Provide a reachable product usage endpoint and update the HTTP request URL (and any required auth headers) to match your product API. Add an OpenAI credential and ensure the selected GPT-4o model is available to your account. Connect Slack credentials and confirm the target channel (for example, #customer-success) exists and is selectable. Connect a Gmail account authorized to send emails and verify the account owner email field returned by your API is correct. Connect HubSpot credentials and configure the contact lookup/update fields you want to write (for example, a custom health score property). Connect Google Sheets credentials and replace REPLACE_WITH_SHEET_ID with your spreadsheet ID (and ensure a “Churn Signals” sheet/tab exists). An n8n automation workflow template by Swapnil Mandloi.
Swapnil Mandloi
web
free
Others in the same category, ranked by how often they are opened.
