This n8n workflow automates the process of monitoring competitor prices for products listed in a Google Sheets database and sending notifications based on price comparisons. It is triggered on a scheduled basis, fetches unchecked product rows, retrieves live prices from competitors’ websites, compares these prices with your own, and updates the Google Sheets with the results — all while notifying through Discord when certain conditions are met.
The workflow begins with a schedule trigger that initiates the process daily or at a specified interval. It then fetches unchecked product rows from Google Sheets, which contain product details such as name, URL, and your price. For each product, it makes an HTTP request to the competitor’s product page, extracts the displayed price using HTML parsing, and converts the string price into a numeric format.
Next, it compares the fetched competitor price to your own. If the competitor’s price is lower, it sends an alert message to Discord, notifying your team of the price drop. The system updates the Google Sheets to mark the comparison as checked and resets the status for the next cycle. Additional sticky notes within the workflow provide documentation and guidance on the process, making it easy to adapt and modify for specific use cases.
This automation is ideal for e-commerce businesses, online retailers, or price-sensitive shops that want to stay competitive by continuously monitoring and responding to market price changes without manual effort.
Reviews
There are no reviews yet.