📊 Track e-commerce price changes with ScrapeGraphAI, Baserow & Pushover alerts

⚡ 205 views · 📊 Market Research & Insights

💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.

Description

Product Price Monitor with Pushover and Baserow

⚠️ COMMUNITY TEMPLATE DISCLAIMER: This is a community-contributed template that uses ScrapeGraphAI (a community node). Please ensure you have the ScrapeGraphAI community node installed in your n8n instance before using this template.

This workflow automatically scrapes multiple e-commerce sites for selected products, analyzes weekly pricing trends, stores historical data in Baserow, and sends an instant Pushover notification when significant price changes occur. It is ideal for retailers who need to track seasonal fluctuations and optimize inventory or pricing strategies.

Pre-conditions/Requirements

Prerequisites

An active n8n instance (self-hosted or n8n.cloud)
ScrapeGraphAI community node installed
At least one publicly accessible webhook URL (for on-demand runs)
A Baserow database with a table prepared for product data
Pushover account and registered application

Required Credentials

ScrapeGraphAI API Key – Enables web-scraping capabilities
Baserow: Personal API Token – Allows read/write access to your table
Pushover: User Key & API Token – Sends mobile/desktop push notifications
(Optional) HTTP Basic Token or API Keys for any private e-commerce endpoints you plan to monitor

Baserow Table Specification

Field Name	Type	Description
Product ID	Number	Internal or SKU
Name	Text	Product title
URL	URL	Product page
Price	Number	Current price (float)
Currency	Single select (`USD`, `EUR`, etc.)
Last Seen	Date/Time	Last price check
Trend	Number	7-day % change

How it works

Key Steps:

Webhook Trigger: Manually or externally trigger the weekly price-check run.
Set Node: Define an array of product URLs and metadata.
Split In Batches: Process products one at a time to avoid rate limits.
ScrapeGraphAI Node: Extract current price, title, and availability from each URL.
If Node: Determine if price has changed > ±5 % since last entry.
HTTP Request (Trend API): Retrieve seasonal trend scores (optional).
Merge Node: Combine scrape data with trend analysis.
Baserow Nodes: Upsert latest record and fetch historical data for comparison.
Pushover Node: Send alert when significant price movement detected.
Sticky Notes: Documentation and inline comments for maintainability.

Set up steps

Setup Time: 15-25 minutes

Install Community Node: In n8n, go to “Settings → Community Nodes” and install ScrapeGraphAI.
Create Baserow Table: Match the field structure shown above.
Obtain Credentials:
- ScrapeGraphAI API key from your dashboard
- Baserow personal token (/account/settings)
- Pushover user key & API token
Clone Workflow: Import this template into n8n.
Configure Credentials in Nodes: Open each ScrapeGraphAI, Baserow, and Pushover node and select/enter the appropriate credential.
Add Product URLs: Open the first Set node and replace the example array with your actual product list.
Adjust Thresholds: In the If node, change the 5 value if you want a higher/lower alert threshold.
Test Run: Execute the workflow manually; verify Baserow rows and the Pushover notification.
Schedule: Add a Cron trigger or external scheduler to run weekly.

Node Descriptions

Core Workflow Nodes:

Webhook – Entry point for manual or API-based triggers.
Set – Holds the array of product URLs and meta fields.
SplitInBatches – Iterates through each product to prevent request spikes.
ScrapeGraphAI – Scrapes price, title, and currency from product pages.
If – Compares new price vs. previous price in Baserow.
HTTP Request – Calls a trend API (e.g., Google Trends) to get seasonal score.
Merge – Combines scraping results with trend data.
Baserow (Upsert & Read) – Writes fresh data and fetches historical price for comparison.
Pushover – Sends formatted push notification with price delta.
StickyNote – Documents purpose and hints within the workflow.

Data Flow:

Webhook → Set → SplitInBatches → ScrapeGraphAI
ScrapeGraphAI → If
- True branch → HTTP Request → Merge → Baserow Upsert → Pushover
- False branch → Baserow Upsert

Customization Examples

Change Notification Channel to Slack

// Replace the Pushover node with Slack
{
  "channel": "#pricing-alerts",
  "text": `🚨 ${$json["Name"]} changed by ${$json["delta"]}% – now ${$json["Price"]} ${$json["Currency"]}`
}

Additional Data Enrichment (Stock Status)

// Add to ScrapeGraphAI's selector map
{
  "stock": {
    "selector": ".availability span",
    "type": "text"
  }
}

Data Output Format

The workflow outputs structured JSON data:

{
  "ProductID": 12345,
  "Name": "Winter Jacket",
  "URL": "https://shop.example.com/winter-jacket",
  "Price": 79.99,
  "Currency": "USD",
  "LastSeen": "2024-11-20T10:34:18.000Z",
  "Trend": 12,
  "delta": -7.5
}

Troubleshooting

Common Issues

Empty scrape result – Check if the product page changed its HTML structure; update CSS selectors in ScrapeGraphAI.
Baserow “Row not found” errors – Ensure Product ID or another unique field is set as the primary key for upsert.

Performance Tips

Limit batch size to 5-10 URLs to avoid IP blocking.
Use n8n’s built-in proxy settings if scraping sites with geo-restrictions.

Pro Tips:

Store historical JSON responses in a separate Baserow table for deeper analytics.
Standardize currency symbols to avoid false change detections.
Couple this workflow with an n8n Dashboard to visualize price trends in real-time.

🔗 Nodes Used

HTTP Request, Postgres, Webhook, Pushover

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup