Skip to content
Dhanasvi
Sign inExplore
Lead Workflow: Yelp & Trustpilot Scraping + OpenAI Analysis via BrightData logo

Lead Workflow: Yelp & Trustpilot Scraping + OpenAI Analysis via BrightData

Verified

Scrapes leads via HTTP, analyzes with AI models, and sends Gmail outreach from Sheets.

n8nAI & LLMIntermediate👁 7.5K views
Open template
Updated 2026-06-15

What this workflow does

This automation retrieves business information through HTTP requests, logs it to Google Sheets, and applies AI analysis via Anthropic and Gemini models before triggering Gmail sends.

It supports sales and marketing teams needing structured lead data enrichment and automated email sequences without manual review steps.

Who is this for?

Digital marketing agencies, sales teams, and business development professionals who need to generate and qualify leads from review platforms.

What problem it solves

Manually finding and vetting business prospects from Yelp and Trustpilot is slow and inconsistent. This workflow automates scraping, credibility analysis via AI, and personalized email outreach.

What it automates

Agency client prospecting

Scrape local service businesses in a target city, score review credibility, and email only high-potential leads.

Sales team pipeline building

Pull Trustpilot data for SaaS-adjacent companies, analyze sentiment, then trigger Gmail outreach sequences.

Market research refresh

Run periodic scrapes into Google Sheets to maintain an updated list of credible prospects by category and location.

How the workflow works

The 7 nodes in this automation, in order.

  1. 1Google SheetsgoogleSheets
  2. 2HTTP RequesthttpRequest
  3. 3Gmailgmail
  4. 4Codecode
  5. 5AI Agent@n8n/n8n-nodes-langchain.agent
  6. 6Anthropic Chat Model@n8n/n8n-nodes-langchain.lmChatAnthropic
  7. 7Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini

Apps & integrations used

Google SheetsHTTP RequestGmailAI AgentAnthropic Chat ModelGoogle Gemini Chat Model

How to set up Lead Workflow: Yelp & Trustpilot Scraping + OpenAI Analysis via BrightData

  1. 1Import the workflow JSON into a self-hosted n8n instance
  2. 2Add credentials for Google Sheets, Gmail, and HTTP Request nodes
  3. 3Configure the AI Agent node with either Anthropic or Google Gemini Chat Model
  4. 4Set location and category parameters in the trigger or input nodes
  5. 5Connect BrightData scraping endpoints via HTTP Request if required
  6. 6Activate the workflow and test with a small batch of leads

How to customize this workflow

  • →Swap Anthropic Chat Model for Google Gemini Chat Model or vice versa
  • →Change the trigger from manual to scheduled or webhook
  • →Add a filter step after AI analysis to route only high-score leads to Gmail
  • →Extend output to additional Google Sheets tabs for different categories

Lead Workflow: Yelp & Trustpilot Scraping + OpenAI Analysis via BrightData: pros & cons

Pros

  • +Combines scraping and AI analysis in one flow
  • +Supports two major review platforms
  • +Uses flexible AI models via the AI Agent node
  • +Directly outputs to Gmail for outreach

Cons

  • –Requires self-hosted n8n (cloud not supported)
  • –Scraping may violate platform terms of service
  • –Needs separate BrightData or similar proxy setup for reliable HTTP calls
Did you find this helpful?

Frequently asked questions

It scrapes business data from Yelp and Trustpilot, analyzes credibility with AI, stores results in Google Sheets, and sends personalized emails via Gmail.

User reviews

Verified reviews from the community shape this listing's rating.

Loading reviews…

Sign in to review

Promote Lead Workflow: Yelp & Trustpilot Scraping + OpenAI Analysis via BrightData

Add this badge to your website, or share the tool.

DFeatured on DhanasviLead Workflow: Yelp & Trustpilot Scraping + OpenAI Analysis via BrightData 0