Automated Competitor Pricing Tracker using AI Agents and Google Sheets - n8n Workflow

E-commerce Managers needing to monitor market prices instantly.
Data Analysts requiring automated competitor intelligence feeds.
Users looking for advanced web scraping n8n templates that handle anti-bot measures.
Automation Specialists interested in leveraging the n8n AI Agent framework with external tools.

This automation solves the critical business problem of maintaining competitive pricing without constant manual monitoring. Modern e-commerce sites often use anti-bot measures, making standard scraping difficult. This specific n8n workflow leverages the power of an AI Agent alongside Bright Data’s Mobile Carrier Proxy (MCP) to reliably access and extract product data, even from heavily protected sites like Nike.

By deploying this n8n automation, you set up a robust, repeatable process triggered by an n8n trigger. The extracted, structured data is immediately stored in Google Sheets for analysis and decision-making, ensuring you never miss a critical price change from your competition. This advanced n8n node combination represents a highly effective, low-maintenance pricing intelligence solution.

The entire process is controlled by the central n8n workflow, starting with a scheduled n8n trigger.

1. Start and Define Input: The 📅 Run weekly Check Schedule n8n trigger initiates the automation every Monday at 9 AM. It passes control to the 🛒 Product Page URL n8n node, which defines the specific competitor URL (e.g., a product category page) to target.


2. AI-Powered Scraping: The 🤖 Scrape Competitor Prices (MCP Agent) LangChain Agent takes the URL and a specific instruction (scrape all the details about every product). This sophisticated n8n node uses the connected OpenAI Chat Model for reasoning and the MCP Client (Bright Data) tool to perform the actual web browsing and data extraction.


3. Structured Data Parsing: The Agent’s output is run through the Auto-fixing Output Parser and Structured Output Parser n8n nodes, guaranteeing that the potentially messy, unstructured scrape results are converted into clean, standardized JSON data.


4. Data Preparation: The 🧹 Format Products for Google Sheets Code n8n node processes the array of products from the scraper. It splits the array, ensuring that each individual product (name, price, description, url) becomes a separate item in the n8n workflow for easier handling by Google Sheets.


5. Logging Data: The 📄 Save to Google Sheets n8n node takes these individual items and appends them as new rows to the designated 'Competitor Pricing Log' spreadsheet.


6. Notification: Finally, the 📧 Notify: Prices Logged in Sheet Gmail n8n node sends a notification email, confirming the successful capture and logging of the latest competitor pricing data.

To deploy this n8n template, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON code and paste it into your n8n instance using the 'New' -> 'Import from JSON' function.


2. Set Credentials: You must set up credentials for the following services:

1. Configure Google Sheets n8n node: In the 📄 Save to Google Sheets n8n node, select the correct Document ID and Sheet Name, ensuring your target sheet has columns matching the expected data fields (Name, Price, Description, URL).


2. Customize Input: Update the URL in the 🛒 Product Page URL n8n node to match the specific competitor page you wish to track.


3. Activate: Enable the n8n workflow to let the schedule trigger take over.

📅 Run weekly Check (Schedule Trigger): This n8n trigger starts the workflow based on a defined time interval. Key configuration: Set to run weekly.
🛒 Product Page URL (Set n8n node): Defines the static input URL used by the scraping agent. Key configuration: Sets the variable url to the target competitor product page.
🤖 Scrape Competitor Prices (MCP Agent) (Agent n8n node): The core intelligence, instructing the AI to use the MCP tool to scrape product details from the input URL. Key configuration: Uses gpt-4o-mini and is connected to the MCP Client tool.
OpenAI Chat Model (Language Model n8n node): Provides the language model backend for the Agent's decision-making and tool-use planning.
MCP Client (Tool n8n node): Integrates Bright Data's Mobile Carrier Proxy service, allowing the Agent to reliably perform web scraping on complex, dynamic websites.
Auto-fixing Output Parser (Parser n8n node): Ensures that the data scraped by the Agent conforms to the required structured JSON format, increasing data reliability.
🧹 Format Products for Google Sheets (Code n8n node): Transforms the single JSON item containing an array of products into multiple n8n items, one per product, suitable for batch insertion into the Google Sheets n8n node. Key configuration: Custom JavaScript to iterate and reformat the output array.
📄 Save to Google Sheets (Google Sheets n8n node): Writes the clean, formatted product data to the specified log sheet. Key configuration: Operation set to append, mapping fields like Name, Price, and URL.

• 📧 Notify: Prices Logged in Sheet (Gmail n8n node): Sends an alert upon successful logging of competitor prices. Key configuration: Sends a pre-defined subject and message to a target email address.