{
  "name": "Track competitor prices and email AI insights with Google Sheets, Groq and Gmail",
  "nodes": [
    {
      "id": "55dd9e2e-7975-4658-a4f1-91f65d01a4ef",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1744,
        1648
      ]
    },
    {
      "id": "b5876e55-9cd6-4ab9-9f4d-289a5b49fc52",
      "name": "First time price and offer added",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3392,
        1344
      ]
    },
    {
      "id": "0b18fdc3-6a8e-40b7-9bac-8b5847169f92",
      "name": "Clean Content",
      "type": "n8n-nodes-base.code",
      "position": [
        2400,
        1440
      ]
    },
    {
      "id": "d027b557-278d-444f-8c9e-39f08ce70bd6",
      "name": "If1",
      "type": "n8n-nodes-base.if",
      "position": [
        3424,
        1728
      ]
    },
    {
      "id": "bdc53d46-067b-4c76-ad80-faf54ae09c16",
      "name": "current Price and offer",
      "type": "n8n-nodes-base.code",
      "position": [
        2976,
        1440
      ]
    },
    {
      "id": "63a93274-286b-4297-8c88-e2f5a4670914",
      "name": "Updated current price and offer in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3648,
        1440
      ]
    },
    {
      "id": "e120201d-9c99-4d1b-a8a8-6a26d30f0097",
      "name": "If No changes then update",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3648,
        1824
      ]
    },
    {
      "id": "90177dfc-c7f9-4004-a724-bf8629e8052f",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1952,
        1360
      ]
    },
    {
      "id": "e42f254f-a5f2-45ef-a056-345a1c190dbe",
      "name": "Get row(s) in sheet1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3888,
        1216
      ]
    },
    {
      "id": "4ba86166-d0fb-4fa1-9e6f-64507b9e1011",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        4336,
        1216
      ]
    },
    {
      "id": "99b898c6-5174-4ba5-8de5-cab9640170ac",
      "name": "Groq Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGroq",
      "position": [
        4336,
        1392
      ]
    },
    {
      "id": "b8a4a0b4-5fa0-493a-9dba-e5361618126f",
      "name": "AI Agent1",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        2624,
        1440
      ]
    },
    {
      "id": "7466ace9-7fbf-48c1-960d-01708b371f7c",
      "name": "Groq Chat Model1",
      "type": "@n8n/n8n-nodes-langchain.lmChatGroq",
      "position": [
        2704,
        1664
      ]
    },
    {
      "id": "5259741c-1022-4b96-9f56-b9bffe110617",
      "name": "Data Aggregator",
      "type": "n8n-nodes-base.code",
      "position": [
        4112,
        1216
      ]
    },
    {
      "id": "abb5128f-8b2e-4ba2-87e1-ddf1b391ce58",
      "name": "Update row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        4688,
        1216
      ]
    },
    {
      "id": "fa305685-440b-4093-ae6c-aed6cd5a9c62",
      "name": "Simple Memory",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        4432,
        1392
      ]
    },
    {
      "id": "4fcc962b-53f6-4fd0-b1b0-98baa5346dca",
      "name": "Send a message",
      "type": "n8n-nodes-base.gmail",
      "position": [
        5136,
        1216
      ]
    },
    {
      "id": "0ece3db6-baa2-484a-b119-ce6320fd275b",
      "name": "Update row in sheet1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        5584,
        1216
      ]
    },
    {
      "id": "bdafea30-2aba-4349-a8a9-6aab41ed6ccf",
      "name": "Get row(s) in sheet2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        5360,
        1216
      ]
    },
    {
      "id": "b5e4f0c7-1c0c-493f-a44a-494d9cf8625b",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        1520,
        1648
      ]
    },
    {
      "id": "e5467947-0b3c-4319-96e1-30ea959e7982",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        848,
        928
      ],
      "parameters": {
        "width": 592,
        "height": 1296,
        "content": "# Daily Competitor Price & Offer Monitor\n\n### How it works\nThis workflow automatically tracks competitor pricing and promotional offers from your Google Sheets database. It scrapes live product pages,"
      }
    },
    {
      "id": "ac628a5b-4c1e-43b7-83e7-d317b6bb07c1",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1472,
        928
      ],
      "parameters": {
        "width": 416,
        "height": 1296,
        "content": "## Step 1: Database Sync\nFetch competitor names and product URLs from Google Sheets."
      }
    },
    {
      "id": "35fe8e51-b7b6-4298-bad0-f06b298268e1",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1904,
        928
      ],
      "parameters": {
        "width": 656,
        "height": 1296,
        "content": "## Step 2: Scraping\nPull raw product page data using ScraperAPI."
      }
    },
    {
      "id": "21f6b104-1d0a-42f7-8f39-55a64b2043af",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2576,
        928
      ],
      "parameters": {
        "width": 1280,
        "height": 1296,
        "content": "## Step 3: Price Extraction\nAI extracts the real selling price and offer details."
      }
    },
    {
      "id": "805a1087-af4a-4519-bac8-d737e5f17a08",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3872,
        928
      ],
      "parameters": {
        "width": 960,
        "height": 1296,
        "content": "## Step 4: Analysis\nCompare current vs historical data to detect changes."
      }
    },
    {
      "id": "25ae4fa0-7f57-4849-b772-8c815854284a",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4848,
        928
      ],
      "parameters": {
        "width": 416,
        "height": 1296,
        "content": "## Step 5: Reporting\nGenerate and email the market intelligence report."
      }
    },
    {
      "id": "3e8c9189-159f-485d-a051-3edf61a03046",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5280,
        928
      ],
      "parameters": {
        "width": 480,
        "height": 1296,
        "content": "## Step 6: Reset\nMove current data to history and clear fields for next run."
      }
    },
    {
      "id": "6c01d6ea-a9df-4759-b42b-8b110087d40c",
      "name": "HTTP Request3",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2176,
        1440
      ]
    },
    {
      "id": "51e838b8-c30b-4949-85eb-fc7e20407ac9",
      "name": "If2",
      "type": "n8n-nodes-base.if",
      "position": [
        3200,
        1584
      ]
    },
    {
      "id": "296eec2a-d082-44c9-9af8-984d441d4041",
      "name": "Edit Fields1",
      "type": "n8n-nodes-base.set",
      "position": [
        4912,
        1216
      ]
    }
  ],
  "connections": {
    "If1": {
      "main": [
        [
          {
            "node": "Updated current price and offer in sheet",
            "type": "main",
            "index": 0
          },
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "If No changes then update",
            "type": "main",
            "index": 0
          },
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If2": {
      "main": [
        [
          {
            "node": "First time price and offer added",
            "type": "main",
            "index": 0
          },
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "If1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent": {
      "main": [
        [
          {
            "node": "Update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent1": {
      "main": [
        [
          {
            "node": "current Price and offer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields1": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Clean Content": {
      "main": [
        [
          {
            "node": "AI Agent1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request3": {
      "main": [
        [
          {
            "node": "Clean Content",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Simple Memory": {
      "ai_memory": [
        [
          {
            "node": "AI Agent",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "Send a message": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Data Aggregator": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Groq Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "HTTP Request3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Groq Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update row in sheet": {
      "main": [
        [
          {
            "node": "Edit Fields1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet1": {
      "main": [
        [
          {
            "node": "Data Aggregator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet2": {
      "main": [
        [
          {
            "node": "Update row in sheet1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "current Price and offer": {
      "main": [
        [
          {
            "node": "If2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}