Extract product details from search result URLs with MrScraper and Google Sheets
UnknownWhat this workflow does
This workflow has 10 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Gmail, Google Sheets and Mrscraper (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get List Search Page (Google Sheets): uses Google Sheets
- Looping Listing Page url (Loop Over Items (Split in Batches)): loops over the items in batches
- Extract All Url (Code): runs custom Python code
- Run listing agent scraper (Mrscraper): listing agent
- Looping Detail Page url (Loop Over Items (Split in Batches)): loops over the items in batches
- Flatten Object (Code): runs custom JavaScript code
- Run general agent scraper (Mrscraper): general agent
- Append or update row in sheet (Google Sheets): append or update
- Send a message (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-mrscraper is verified or supports 3.0 (used in Run listing agent scraper, Run general agent scraper).
Nodes used (6)
- Code
n8n-nodes-base.code - Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Mrscraper
n8n-nodes-mrscraper.mrscraper - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets
From the author
Description This n8n template automates the extraction of structured product data from search results pages — using a pre-built list of search/listing URLs stored in Google Sheets as the starting point. Instead of crawling a domain from scratch, this workflow…