Re-engage old clients with Claude 3.7 Sonnet, Gmail and Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 20 nodes and runs on a schedule (every day). Along the way it connects Google Sheets, Gmail and Anthropic Chat Model.
How it runs
Trigger: On a schedule (every day).
- 📋 Old Client Database (Google Sheets): uses Google Sheets
- 🔄 Loop: Process Each Client (Loop Over Items (Split in Batches)): loops over the items in batches
- 📧 Fetch Client's Latest Email (Gmail): get many
- 📅 Date Checker (30-Day Window) (Code): runs custom JavaScript code
- 🔀 Route: Client Replied Recently? (Switch): routes items into 2 branches
- 📝 Update: Mark Reply Manually (Google Sheets): update
- 📂 Fetch Situation-Based Prompt (Google Sheets): uses Google Sheets
- 📩 Fetch Followup Message Template (Google Sheets): uses Google Sheets
- ✅ Update: Mark Running Status (Google Sheets): update
- Merge: merges the data from its input branches
…plus 7 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in 🤖 Re-engagement Email Drafter (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) 🤖 Re-engagement Email Drafter (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Gmail
n8n-nodes-base.gmail - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - Aggregate
n8n-nodes-base.aggregate - Merge
n8n-nodes-base.merge - AI Agent
@n8n/n8n-nodes-langchain.agent - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Wait
n8n-nodes-base.wait
From the author
Description Automatically re-engage old or inactive clients by sending AI-personalized follow-up emails using Claude 3.7 Sonnet, Gmail, and Google Sheets — with smart reply detection to avoid messaging clients who are already in active conversation. --- What…