Automated local business lead generator with AI, social media & WhatsApp links
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 22 nodes and runs on a schedule (every day). Along the way it connects Google Sheets, Telegram and OpenRouter Chat Model. It also calls serpapi.com over HTTP.
How it runs
Trigger: On a schedule (every day).
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- HTTP Request: calls serpapi.com
- Split Out: splits a list into separate items
- Append or update row in sheet (Google Sheets): append or update
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- If: checks a condition and branches into true / false
- Limit: keeps the first few items
- Basic LLM Chain: sends a prompt to an LLM, with model: OpenRouter Chat Model
- Append or update row in sheet (Google Sheets): append or update
- If: checks a condition and branches into true / false
…plus 8 more steps. See the full node list below.
Services it uses
HTTP calls to: serpapi.com
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 (11)
- HTTP Request
n8n-nodes-base.httpRequest - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Sheets
n8n-nodes-base.googleSheets - Telegram
n8n-nodes-base.telegram - Schedule Trigger
n8n-nodes-base.scheduleTrigger - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - If
n8n-nodes-base.if - Split Out
n8n-nodes-base.splitOut - Limit
n8n-nodes-base.limit - Code
n8n-nodes-base.code - No Operation, do nothing
n8n-nodes-base.noOp
From the author
Automated Local Business Lead Generator with AI, Social Media & WhatsApp Links This workflow automates the process of generating and managing local business leads by scraping Google Maps data, analyzing business information with AI, and creating personalized…