4d • 💎 Gems
🚀 AI Lead Enrichment Engine: Yelp + Trustpilot Scraping + Automated Outreach
Grab the free template from the attached file down below 👇
A Complete “Find → Qualify → Enrich → Contact” System for Agencies & Automation Builders
This template turns a simple input — country, city, and business category — into a fully enriched, outreach‑ready lead list. It’s built for people who want real data, real credibility signals, and real automation, not random scraped lists.
This workflow handles everything:
- Expands your target city into AI‑generated sub‑locations
- Scrapes Yelp for business details
- Scrapes Trustpilot for credibility & reviews
- Cleans, deduplicates, and enriches data in Google Sheets
- Generates personalized outreach emails using Claude
- Sends them automatically via Gmail
All inside n8n, fully modular, fully scalable.
🔥 What This Automation Does
1. AI Location Expansion
You enter:
- Country
- City
- Category
The workflow uses AI to break the city into high‑value sub‑areas, giving you deeper coverage and more leads.
2. Yelp Business Scraping
For each sub‑location, the workflow pulls:
- Business name
- Rating
- Review count
- Categories
- Website
- Phone
- Address
- Yelp URL
Everything is stored neatly in Google Sheets.
3. Trustpilot Review Enrichment
The workflow:
- Extracts unique domains
- Converts them into Trustpilot review URLs
- Scrapes company reviews, ratings, and credibility data
- Saves all results into a second sheet
This gives you verified, trustworthy leads, not random businesses.
4. AI‑Generated Outreach Emails
For every unique email found:
- Claude writes a personalized outreach message
- The workflow parses the JSON
- Gmail sends the email automatically
You get hands‑free, personalized outreach at scale.
Book a free Consultation: đź”— https://cal.com/genovaflow-ai/discovery-call
Let us build your project: đź”— https://genovaflow.com/home/contact
14‑day FREE Trial on n8n: 🔗 https://n8n.partnerlinks.io/ox7johicleqv
Got questions about the video? Drop them in the comments below ⬇️
Sponsorship: 📧 contact@genovaflow.com
3
4 comments
🚀 AI Lead Enrichment Engine: Yelp + Trustpilot Scraping + Automated Outreach
powered by
skool.com/ai-automation-flow-9979
Master AI Automation and AI Agents Today with Unlimited Support
Suggested communities
Powered by