How it works

1. Every day the workflow starts on a schedule. 2. It reads the watchlist rows from your Google Sheet (ASIN and target price per product). 3. For each product it calls a price-scraping API over HTTP with the ASIN. 4. The JSON answer is parsed to get the product name and the current price. 5. The price is appended to your price-history sheet. 6. If the current price is at or below the target price, Gmail sends you a price-drop email.