📊 Send Amazon price drop alerts with Google Sheets, ScrapeUnblocker, and Gmail
⚡ 105 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 checks Amazon product pages on a 4-hour schedule (or manually), extracts the current title and price via ScrapeUnblocker, logs results to Google Sheets, and sends a Gmail alert when a product’s price drops below the threshold stored in the sheet.
How it works
- Runs every 4 hours (or when manually executed) to start a price-check cycle.
- Reads the list of tracked products (including Product URL and Price Threshold) from a Google Sheets spreadsheet.
- Loops through each product and uses ScrapeUnblocker to fetch the Amazon product page HTML.
- Parses the HTML to extract the product title and price and converts the price into a numeric value for comparison.
- Updates the corresponding row in Google Sheets with the latest check date, extracted title, and price values.
- Compares the current numeric price to the stored threshold and, if the price is lower, sends a Gmail email with the product and price details.
Setup
- Add your Google Sheets OAuth credentials and update the spreadsheet ID and sheet/tab name used to read and update the Products list.
- Add your ScrapeUnblocker credentials and ensure the workflow uses each row’s Product URL (not a hard-coded URL) when scraping.
- Add your Gmail credentials and replace the recipient address in the Gmail step.
- Ensure your Google Sheet has columns for Product URL, Price Threshold, and a numeric price field (for example, price_clean) plus fields to store the last checked date and last price/title.
🔗 Nodes Used
Google Sheets, Gmail, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File