Find Reddit prospects & generate personalized responses with Llama3 AI 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 13 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, Reddit and Ollama Chat Model.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Reddit Posts (Reddit): uses Reddit
- Process Post Fields (Edit Fields (Set)): sets or maps fields
- Get Existing Posts (Google Sheets): uses Google Sheets
- Filter New Posts (Code): runs custom JavaScript code
- Process One Post at a Time (Loop Over Items (Split in Batches)): loops over the items in batches
- AI Relevance Analysis (AI Agent): runs an AI agent, with model: Ollama Chat Model
- Parse AI Response (Code): runs custom JavaScript code
- Is Post Relevant? (If): checks a condition and branches into true / false
- Log Relevant Post (Google Sheets): uses Google Sheets
- Log Irrelevant Post (Google Sheets): uses Google Sheets
…plus 1 more step. 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 AI Relevance Analysis (v1.8): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Relevance Analysis (v1.8) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Reddit
n8n-nodes-base.reddit - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Ollama Chat Model
@n8n/n8n-nodes-langchain.lmChatOllama - AI Agent
@n8n/n8n-nodes-langchain.agent - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Edit Fields (Set)
n8n-nodes-base.set
From the author
Turn Reddit into Your Most Powerful Lead Generation Channel Discover hot prospects on Reddit who are actively discussing problems your product can solve - without spending hours manually searching and responding. This intelligent workflow automatically finds…