Turn ecommerce product URLs into leads with Google Sheets and MrScraper

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