Block 1 - When clicking ‘Test workflow’
- Type / Role
- n8n-nodes-base.manualTrigger - manualTrigger
- Config choices
- Version 1
Bright Data-powered competitive price lookup and report generator
Workflow preview
100%
$20/month : Unlimited workflows
2500 executions/month
THE #1 IN WEB SCRAPING
Scrape any website without limits
HOSTINGER 
Early Deal
DISCOUNT 20% Try free
Early DealDISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Important notice
This workflow is provided as-is. Please review and test before using in production.
1. Workflow Overview
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. ...
Best for
- Market Research automation workflows
- AI Summarization automation workflows
- advanced n8n builders looking for reusable templates
Tools used
n8n-nodes-base.manualtrigger, n8n-nodes-base.googlesheets, n8n-nodes-base.wait, n8n-nodes-brightdata.brightdata, n8n-nodes-base.if, n8n-nodes-base.splitinbatches, n8n-nodes-base.code, n8n-nodes-base.emailsend
Source and attribution
This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Gleb D.
Original n8n.io source1.1 Workflow description
- Title
- Bright Data-powered competitive price lookup and report generator
- Workflow name
- 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.
1.2 Logical Blocks
This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.
2. Block-by-Block Analysis
Block 2 - Google Sheets
- Type / Role
- n8n-nodes-base.googleSheets - googleSheets
- Config choices
- Version 4.5
Block 3 - Wait 30s - Polling Bright Data
- Type / Role
- n8n-nodes-base.wait - wait
- Config choices
- Version 1.1
Block 4 - Snapshot Progress
- Type / Role
- n8n-nodes-brightdata.brightData - brightData
- Config choices
- Version 1
Block 5 - Snapshot Content
- Type / Role
- n8n-nodes-brightdata.brightData - brightData
- Config choices
- Version 1
Block 6 - Snapshot Request
- Type / Role
- n8n-nodes-brightdata.brightData - brightData
- Config choices
- Version 1
Block 7 - If - Checking status of Snapshot
- Type / Role
- n8n-nodes-base.if - if
- Config choices
- Version 2.2
Block 8 - Check if snapshot ready
- Type / Role
- n8n-nodes-base.if - if
- Config choices
- Version 2.2
Block 9 - Loop Over Items
- Type / Role
- n8n-nodes-base.splitInBatches - splitInBatches
- Config choices
- Version 3
Block 10 - If - Checking status for errors
- Type / Role
- n8n-nodes-base.if - if
- Config choices
- Version 2.2
Block 11 - Code - Check If Snapshot is built
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 12 - Code - Extract Necessary Data
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 13 - Email Report
- Type / Role
- n8n-nodes-base.emailSend - emailSend
- Config choices
- Version 2.1
Block 14 - Error message (replace with webhook/other notifier if needed)
- Type / Role
- n8n-nodes-base.set - set
- Config choices
- Version 3.4
Block 15 - Google Gemini Chat Model
- Type / Role
- @n8n/n8n-nodes-langchain.lmChatGoogleGemini - lmChatGoogleGemini
- Config choices
- Version 1
Block 16 - Compare Prices and Generate Report
- Type / Role
- @n8n/n8n-nodes-langchain.chainLlm - chainLlm
- Config choices
- Version 1.6
Block 17 - Markdown
- Type / Role
- n8n-nodes-base.markdown - markdown
- Config choices
- Version 1
Block 18 - Code - Build HTML
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 19 - Sticky Note
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
3. Summary Table
| Workflow | Bright Data-powered competitive price lookup and report generator |
|---|---|
| Complexity | advanced |
| Nodes | 19 |
| Categories | Market Research, AI Summarization |
| Author | Gleb D |
| Published | 23 May 2025 |
4. Reproducing the Workflow from Scratch
-
1. Download the workflow JSON
Use the JSON export at /data/workflows/4348/4348.json as the source template for this automation.
-
2. Import the template into n8n
Open n8n, import the downloaded JSON, and review each node before activating the workflow.
-
3. Configure credentials and variables
Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.
-
4. Test with sample data
Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.
-
5. Activate and monitor
Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.
5. General Notes & Resources
Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.
Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.
Frequently asked questions
What does Bright Data-powered competitive price lookup and report generator do?
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 do I need before importing this workflow?
Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.
Can I customize this workflow?
Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Market Research, AI Summarization use case.