Price Change Tracker

This automation acts as a vigilant price tracking agent, working tirelessly on your behalf. Here's how it operates:

1. Reads Your Product List: It starts by reading a list of products from a Google Sheet you provide. The sheet should include the product name and the URL of its pricing page.
2. Visits Websites: For each product, the agent navigates to the specified pricing page using a secure cloud browser. It's smart enough to automatically handle and dismiss most popups and cookie banners that might get in the way.
3. AI-Powered Price Extraction: Using advanced AI, the agent analyzes the page to find the current price. It can differentiate between one-time purchase prices for physical goods and recurring prices for subscription services, intelligently identifying the cheapest paid plan.
4. Tracks and Compares: The newly found price is compared to the last known price stored in your Google Sheet.
5. Updates Your Sheet: The agent updates the Google Sheet with the new price and the date of the check, creating a historical log of price changes.
6. Sends Instant Alerts: If the price has changed by more than a percentage you define (e.g., 10%), it instantly sends a formatted alert to your designated Slack channel, so you never miss an important update.

Usage Ideas

• Monitor competitors' pricing for key products to stay competitive.
• Track the cost of SaaS subscriptions and other software to manage your company's budget.
• Create a personal deal-finder by tracking items on your wishlist across different retailers.
• Keep an eye on the cost of raw materials or components from supplier websites.
• Enforce Minimum Advertised Price (MAP) policies by monitoring retailer prices.

Customization Ideas

This template is a powerful starting point, but you can easily adapt it to your exact needs. You have the flexibility to:

• Use Your Own Data Source: While it's set up for Google Sheets, you can modify it to read your product list from other databases or applications.
• Customize Your Alerts: Send notifications to any Slack channel, or integrate with other messaging platforms like email or Microsoft Teams. You can also customize the content and format of the alert message itself.
• Set Your Own Thresholds: You decide what counts as a "significant" price change. Set the alert threshold to 5%, 10%, or any other value that makes sense for your business.
• Define Your Data Structure: Change the column names in your source sheet to match your existing data formats.
• Fine-Tune AI Extraction: If you're tracking prices on a particularly complex website, you can guide the AI with more specific instructions to improve its accuracy.