n8n Automated Competitor Pricing Monitor with Bright Data MCP & OpenAI

Scheduled trigger → set target URL → read historical prices → AI agent scrapes and structures pricing → compare changes → conditionally update Google Sheets

Who

Product, sales, or marketing teams tracking competitor pricing changes; users with some n8n experience

You get

Automatically scrape competitor pricing pages on a schedule and update the tracking sheet only when prices change, reducing manual checks and information overload

You need

n8n · google-sheets

Steps

1. Configure trigger and target parameters

   Import the workflow JSON into n8n. Add a Schedule Trigger node and set the check interval (e.g., daily at 9 AM). Add a Set node and define a url field in assignments (default example: https://clickup.com/pricing), which can be replaced with another competitor pricing page URL.

2. Retrieve historical pricing data

   Add a Google Sheets node (Read mode) and connect an authorized Google account. Specify the documentId and sheetName (e.g., Sheet1). This node fetches saved historical prices for plans 1–4 from the sheet to serve as the comparison baseline.

3. AI agent scrapes and structures pricing

   Add an AI Agent node with promptType set to define and paste the prompt. Connect an MCP Client Tool node (tool name scrape_as_markdown, credential type mcpClientApi) as the agent tool to fetch page markdown via Bright Data proxy. Connect the OpenAI LLM Brain (gpt-4o-mini) as the language model. Add a Structured Output Parser sub-node with a jsonSchemaExample defining a plans array where each item has plan_name, price, and key_features. Auto-fixing Output Parser handles format recovery.

   Execution prompt · Source text。AI Agent node text field (promptType=define)

   Copy prompt

   =Scrape Plan name and pricing from the url below
   url: {{ $('🛠️ Set Search Parameters').item.json.url }}

4. Compare price changes

   Add an IF node (typeVersion 2.2) with 4 AND conditions comparing Retrieve Pricing data output fields '1 Pricing' through '4 Pricing' against AI agent output output.plans[0].price through plans[3].price. If all match, route to the false branch; if any differ, route to the true branch to trigger an update.

5. Conditionally update Google Sheets

   After the IF true branch, add a Google Sheets node (Update mode, mappingMode=defineBelow, matchingColumns=["row_number"], row_number fixed to 2). Map AI agent outputs to columns: 1–4 Plan, 1–4 Pricing, 1–4 Key Features. Ensure row 2 in the sheet exists with corresponding column headers.

You are an n8n workflow setup assistant. The user wants to replicate a competitor pricing monitor. Assist in this order: 1) Confirm the user has self-hosted n8n with community node support; 2) Verify that OpenAI, Bright Data MCP, and Google Sheets OAuth2 credentials are configured; 3) Guide importing the workflow JSON and replacing the target URL in the Set node; 4) Explain the required Google Sheet column structure (1–4 Plan / Pricing / Key Features) and data row 2; 5) Note that the AI Agent prompt is embedded and works without changes, but can be fine-tuned for other target sites. Do not send any API requests or real credentials on behalf of the user.