Automated Competitor Price Monitoring with Google Sheets
detail.loadingPreview
This n8n workflow provides a free, automated solution for monitoring competitor prices daily. It scrapes product pages, compares current prices against a Google Sheet, and identifies price changes, empowering businesses to react swiftly to market shifts.
About This Workflow
Stay ahead of the competition with this powerful n8n workflow designed for automated competitor price monitoring. Running daily at 8 AM, it intelligently fetches product URLs and their last known prices from your designated Google Sheet. Each product page is then visited, and the current price is expertly extracted using web scraping techniques, incorporating strategic pauses to ensure reliable data collection. The workflow meticulously compares the newly scraped price with the recorded 'last price,' calculating the percentage difference and flagging any changes. This robust automation not only saves countless hours but also provides critical, up-to-the-minute market intelligence, allowing you to adapt your pricing strategy with agility and precision.
Key Features
- Daily Automated Scans: Automatically checks competitor product pages every morning at 8:00 AM server time.
- Google Sheets Integration: Manages your product list and historical prices directly within a Google Sheet.
- Robust Web Scraping: Fetches live pricing data from specified product URLs using an HTTP request node with custom user agents.
- Dynamic Price Extraction: Utilizes CSS selectors to precisely pinpoint and extract current prices from complex HTML structures.
- Intelligent Price Change Detection: Compares current prices with historical data, identifying any shifts and calculating percentage differences.
- Rate Limit Management: Incorporates configurable wait times between requests to prevent IP blocking and ensure consistent scraping.
How To Use
- Prepare Your Google Sheet: Create a Google Sheet containing two essential columns:
product_url(the full URL of the competitor's product page) andlast_price(the last recorded price for that product, can be empty initially). - Configure Google Sheets Node: In the "Fetch Product List from Sheet" node, authenticate your Google Sheets account and select your prepared spreadsheet and the specific sheet (e.g., "product_data").
- Adjust Daily Schedule: If 8:00 AM isn't ideal for your operations, modify the "Daily 8 AM Trigger" node to your preferred execution time.
- Optimize Scraping Delay: Adjust the
amountparameter in the "Pause Between Requests" node (e.g., 20 seconds) to balance scraping speed with avoiding bot detection and rate limits from target websites. - Update CSS Selector for Price Extraction: Crucially, update the
cssSelectorin the "Extract Current Price from HTML" node to match the specific HTML structure where the price is displayed on your target competitor's website. The current selector.price__regular > span.price-item--regularis a common example, but will almost certainly need customization for different sites. - Extend Price Change Handling: The "Is Price Changed?" node acts as a gateway. Connect its
truebranch to further actions like sending email notifications (e.g., Gmail, SendGrid), Slack messages, or updating another column in your Google Sheet with the new price and timestamp. You can also add afalsebranch for logging or no action.
Apps Used
Workflow JSON
{
"id": "23aceb8a-0b59-4efb-9cc3-ae4defc7c99e",
"name": "Automated Competitor Price Monitoring with Google Sheets",
"nodes": 20,
"category": "Marketing",
"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: 23aceb8a-0b59...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Automated Multi-Platform Social Media Publisher
Streamline your social media content creation and publishing with this n8n workflow. Simply fill out a web form with your caption, media (image or video), and target platforms, and let n8n automate the posting process across multiple social networks.
WhatsApp AI Assistant: LLaMA 4 & Google Search for Real-Time Insights
Instantly deploy a smart AI assistant on WhatsApp, powered by Groq's lightning-fast LLaMA 4 model. This workflow enables real-time conversations, remembers context, and provides up-to-date answers by integrating live Google Search results.
AI-Powered On-Page SEO Audit & Report Automation
Instantly generate comprehensive on-page SEO technical and content audits for any website URL. This AI-powered workflow automates the entire process, from scraping the page to delivering a detailed report directly to your inbox, empowering you to optimize for better search rankings and user engagement.