Automated Price Monitoring and Alerting System
detail.loadingPreview
This workflow automates price monitoring by regularly checking competitor prices against your own. Receive instant alerts on Discord when a competitor drops their price, ensuring you can react quickly to maintain your competitive edge.
About This Workflow
This n8n workflow is designed to streamline your price competitiveness by automating the process of monitoring competitor pricing. It begins by scheduling regular checks, then retrieves unchecked product data from a Google Sheet. For each product, it fetches the competitor's page, extracts the current price using HTML parsing, and converts it to a numerical format. A conditional check then compares the competitor's price to your own. If the competitor's price is lower, an immediate alert is sent to Discord, detailing the product and price discrepancies. Finally, the workflow updates the product's status in your Google Sheet, marking it as checked and recording the competitor's price for future reference.
Key Features
- Scheduled Price Checks: Automatically run price monitoring at predefined intervals.
- Real-time Competitor Price Extraction: Dynamically scrapes competitor websites for pricing information.
- Intelligent Price Comparison: Compares competitor prices against your own to identify opportunities.
- Instant Discord Alerts: Receive immediate notifications on Discord for price drops.
- Google Sheets Integration: Seamlessly read product data and update status in your Google Sheets.
How To Use
- Schedule Trigger: Configure the 'Schedule Trigger' node to set the frequency of your price checks (e.g., daily, hourly).
- Google Sheets Integration: Set up your 'Google Sheets' credentials and specify the 'documentId' and 'sheetName' for your product price list. Ensure your sheet has columns for 'Product Name', 'my Price', 'Competitor URL', and 'checked' (initially set to '0').
- HTTP Request & HTML Extraction: The 'HTTP Request' node will fetch competitor product pages using URLs from your Google Sheet. The 'HTML' node will extract the price using a specified CSS selector (e.g.,
.price_color). - Price Conversion: Use the 'Code' node to clean and convert the extracted price string into a usable number.
- Conditional Alerting: The 'IF' node compares the competitor's price to your price. If the competitor's price is lower, it triggers the alert.
- Discord Notification: Configure the 'Discord' node with your webhook URL to send alerts detailing price changes.
- Update Google Sheet: The final 'Google Sheets' node updates the 'checked' status to '1' and records the 'competitor price' for the row that was just processed.
Apps Used
Workflow JSON
{
"id": "aded401f-51dc-4bde-9c8e-be515d56db98",
"name": "Automated Price Monitoring and Alerting System",
"nodes": 21,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: aded401f-51dc...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Related Workflows
Discover more workflows you might like
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.