Track Price Changes with Alerts
This automation can monitor both SaaS subscriptions and product prices from a list of websites, compares them against previous values stored in a Google Sheet, and sends an alert to Slack if a price changes beyond a set threshold.
This automation acts as a vigilant price-tracking assistant. Here’s how it works:
- Reads Your List: It starts by reading a list of products and their pricing page URLs directly from a Google Sheet you provide. You can copy this product Google Sheet
- Visits Each Page: For each product in your list, the automation navigates to the specified URL in a cloud browser.
- Extracts the Price: Using AI, it intelligently scans the webpage to find and extract the current price, whether it's a subscription fee or a one-time cost.
- Compares and Analyzes: It compares this newly found price with the last price recorded in your Google Sheet and calculates the percentage change.
- Sends Smart Alerts: If the price change is greater than a threshold you define (e.g., 10%), it automatically sends a detailed alert message to a Slack channel of your choice.
- Updates Google Sheet: Finally, it updates your Google Sheet with the new price and the date it was checked, keeping your records current.
Usage Ideas
- Monitor your competitors' prices to stay competitive in the market.
- Track the cost of raw materials or components from supplier websites to manage procurement budgets.
- Keep an eye on your favorite products across different e-commerce sites and get notified of sales or price drops.
- Automate the tracking of SaaS subscription costs for tools your company uses.
- Verify that your partners are adhering to Minimum Advertised Price (MAP) policies.
Customization Ideas
You can easily tailor this automation to fit your specific needs. You will have the flexibility to:
- Use Your Own Data: Connect the automation to your own Google Sheet. You can specify which columns contain the product name, URL, and price.
- Set Your Alert Channel: Direct notifications to any Slack channel you own.
- Define "Significant" Change: Adjust the price change percentage that triggers an alert. Monitor for small fluctuations or only for major price shifts.
- Customize Notifications: Change the content and format of the Slack alert message to include the information that matters most to you.
- Control the Scope: Choose to process your entire product list or just a specific number of items for testing or quick checks.