Automated Local Business Lead Generator with AI, Social Media & WhatsApp Links
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
Related Templates
Send structured logs to BetterStack from any workflow using HTTP Request
Send structured logs to BetterStack from any workflow using HTTP Request Who is this for? This workflow is perfect for...
Provide latest euro exchange rates from European Central Bank via Webhook
What is this workflow doing? This simple workflow is pulling the latest Euro foreign exchange reference rates from the E...
Convert Tour PDFs to Vector Database using Google Drive, LangChain & OpenAI
š§© Workflow: Process Tour PDF from Google Drive to Pinecone Vector DB with OpenAI Embeddings Overview This workflow au...
š Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments