Competitor Pricing Intelligence Dashboard Setup - n8n Workflow

• E-commerce store managers needing real-time price intelligence.


• Marketing analysts tracking competitive market positioning.


• Business owners looking for highly customizable price monitoring n8n templates.


• Users familiar with n8n seeking to integrate complex scraping, AI, and scripting into one automated solution.

Maintaining a competitive edge requires timely and accurate pricing data. Manually checking competitor sites is inefficient and slow. This n8n workflow provides a powerful solution by combining reliable web scraping with advanced AI data extraction.

The automation starts with a flexible n8n trigger system (daily schedule or manual webhook). It then simultaneously scrapes multiple e-commerce platforms (Amazon, Best Buy, Target). The crucial next step uses a specialized AI n8n node to turn raw HTML into perfectly structured JSON data, eliminating reliance on brittle CSS selectors. A custom Code n8n node then analyzes this clean data, calculating value scores and detecting alert-worthy price drops.

Finally, this sophisticated n8n workflow ensures that all historical data is logged automatically into Google Sheets for dashboarding, while immediate, actionable alerts are sent via Slack when a significant price change is detected. This makes it an indispensable n8n tool for competitive analysis.

This comprehensive n8n workflow follows a five-step process:

1. Triggering the Check: The process begins via a dual n8n trigger setup: either a recurrent Daily Price Check Trigger running every 24 hours for scheduled monitoring, or a Manual Price Check Webhook for on-demand execution.


2. Parallel Scraping: Upon activation, the n8n workflow initiates three parallel HTTP Request n8n nodes (Amazon Price Scraper, Best Buy Price Scraper, Target Price Scraper) to retrieve the raw HTML search results from major competitor websites for 'wireless headphones'.


3. AI Extraction: The outputs from all three scraping n8n nodes are fed into the AI Price Data Extractor n8n node (ScrapeGraphAI). This powerful n8n node uses a user-defined schema and AI prompting to reliably extract clean, structured pricing data (price, brand, rating, discount, etc.) from the potentially complex HTML content.


4. Analysis and Intelligence: The Price Analysis & Intelligence Code n8n node processes the extracted data. This custom logic analyzes price changes, calculates competitive value scores, determines market positioning, and assigns a priority level, setting the alert_worthy flag if significant price movement is detected.


5. Logging and Alerting: The results are split. First, all processed data is appended or updated in the Google Sheets Price Log n8n node for historical archiving. Simultaneously, the data is routed through the Price Change Alert Filter n8n node. If any condition is met (e.g., price drop is 'high significance' or discount is over 20%), the workflow proceeds to the Slack Price Alert n8n node, sending a detailed, actionable notification.

To deploy this n8n template, follow these steps:

1. Import the n8n workflow: Copy the provided JSON data and paste it directly into your n8n instance using the 'New' -> 'Import from JSON' option.


2. Set Up Credentials: You will need to configure credentials for the following services:

1. Configure Google Sheet: In the Google Sheets Price Log n8n node, select the target spreadsheet document ID and sheet name where you want the historical price data to be logged.


2. Configure Slack Alert: In the Slack Price Alert n8n node, ensure the correct channel ID is selected.


3. Activate: Save and activate the n8n workflow. The Daily Price Check Trigger will automatically begin monitoring.

Daily Price Check Trigger (n8n trigger):
Function: Starts the n8n workflow automatically at a fixed interval.
Key Configuration: Set to run every 24 hours.
Manual Price Check Webhook (n8n trigger):
Function: Allows external systems or manual requests to initiate a price check immediately.
Key Configuration: Uses a GET method on the path /price-check-webhook.
Amazon/Best Buy/Target Price Scraper (HTTP Request n8n node):
Function: Executes raw HTTP requests to fetch search result pages from competitor sites.
Key Configuration: Uses a custom User-Agent header to mimic a browser, improving reliability.
AI Price Data Extractor (ScrapeGraphAI n8n node):
Function: Converts the raw, unstructured HTML output from the scraping nodes into clean, structured JSON data using AI intelligence, based on a comprehensive pricing schema.
Key Configuration: Requires a detailed JSON schema prompt to guide extraction (including fields like currentprice, rating, brand, and discountpercentage).
Price Analysis & Intelligence (Code n8n node):
Function: Executes custom JavaScript logic to analyze and enrich the extracted pricing data.
Key Configuration: Contains functions to calculate value scores, determine market position (budget/premium), and critically, set the alertworthy flag based on predefined price change thresholds (e.g., 15% drop).
Price Change Alert Filter (If n8n node):
Function: Acts as a gatekeeper, determining if the analyzed price change warrants an immediate alert.
Key Configuration: Combines conditions using 'any' operator, checking if the item is alertworthy, has a discount >= 20%, or has been marked with 'high' change significance.
Google Sheets Price Log (Google Sheets n8n node):
Function: Stores the detailed, analyzed price data for historical tracking and dashboard creation.
Key Configuration: Uses the appendOrUpdate operation, mapping input fields automatically to columns like productid, currentprice, and tracking_priority.
Slack Price Alert (Slack n8n node):
Function: Sends a highly formatted, detailed alert notification to a specified Slack channel if the price change filter passes.
Key Configuration: Uses extensive templating (Jinja2) to format the alert, including current price, discount percentage, source, and competitive intelligence metrics like market position, providing an actionable alert from this powerful n8n workflow.