Reddit lead finder: Automated prospecting with GPT-4, Supabase and Gmail alerts
Needs changesWhat this workflow does
This AI workflow has 23 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects OpenAI Chat Model, Reddit, Google Sheets and Gmail and 1 more.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Code: runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Filter Posts (If): checks a condition and branches into true / false
- Get Posts (Reddit): search
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- If: checks a condition and branches into true / false
- Get many rows (Supabase): get many
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Code: runs custom JavaScript code
- If: checks a condition and branches into true / false
…plus 10 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 Analysis Content By AI (v1.7): 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) Analysis Content By AI (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (12)
- Manual Trigger
n8n-nodes-base.manualTrigger - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - AI Agent
@n8n/n8n-nodes-langchain.agent - Reddit
n8n-nodes-base.reddit - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Supabase
n8n-nodes-base.supabase - Code
n8n-nodes-base.code - Wait
n8n-nodes-base.wait - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
This workflow monitors targeted subreddits for potential sales leads using Reddit’s API, AI content analysis, Supabase, and Google Sheets. It is built specifically to discover posts from Reddit users who may benefit from a particular product or service. It…