E-commerce price tracker with ScrapeGraphAI, MongoDB, and Mailgun alerts

Product Price Monitor with Mailgun and MongoDB !Workflow Preview Image ⚠️ 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, records weekly product prices in MongoDB, analyzes seasonal trends, and emails a concise report to retail stakeholders via Mailgun. It helps retailers make informed inventory and pricing decisions by providing up-to-date pricing intelligence. Pre-conditions/Requirements Prerequisites - n8n instance (self-hosted, desktop, or n8n.cloud) - ScrapeGraphAI community node installed and activated - MongoDB database (Atlas or self-hosted) - Mailgun account with a verified domain - Publicly reachable n8n Webhook URL (if self-hosted) Required Credentials - ScrapeGraphAI API Key – Enables web scraping across target sites - MongoDB Credentials – Connection string (MongoDB URI) with read/write access - Mailgun API Key & Domain – To send summary emails MongoDB Collection Schema | Field | Type | Example Value | Notes | |-----------------|----------|---------------------------|---------------------------------------------| | productId | String | SKU-12345 | Unique identifier you define | | productName | String | Women's Winter Jacket | Human-readable name | | timestamp | Date | 2024-09-15T00:00:00Z | Ingest date (automatically added) | | price | Number | 79.99 | Scraped price | | source | String | example-shop.com | Domain where price was scraped | How it works This workflow automatically scrapes multiple e-commerce sites, records weekly product prices in MongoDB, analyzes seasonal trends, and emails a concise report to retail stakeholders via Mailgun. It helps retailers make informed inventory and pricing decisions by providing up-to-date pricing intelligence. Key Steps: - Webhook Trigger: Starts the workflow on a scheduled HTTP call or manual trigger. - Code (Prepare Products): Defines the list of SKUs/URLs to monitor. - Split In Batches: Processes products in manageable chunks to respect rate limits. - ScrapeGraphAI (Scrape Price): Extracts price, availability, and currency from each product URL. - Merge (Combine Results): Re-assembles all batch outputs into one dataset. - MongoDB (Upsert Price History): Stores each price point for historical analysis. - If (Seasonal Trend Check): Compares current price against historical average to detect anomalies. - Set (Email Payload): Formats the trend report for email. - Mailgun (Send Email): Emails weekly summary to specified recipients. - Respond to Webhook: Returns “200 OK – Report Sent” response for logging. Set up steps Setup Time: 15-20 minutes 1. Install Community Node In n8n, go to “Settings → Community Nodes” and install @n8n-community/nodes-scrapegraphai. 2. Create Credentials - Add ScrapeGraphAI API key under Credentials. - Add MongoDB credentials (type: MongoDB). - Add Mailgun credentials (type: Mailgun). 3. Import Workflow Download the JSON template, then in n8n click “Import” and select the file. 4. Configure Product List Open the Code (Prepare Products) node and replace the example array with your product objects { id, name, url }. 5. Adjust Cron/Schedule If you prefer a fully automated schedule, replace the Webhook with a Cron node (e.g., every Monday at 09:00). 6. Verify MongoDB Collection Ensure the collection (default: productPrices) exists or let n8n create it on first run. 7. Set Recipients In the Mailgun node, update the to, from, and subject fields. 8. Execute Test Run Manually trigger the Webhook URL or run the workflow once to verify data flow and email delivery. 9. Activate Toggle the workflow to “Active” so it runs automatically each week. Node Descriptions Core Workflow Nodes: - Webhook – Entry point that accepts a GET/POST call to start the job. - Code (Prepare Products) – Outputs an array of products to monitor