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:
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.
Got questions about the video? Drop them in the comments below β¬οΈ