{
  "name": "Track competitor pricing and features with BrowserAct and Google Sheets",
  "nodes": [
    {
      "id": "aa0249f3-4365-4148-81d7-fafaacd022d1",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        512,
        224
      ]
    },
    {
      "id": "a166259b-5ea7-4395-8fb7-fc70aa25e1e2",
      "name": "Aggregate",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1072,
        -32
      ]
    },
    {
      "id": "c9b8a456-537a-44ae-b6d7-c2b951590e4d",
      "name": "Weekly Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        224
      ]
    },
    {
      "id": "b4f8640e-50b4-41c6-a27a-0aa8d0f19acd",
      "name": "Update Database",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1600,
        368
      ]
    },
    {
      "id": "4da38ef6-f46b-48e7-b59e-92f2b43b8a75",
      "name": "Extract page content",
      "type": "n8n-nodes-browseract.browserAct",
      "position": [
        832,
        240
      ]
    },
    {
      "id": "56da0406-37ef-4144-be18-70809949babe",
      "name": "Analyze target pages",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1056,
        240
      ]
    },
    {
      "id": "09ffb3c0-bdd2-4fc2-8663-2829e98f5775",
      "name": "Retrieve \"loop\" results",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        848,
        -32
      ]
    },
    {
      "id": "9d639aec-b759-4f57-8fa5-30e6fba52cd9",
      "name": "Analyze competitor data & generate report",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1296,
        -128
      ]
    },
    {
      "id": "e2843d79-8a8f-4ba2-924b-cb3c5c675e93",
      "name": "Structured Output",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1184,
        400
      ]
    },
    {
      "id": "c5f39358-d80c-4a14-b628-a8c7dc74399c",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1376,
        80
      ]
    },
    {
      "id": "e6198a1e-d9a4-49d7-9fa5-b6cf81d6e40b",
      "name": "Create New Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1856,
        -32
      ]
    },
    {
      "id": "e49f86d3-abeb-4405-a784-c4b9fa0bb186",
      "name": "Define Headers",
      "type": "n8n-nodes-base.set",
      "position": [
        2096,
        -32
      ]
    },
    {
      "id": "da2b2c8b-d0a8-4f38-8551-e8d179bc146d",
      "name": "Add Headers",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2320,
        -32
      ]
    },
    {
      "id": "c709d54c-1204-4494-ada1-d0407ca73b84",
      "name": "Update records",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2544,
        -32
      ]
    },
    {
      "id": "ebec6544-8d56-4d9d-b93b-35ec679d3934",
      "name": "Notify on completion",
      "type": "n8n-nodes-base.slack",
      "position": [
        2784,
        -32
      ]
    },
    {
      "id": "ad7f458c-0dde-4513-85d7-2539d12ad968",
      "name": "OpenRouter",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        1264,
        80
      ]
    },
    {
      "id": "50bbe9bc-776a-444c-9fa7-5a332643c5f6",
      "name": "OpenRouter Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        1040,
        416
      ]
    },
    {
      "id": "c17038d3-e815-45e4-9e8d-f62674f32a70",
      "name": "Documentation",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        -352
      ],
      "parameters": {
        "width": 380,
        "height": 536,
        "content": "## ⚡ AI Competitor Spy: Pricing & Feature Tracker\n\n**Summary:** This automation continuously monitors competitor websites for pricing and feature updates. It scrapes current data, compares it against "
      }
    },
    {
      "id": "eea22642-2dee-4113-92ea-69c500dfeadc",
      "name": "Step 1 Explanation",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        48
      ],
      "parameters": {
        "width": 620,
        "height": 140,
        "content": "### 🎯 Step 1: Target Retrieval\n\nThe workflow triggers weekly. It connects to a Google Sheet database to fetch a list of competitor URLs and their previously recorded data (Last Scrape Content) to esta"
      }
    },
    {
      "id": "0fe135c4-c91a-4555-81d9-4c0de3ea18a4",
      "name": "Step 2 Explanation",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        464,
        576
      ],
      "parameters": {
        "width": 1272,
        "height": 152,
        "content": "### 🕵️ Step 2: Live Scraping\n\nBrowserAct visits each competitor's pricing page in real-time. It extracts the current plan names, prices, and feature lists, ensuring the data is fresh and accurate.An A"
      }
    },
    {
      "id": "37d8f4f4-5442-47f6-9c1b-c0aaddc8d52e",
      "name": "Step 4 Explanation",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1856,
        -176
      ],
      "parameters": {
        "width": 1032,
        "height": 120,
        "content": "### 💾 Step 4: Archiving & Reporting\n\nThe workflow creates a new tab in the Google Sheet for the current week's report. It saves the AI's comparative analysis and updates the main database with the new"
      }
    },
    {
      "id": "da56e279-f0e6-4468-bc9e-80b17bf804d2",
      "name": "Fetch links & history",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        256,
        224
      ]
    },
    {
      "id": "da00c87f-43d1-4a6a-83d5-f2bfb6cec300",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        -352
      ],
      "parameters": {
        "width": 624,
        "height": 368,
        "content": "@[youtube](yBGtCt4gIdA)"
      }
    }
  ],
  "connections": {
    "Aggregate": {
      "main": [
        [
          {
            "node": "Analyze competitor data & generate report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenRouter": {
      "ai_languageModel": [
        [
          {
            "node": "Analyze competitor data & generate report",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "Structured Output Parser",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Add Headers": {
      "main": [
        [
          {
            "node": "Update records",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Define Headers": {
      "main": [
        [
          {
            "node": "Add Headers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update records": {
      "main": [
        [
          {
            "node": "Notify on completion",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Weekly Trigger": {
      "main": [
        [
          {
            "node": "Fetch links & history",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Retrieve \"loop\" results",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Extract page content",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Database": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create New Sheet": {
      "main": [
        [
          {
            "node": "Define Headers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenRouter Model": {
      "ai_languageModel": [
        [
          {
            "node": "Analyze target pages",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "Structured Output",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output": {
      "ai_outputParser": [
        [
          {
            "node": "Analyze target pages",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Analyze target pages": {
      "main": [
        [
          {
            "node": "Update Database",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract page content": {
      "main": [
        [
          {
            "node": "Analyze target pages",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch links & history": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Retrieve \"loop\" results": {
      "main": [
        [
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Analyze competitor data & generate report",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Analyze competitor data & generate report": {
      "main": [
        [
          {
            "node": "Create New Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}