Bright Data-Powered Competitive Price Lookup and Report Generator
This n8n workflow automates the collection, enrichment, and analysis of e-commerce product listings using Bright Data and AI, then delivers an HTML email report with the most competitive offers.
**What It Does**
- Pulls product titles from a Google Sheet.
- For each product, searches a Bright Data marketplace dataset (Google Shopping) for available listings.
- Extracts relevant fields: price, title, seller name, and listing URL.
- Sends this data to Google Gemini for AI-powered Markdown report generation.
- Converts Markdown to HTML and styles the output for better email rendering.
- Sends an email report for each product with the top 20 most affordable offers.
**Step-by-Step Setup**
- Load product list from Google Sheets.
- For each product title, run a Bright Data filter request (case-sensitive match).
- Poll the snapshot status until it is ready.
- Retrieve snapshot content and clean the results with a Code node.
- Pass the results to Gemini (PaLM/Gemini Flash) for analysis and report generation in Markdown.
- Convert Markdown into styled HTML using Markdown + Code nodes.
- Send formatted email to a predefined recipient.
- Return to the loop and repeat for the next product.
**How It Works**
- Loop Control: SplitInBatches handles product-by-product processing.
- Snapshot Handling: Snapshot status is polled every 30s until success/failure.
- AI Formatting: Gemini summarizes listings and formats content.
- Error Handling: Failed snapshots produce a warning message and resume the loop.
**Final Output**
- Each email contains:
- The product name
- A clean HTML of up to 20 sellers with lowest prices
- Links to listings
- AI-generated pricing summary
**Credentials Used**
- Bright Data account
- Google Gemini (PaLM/Gemini Flash)
- Google Sheets (OAuth2)
- SMTP Email (emailSend node)
**Important Notes**
- Item title search is case-sensitive. Typos or casing mismatches may result in no results.
- Requires **n8n-nodes-brightdata community node** to be installed.
Platform
n8n
Category
Data & Analytics
Price
Free
Creator
Gleb D
if
set
code
wait
markdown
emailSend
stickyNote
googleSheets
manualTrigger
splitInBatches
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.