📊 Send sneaker restock alerts using ScrapeUnblocker, Google Sheets, and Gmail
⚡ 7 views · 📊 Market Research & Insights
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
Description
Quick Overview
This workflow runs on a frequent schedule to read monitored product URLs from Google Sheets, scrape each product page with ScrapeUnblocker, detect stock-status changes, update the sheet with the latest details, and send a restock alert email via Gmail.
How it works
- Runs on a minute-based schedule trigger.
- Reads product URLs and the last known status for each item from a Google Sheets tab.
- Loops through the rows and fetches each product page’s HTML using ScrapeUnblocker with a US proxy.
- Extracts product name, price, stock status, available quantity, and rating from the HTML and compares the current status to the previous status.
- When the status changes, updates the corresponding Google Sheets row with the latest status, price, and last-checked timestamp.
- Sends an HTML restock alert email via Gmail with the product details and a link to the product page.
Setup
- Add Google Sheets credentials and point the workflow to your spreadsheet and the Products sheet, ensuring columns like Product URL, Last Known Status, and row_number exist.
- Configure ScrapeUnblocker credentials and confirm the target product pages are accessible with your chosen proxy country settings.
- Add Gmail credentials and replace the “YOUR EMAIL” recipient value with your target email address.
- Adjust the schedule interval to match how often you want to check availability and to stay within scraping and email limits.
🔗 Nodes Used
Google Sheets, Gmail, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File