Amazon Product Price Tracker and Alert System - n8n Workflow

Markdown-formatted:
E-commerce analysts or dropshippers needing to monitor competitor pricing.
Consumers looking to purchase high-value items at the lowest possible price.
Developers seeking advanced n8n templates utilizing external scraping APIs.
Anyone needing a scheduled, reliable n8n trigger for data extraction and alerting.

Keeping track of price movements for competitive analysis or personal shopping requires constant vigilance. This powerful n8n workflow eliminates manual checking by automating the process using a scheduled n8n trigger and the reliable ScrapeOps Amazon Product API. The core value of this n8n template is its complete automation loop: reading products from Google Sheets, scraping real-time data, performing complex price change calculations (absolute and percentage), setting an alert status based on user-defined thresholds, updating the main product list, and inserting a historical record. If a significant price change is detected, the n8n node for email sending dispatches a detailed notification. This ensures you never miss a critical price drop or increase, making this a highly efficient n8n solution.

The entire process is initiated by a scheduled n8n trigger set to run hourly.

1. Setup and Initialization: The flow starts with a 'Setup' n8n node that defines connection parameters, including the Google Sheet URL and the ScrapeOps API key.


2. Read Product List: The 'Products to Monitor' Google Sheets n8n node retrieves the list of items (ASINs, last known price, and alert thresholds) from your spreadsheet.


3. Iterate: The 'Loop Over Items' n8n node processes each product individually.


4. Fetch Data: The 'Scrapeops - Amazon Product' HTTP Request n8n node sends a request using the current ASIN and the API key to fetch structured, real-time product data from Amazon.


5. Data Processing: A 'Fields' n8n node extracts and cleans the current pricing data, converting it to a usable number.


6. Price Validation: The 'Check Valid Price' If n8n node ensures the scraped price is valid (greater than 0) before proceeding.


7. Calculate Change: The 'Price Change' n8n node calculates the absolute and percentage price difference relative to the 'Last Price' recorded in the Google Sheet.


8. Determine Alert: The 'Alert Status' n8n node compares the percentage change against the product's defined high and low thresholds, setting an alert flag if necessary.


9. Sheet Updates: The 'Update - Products to Monitor' and 'Insert - Price History' Google Sheets n8n nodes update the master list with the new price and log the historical data point.


10. Alert Decision: The 'Alert Decision' If n8n node checks the alert flag. If an alert is triggered, the flow proceeds to notification.


11. Send Notification: The 'Send Email' n8n node delivers a formatted HTML email containing the product details, old price, new price, and the magnitude of the change.

Markdown-formatted:
This advanced n8n workflow requires configuration for both Google Sheets and the ScrapeOps API.

1. Import the n8n workflow: Copy the provided JSON data and paste it into your n8n instance using the 'Import from JSON' function.


2. Google Sheets Setup:

1. API Key Setup (ScrapeOps):

1. Final Steps: Activate the 'Schedule Trigger' n8n node to start the automatic monitoring. Ensure your n8n workflow is active and credentials are correct to prevent execution failures.

Markdown-formatted:
This sophisticated n8n workflow relies on several key n8n nodes to manage data flow and API interaction:

Schedule Trigger: The initiating n8n trigger.
Function: Starts the entire price checking process automatically.
Key Configuration: Set to run every hour (interval: hours).

Products to Monitor (Google Sheets n8n node):
Function: Reads the list of products, including their ASINs, last recorded price, and custom alert thresholds, which are crucial inputs for the n8n workflow.
Key Configuration: Operation set to 'Read', reading from the 'Products to Monitor' sheet name.

Scrapeops - Amazon Product (HTTP Request n8n node):
Function: Performs the core data extraction by calling the ScrapeOps API endpoint for structured Amazon product data.
Key Configuration: Uses expressions to dynamically pass asin and apikey as query parameters.

Check Valid Price (If n8n node):
Function: Provides error handling and quality control by ensuring the extracted pricing value is valid (greater than zero) before proceeding with calculations. This is a critical flow control n8n node.

Price Change (Set n8n node):
Function: Calculates the numerical pricechange and the normalized percentchange by comparing the new scraped price against the previous price retrieved from Google Sheets.
Key Configuration: Uses complex Javascript expressions referencing the data from the 'Last Price' and 'Fields' n8n nodes.

Alert Decision (If n8n node):
Function: Acts as the gatekeeper for notifications, only passing items to the email n8n node if the alertstatus is not empty (i.e., a threshold was exceeded).

Update - Products to Monitor (Google Sheets n8n node):
Function: Writes the latest pricing, change metrics, and alert status back to the main inventory sheet.
Key Configuration: Operation set to 'Update', using the asin as the matching column to update the correct row.

Send Email (Email Send n8n node):
* Function: Constructs and sends a detailed, dynamically generated HTML email notification to the recipient defined in the 'Setup' n8n node.