AutomationMart
Home/Browse/Bright Data-powered competitive price lookup and report generator
n8n

Bright Data-powered competitive price lookup and report generator

n8nn8n18 modulesv1.0
Google SheetsGemini

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 gen

At a glance

Bright Data-powered competitive price lookup and report generator is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, Gemini
Modules
18
Price
Free
Version
v1.0
Bright Data-powered competitive price lookup and report generator workflow diagram

About this workflow

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.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Create new orders in Binance from new rows in a Google Sheets spreadsheet

This template periodically checks for new rows in a Google Sheets spreadsheet and uses the retrieved information to create new orders in Binance. The template is using [this sample](https://docs.google.com/spreadsheets/d/1NJqD-ENdVwP5sjKv5zG_ogNFo4r0FCJ8cPkL7gRgAd8/edit?usp=sharing) Google Sheets spreadsheet as a source of the data. You should make a copy of it before configuring the template. The template is scheduled to run every 15 minutes. You can change the schedule after you set up the t

Free

Automate image validation tasks using AI Vision

This n8n workflow shows how using multimodal LLMs with AI vision can tackle tricky image validation tasks which are near impossible to achieve with code and often impractical to be done by humans at scale. You may need image validation when users submitted photos or images are required to meet certain criteria before being accepted. A wine review website may require users only submit photos of wine with labels, a bank may require account holders to submit scanned documents for verification etc.

Free

Add new Facebook Lead Ads leads to Google Sheets and custom audiences

Automatically add new Facebook Lead Ads leads to Google Sheets and update Facebook custom audiences. Streamline lead management and audience targeting effortlessly.

Free

Create new rows on Google Sheets for Ledger Entries on Etsy

Make will automatically add a new row to a Google Sheet from ledger entries on Etsy. This example uses the Google Sheet in [this link](https://docs.google.com/spreadsheets/d/184NyHGwUraPaxYvN090JkIJwkZi4kk35uyoR6P3nxKA/edit#gid=0). This scenario may be scheduled for every first day in a month.

Free

Create a The Keys Pro shared digicode for new Beds24 bookings and store the data in Google Sheets

Every time a new booking is made in Beds24, Make will automatically create a shared keypad with The Keys Pro. Then, the booking information is stored in Google Sheets.

Free

Music Producer Chatbot 🎵🎤 using Gemini + Suno (via Kei AI) & Google Drive Upload

This workflow creates an AI-powered chatbot that generates custom songs through an interactive conversation, then uploads the results to Google Drive. This workflow transforms n8n into a complete AI music production pipeline by combining: Conversational AI Structured data validation Tool orchestration External music generation API Cloud automation It demonstrates a powerful hybrid architecture: LLM Agent + Tools + API + Storage + Async Control Flow --- Key Advant

Free

Automate face swapping for GIFs with Fal.run AI and Google Services

This workflow allows you to automatically swap faces in animated GIFs using AI, without writing a single line of code. By simply inserting the URL of a face image and a GIF into a Google Sheet, the automation takes care of everything: it sends the data to AI platform, monitors the processing status, retrieves the final face-swapped GIF, uploads it to Google Drive, and updates the Google Sheet with the result. This solution is perfect for content creators, marketers, or developers looking to inte

Free

Generate authentic product reviews with OpenAI for WooCommerce

This workflow automatically generates natural product comments using AI and posts them to your WooCommerce store. It helps boost engagement and makes product pages look more active and authentic. How It Works Fetches all products from your WooCommerce store. Builds an AI prompt based on each product’s name and description. Uses OpenAI to generate a short, human-like comment (neutral, positive, negative, or questioning). Assigns a random reviewer name and email. Posts the comment back to WooComme

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free