Amazon Product Price Tracker

Who should use this workflow

• E-commerce Entrepreneurs: Individuals or businesses selling products on Amazon who want to monitor price changes and stay competitive.
• Price Analysts: Professionals analyzing market trends and pricing strategies to make informed decisions.
• Budget-Conscious Shoppers: Consumers tracking specific products to buy at the best price.
• Data-Driven Marketers: Marketers looking to gather insights on pricing trends for campaigns.
• Developers and Automation Enthusiasts: Users familiar with n8n or similar automation tools who want to streamline their workflows.

What problem does this workflow solve

• Price Monitoring: Automates the process of tracking Amazon product prices, ensuring users never miss a price drop or increase.
• Alerting System: Sends timely notifications via email when significant price changes occur, allowing users to make quick purchasing decisions.
• Data Management: Maintains a historical record of product prices for analysis, helping users understand pricing trends over time.
• Customization: Provides a flexible setup that allows users to define their own alert thresholds based on personal preferences.

Detailed explanation of the workflow process

1. Scheduled Trigger: The workflow is triggered on a defined schedule (e.g., every hour) to check for price updates.
2. Product Monitoring: Retrieves a list of products to monitor from a Google Sheets document.
3. Batch Processing: Loops through each product to process them individually.
4. Data Retrieval: Uses the ScrapeOps API to fetch the latest pricing information for each product based on its ASIN (Amazon Standard Identification Number).
5. Data Processing: Extracts relevant fields such as product name, current pricing, and calculates price changes and percentage changes.
6. Alert Status Evaluation: Compares the current price against previous prices to determine if the price change is significant (high or low alert).
7. Historical Data Logging: Records the current pricing and timestamp into a separate Google Sheets document for historical tracking.
8. Update Monitoring List: Updates the original product list in Google Sheets with the latest information, including alert status and price changes.
9. Email Notification: If a significant price change is detected, sends an email alert to the user with detailed information about the price change, including previous and current prices, and a link to the product.