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 outreach messages. The system searches for local businesses based on keywords and locations, extracts their contact information and reviews, then generates professional outreach messages tailored to each business. Results are stored in Google Sheets and notifications are sent via Telegram.
📊 Google Sheets Template
Use this template: Local Business Lead Generator
🔑 Key Features
- 🔍 Searches Google Maps for local businesses using SerpAPI based on keywords and location parameters
- 📋 Collects comprehensive business information including name, address, rating, reviews, phone numbers, and websites
- 🤖 Uses OpenRouter's LLM to analyze business data and generate personalized outreach messages
- 🌐 Analyzes business websites to provide targeted improvement suggestions
- 📱 Automatically detects Instagram and TikTok profiles from business websites
- 🗣️ Generates messages in the local language based on country code settings
- 📊 Organizes and stores all collected data in Google Sheets with proper categorization
- 🚀 Sends real-time updates and lead summaries via Telegram bot
- 💬 Automatically creates WhatsApp links for easy business communication
🔧 Requirements
- SerpAPI Account + API Key – For Google Maps business data extraction
- OpenRouter Account + API Key – For AI-powered message generation and analysis
- Telegram Bot + API Token – For notifications and bot interactions
- Google Sheets – Connected to n8n for data storage
- Google Sheets Template – Pre-configured with proper column structure
🎁 Benefits
- Fully automated lead generation and outreach system
- Saves time and increases efficiency for local business marketing
- High personalization improves engagement and response rate
- Scalable for any niche or location