Extract business leads from Reddit using GPT-4.1-mini analysis and Google Sheets

by Ari Nakos ✓ · 3,097 views · created 2025-05-03 · Lead Generation, AI Summarization

What this workflow does

This AI workflow has 14 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, Reddit and OpenRouter Chat Model.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Get Posts (Reddit): search
2. Filter Posts By Features (If): checks a condition and branches into true / false
3. Select Key Fields (Edit Fields (Set)): sets 5 fields: upvotes, subreddit_subscribers, postcontent…
4. Merge: merges the data from its input branches
5. Basic LLM Chain: sends a prompt to an LLM, with model: OpenRouter Chat Model
6. Filter Posts By Content (If): checks a condition and branches into true / false
7. Post Summarization (Summarization Chain): summarizes text with AI, with model: OpenRouter Chat Model
8. Edit Fields (Edit Fields (Set)): sets 6 fields: date, subreddit_subscribers, url…
9. Edit Fields (Edit Fields (Set)): sets 1 field: summary
10. Merge: merges the data from its input branches

…plus 1 more step. See the full node list below.

Services it uses

Google SheetsRedditOpenRouter Chat Model

Before you upgrade to n8n 3.0

Nodes used (9)

• Manual Triggern8n-nodes-base.manualTrigger
• Summarization Chain@n8n/n8n-nodes-langchain.chainSummarization
• Mergen8n-nodes-base.merge
• Google Sheetsn8n-nodes-base.googleSheets
• Ifn8n-nodes-base.if
• Edit Fields (Set)n8n-nodes-base.set
• Redditn8n-nodes-base.reddit
• OpenRouter Chat Model@n8n/n8n-nodes-langchain.lmChatOpenRouter
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm

From the author

This n8n workflow automates lead generation by searching Reddit for relevant posts based on keywords, filtering them, using OpenRouter AI to analyze and summarize content, and logging the findings (link, summary, etc.) to Google Sheets. Watch the full setup…

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