This automation template enables scalable lead generation for agencies and freelancers who need to find target businesses on review platforms, assess their online reputation, and launch cold email campaigns — without manual effort. Built on n8n, BrightData, and AI (Gemini, Claude).
## Who it´s for
- Marketing agencies automating lead generation
- Freelancers selling SEO and digital services
- SaaS startups sourcing clients via review platforms
- Reputation management agencies offering visibility improvement
- Business analysts collecting data from Yelp and Trustpilot
## What the automation does
- User submits country, category, and location via form or webhook
- Google Gemini breaks down the city into sub-locations for precise targeting
- BrightData scrapes businesses from Yelp, extracts names, websites, and contact info
- Trustpilot URLs are generated and scraped for customer reviews
- All data is stored in Google Sheets
- Claude generates personalized outreach emails based on collected insights
- Emails are sent via Gmail
## What´s included
- Ready-to-use n8n workflow
- Trigger logic (form / webhook)
- Integrations with Yelp (via BrightData), Trustpilot, Google Sheets, Gmail, Google Gemini, Anthropic Claude
- Basic text instructions for setup and adaptation
## Requirements for setup
- n8n instance with LangChain support
- BrightData API key
- Google account (Sheets, Gmail)
- API keys for Gemini and Claude
- Access to HTTP triggers and web forms
## Benefits and outcomes
- Fully automated lead collection without manual search
- In-depth reputation analysis using Trustpilot reviews
- AI-generated personalized outreach messages
- Scalable campaigns across new cities and categories
- Reduced lead generation time from days to minutes
- Centralized data storage in Google Sheets
- Reusable database for future campaigns
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via в чате.
lead generation
scrape Yelp
scrape Trustpilot
reputation analysis
email outreach
automated lead gen
n8n workflow
BrightData scraping
Google Sheets
personalized emails
find businesses
review data collection
AI review analysis
form input
Gmail integration
sales scaling
lead generation automation
reputation management
No feedback yet