Segment donors and draft personalized outreach with Google Sheets and Ollama
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 17 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets and Ollama Chat Model.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Validate & Clean (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- RFM Segmentation (Code): runs custom JavaScript code
- Store Invalid Rows (Google Sheets): append or update
- Behavioral Segmentation (Code): runs custom JavaScript code
- Segment to Treatment Mapping (Code): runs custom JavaScript code
- Build Prompt (Code): runs custom JavaScript code
- Basic LLM Chain: sends a prompt to an LLM, with model: Llama3.
- Merge: merges the data from its input branches
…plus 4 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Merge
n8n-nodes-base.merge - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Manual Trigger
n8n-nodes-base.manualTrigger - Ollama Chat Model
@n8n/n8n-nodes-langchain.lmChatOllama
From the author
Quick overview This workflow pulls donor records from Google Sheets, validates and segments donors using RFM and engagement signals, generates personalized outreach drafts with a local Ollama Llama 3.1 model, and writes the drafted “Personalized Message” back…