Local Business Lead Discovery and Enrichment Agent
Needs changesWhat this workflow does
This AI workflow has 20 nodes and runs on a schedule (cron 0 9 * * 1). Along the way it connects OpenAI Chat Model, Gmail, Postgres and Firecrawl (community).
How it runs
Trigger: On a schedule (cron 0 9 * * 1).
- Rotation Seed (Code): runs custom JavaScript code
- AI Agent: runs an AI agent, with model: GPT-5.; 2 tools (/scrape in Firecrawl, /search in Firecrawl)
- Parse Refill Output (Code): runs custom JavaScript code
- Compute Fingerprint (Code): runs custom JavaScript code
- Fetch Seen Fingerprints (Postgres): run a query
- Filter Unseen (Top 10) (Code): runs custom JavaScript code
- Enrich Selected 10 — Prep (Code): runs custom JavaScript code
- AI Agent: runs an AI agent, with model: GPT-5.; 2 tools (Enrich Selected 10 — Scrape Listing, Enrich Selected 10 — Scrape Website)
- Enrich Selected 10 — Parse (Code): runs custom JavaScript code
- Postgres: uses Postgres
…plus 3 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 AI Agent — enrichment (v1.7), AI Agent — Discover Fresh (v1.7): 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) AI Agent — enrichment (v1.7), AI Agent — Discover Fresh (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (8)
- AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Code
n8n-nodes-base.code - Firecrawl Tool
@mendable/n8n-nodes-firecrawl.firecrawlTool - Gmail
n8n-nodes-base.gmail - Aggregate
n8n-nodes-base.aggregate - Postgres
n8n-nodes-base.postgres - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
A weekly agent that finds local businesses with weak or missing web presence, and scores them as sales leads for web agencies, freelance developers, and digital consultants. The agent searches local business directories in your target area. It scrapes each…