This n8n workflow automates the process of tracking Amazon product prices, notifying users of significant price changes, and maintaining a historical record of prices. It is designed to periodically monitor specified products stored in a Google Sheets spreadsheet, fetch the latest price data via the ScrapeOps API, compare current prices with previous ones, and send detailed email alerts when thresholds are crossed.

Here’s a detailed breakdown:

1. The workflow starts with a Schedule Trigger that runs at regular intervals (every few hours).

2. It loads the list of products to monitor from a Google Sheets document, specified in the ‘Products to Monitor’ node.

3. It loops through each listed product using the ‘Loop Over Items’ node.

4. For each product, it makes an HTTP request to the ScrapeOps API to fetch structured product data from Amazon, using the product’s ASIN and an API key.

5. The data nodes extract relevant information such as product name, last known price, and product URL.

6. The workflow compares the current fetched price with the last recorded price to calculate the absolute and percentage change.

7. Based on the percentage change, it determines if an alert should be categorized as ‘High’ or ‘Low’ and updates the Google Sheets with the new data.

8. It creates an email alert template that notifies about the price increase or decrease, including product details, previous and current prices, and a link to the product.

9. It checks if the current price is valid and if the change crosses user-defined thresholds.

10. If conditions are met, it sends an email alert using SMTP credentials.

11. It logs each price update into the Google Sheets for historical analysis.

Practical use cases include online retailers, bargain hunters, price monitoring websites, or anyone managing multiple Amazon product watchlists who needs automated alerts and track records for pricing trends.