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.

How users can customize and adapt this workflow

- API Key Configuration: Users need to insert their ScrapeOps API key in the "Scrapeops - Amazon Product" node for data retrieval.
- Google Sheets Integration: Update the spreadsheet URL in the "Setup" node to link to your own Google Sheets document for tracking products and price history.
- Alert Thresholds: Modify the alert thresholds in the Google Sheets document to set personal preferences for price alerts (high and low).
- Email Settings: Change the email addresses in the "Setup" node to customize the sender and recipient of the alert notifications.
- Schedule Frequency: Adjust the schedule trigger settings to change how frequently the workflow checks for price updates (e.g., every hour, daily, etc.).