Turn ecommerce product URLs into leads with Google Sheets and MrScraper

Description

Ecommerce Leads Finder & Contact Extraction

This n8n workflow automates the process of finding ecommerce seller leads, enriching them with product and business details, discovering company websites, and extracting contact information such as emails and phone numbers.

The workflow starts from a list of product URLs stored in Google Sheets, checks whether product details have already been scraped, and only runs new scraping jobs when needed. It uses MrScraper to collect detailed product, seller, and business information, then formats the extracted data into clean lead fields before saving everything back into Google Sheets.

After the product and seller data is collected, the workflow can search Google SERP results to identify the seller’s real company website. It applies scoring logic to filter out marketplaces, social platforms, directories, and low-confidence matches, helping keep the lead list clean and relevant.

Once a company website or contact page is found, the workflow checks cached contact extraction results and runs a contact scraper when needed. The final output includes product details, seller profile data, business name, address, license number, company URL, contact URL, emails, and phone numbers.

What this workflow does

Reads ecommerce product URLs from Google Sheets
Scrapes product, seller, and business details
Avoids duplicate scraping by checking cached MrScraper results
Saves enriched lead data into Google Sheets
Finds likely company websites using Google SERP
Filters out social media, marketplaces, and irrelevant domains
Extracts contact details from company/contact pages
Updates lead status automatically

Best for

This workflow is useful for lead generation, ecommerce research, seller prospecting, B2B outreach, marketplace intelligence, and building targeted contact lists from ecommerce product pages.

Tools used

n8n
Google Sheets
MrScraper
Google SERP API
JavaScript Code nodes
HTTP Request nodes

Suggested post caption

Turn ecommerce product URLs into enriched B2B leads automatically.

This n8n workflow takes a list of product URLs, scrapes product and seller details, finds the seller’s real company website, extracts contact information, and saves everything into Google Sheets.

It includes caching logic to avoid duplicate scraping, SERP-based company URL discovery, smart filtering for irrelevant domains, and contact extraction for emails and phone numbers.

Perfect for ecommerce lead generation, seller research, and automated prospecting workflows.