Price Change Tracker
Automates the process of monitoring product prices on various websites. It tracks price history in a Google Sheet and sends real-time alerts via Slack whenever a significant price change is detected.
Eduardo Rodriguez
Featured Apps
This automation acts as a vigilant price tracking agent, working tirelessly on your behalf. Here's how it operates:
- 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.
- 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.
- 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.
- Tracks and Compares: The newly found price is compared to the last known price stored in your Google Sheet.
- 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.
- 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.
Agent Inputs
Required Parameters
Name | Type | Default |
|---|---|---|
googleSheetUrl | string | None |
URL of the Google Sheet containing product data. The sheet should have columns: Product, Pricing page, Starter Price, Last Review | ||
Optional Parameters
Name | Type | Default |
|---|---|---|
maxProductsToProcess | number | -1 |
Maximum number of products to process. Set to -1 to process all products in the sheet | ||
priceChangeThreshold | number | 10 |
Percentage change threshold that triggers a Slack alert (e.g., 10 means alert when price changes by 10% or more) | ||
slackChannel | string | #REDACTED_SLACK_CHANNEL |
Slack channel where price change alerts will be sent (e.g., #price-alerts) | ||
