Automated daily customer win-back campaign with AI offers

by Onur ✓ · 1,276 views · created 2025-05-12 · Social Media, Multimodal AI

What this workflow does

This AI workflow has 12 nodes and runs on a schedule (every day). Along the way it connects Google Sheets, Google Gemini Chat Model and Gmail.

How it runs

Trigger: On a schedule (every day).

1. Fetch Customer Data from Sheet (Google Sheets): uses Google Sheets
2. Filter: keeps only the items that match a condition
3. Check if Eligible Customers Found (If): checks a condition and branches into true / false
4. Process Each Eligible Customer (Loop Over Items (Split in Batches)): loops over the items in batches
5. Set 'Not Found' Status (Edit Fields (Set)): sets 2 fields: system_log, date
6. Generate Win-Back Offer (Basic LLM Chain): sends a prompt to an LLM, with model: (LLM Model for Offer Generation); output parser: (Parse Offer JSON)
7. Log 'Not Found' in System Log (Google Sheets): append or update
8. Log Sent Offer in System Log (Google Sheets): append or update
9. Send Win-Back Offer via Email (Gmail): uses Gmail

Services it uses

Google SheetsGoogle Gemini Chat ModelGmail

Before you upgrade to n8n 3.0

Nodes used (10)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Filtern8n-nodes-base.filter
• Ifn8n-nodes-base.if
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Gmailn8n-nodes-base.gmail
• Edit Fields (Set)n8n-nodes-base.set

From the author

Proactively retain customers predicted to churn with this automated n8n workflow. Running daily, it identifies high-risk customers from your Google Sheet, uses Google Gemini to generate personalized win-back offers based on their churn score and preferences,…

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