Automate customer retention with AI risk prediction, Stripe coupons & personalized Gmail

by HayatoFujita/藤田隼人 ✓ · 170 views · created 2025-12-20 · Lead Nurturing, AI Summarization

What this workflow does

This workflow has 22 nodes and runs on a schedule (every 3 hours). Along the way it connects Postgres, Gmail and Google Sheets. It also calls api.stripe.com over HTTP.

How it runs

Trigger: On a schedule (every 3 hours).

1. 対象顧客リスト取得 (CRM) (HTTP Request): calls an HTTP API
2. サポートチケット情報取得 (HTTP Request): calls an HTTP API
3. サポート指標集計 (Code): runs custom JavaScript code
4. 製品利用ログ取得 (Postgres): run a query
5. データ統合 (CRM+サポート) (Merge): merges the data from its input branches
6. データ統合 (全データ) (Merge): merges the data from its input branches
7. AI解約リスク予測 (OpenAI): work with chat completion
8. 高リスク顧客フィルタ (If): checks a condition and branches into true / false
9. 特別オファー生成 (HTTP Request): calls api.stripe.com (POST)
10. 未更新ログ取得 (Google Sheets): uses Google Sheets

…plus 11 more steps. See the full node list below.

Services it uses

PostgresGmailGoogle Sheets

HTTP calls to: api.stripe.com

Before you upgrade to n8n 3.0

Nodes used (9)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Postgresn8n-nodes-base.postgres
• Mergen8n-nodes-base.merge
• OpenAIn8n-nodes-base.openAi
• Ifn8n-nodes-base.if
• Gmailn8n-nodes-base.gmail
• Google Sheetsn8n-nodes-base.googleSheets

From the author

Predict churn risk from customer data and send retention emails via OpenAI 👥 Who’s it for This workflow is designed for Customer Success Managers, Growth Teams, and SaaS Business Owners who want to proactively reduce churn using AI. It automates the analysis…

View the original on n8n.io → Check your own copy