{
  "name": "Turn WhatsApp into an AI shopping and price comparison assistant using Wati, OpenAI, Serper, and Google Sheets",
  "nodes": [
    {
      "id": "ac1011ce-6d22-4dd7-89b1-4ed4e48fab02",
      "name": "🗺️ Architecture Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2800,
        2848
      ],
      "parameters": {
        "width": 680,
        "height": 788,
        "content": "## 🛒 Smart Shopping Assistant – WhatsApp Price Comparison Bot\n\n**3 independent pipelines — each does one job cleanly:**\n\n📥 **PIPELINE A · Intake**\nUser sends a list → OpenAI parses every item with qty"
      }
    },
    {
      "id": "aca804c2-dea9-4191-9aa3-74385356d50d",
      "name": "Pipeline A Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1840,
        4000
      ],
      "parameters": {
        "width": 444,
        "height": 760,
        "content": "Node: Wati Trigger1 & Intent Router1\nFunction: Captures incoming WhatsApp messages via Wati.Logic: The Switch node parses the {{ $json.text }} to determine what the user wants.\ncompare (Price check)\nd"
      }
    },
    {
      "id": "1f7a04e3-de69-44bc-9121-582d38630b56",
      "name": "Pipeline B Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1264,
        4048
      ],
      "parameters": {
        "width": 1972,
        "height": 480,
        "content": "### 🔍 Pipeline B · Price Engine\n**Flow per item:**\n`Read List for Compare` → `Prepare Search Queries.`Serper – Search Prices`.`OpenAI – Extract Best Deal`.`Process Deal Result`.`Google Sheets – Save D"
      }
    },
    {
      "id": "9ececa7a-15f6-45a6-9d1a-e9a5eea9ba0a",
      "name": "Pipeline C Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1104,
        4352
      ],
      "parameters": {
        "width": 1108,
        "height": 468,
        "content": "### 📬 Pipeline C · Daily Deal Alerts\nRuns automatically every day at 8:00 AM\n**Flow:**\nSchedule Trigger – Daily 8AM Alerts`.`Google Sheets – Read Deals for Alert`*(reads entire Deals tab)*.`Build Aler"
      }
    },
    {
      "id": "275698cd-4f25-4c48-84e1-7a231a53186d",
      "name": "Intent Router1",
      "type": "n8n-nodes-base.switch",
      "position": [
        -1616,
        4256
      ]
    },
    {
      "id": "601d3afa-c9a2-439e-b735-6daf0875c582",
      "name": "OpenAI – Parse List1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1184,
        3696
      ]
    },
    {
      "id": "8b36382e-cb67-458f-99cf-dbda4b432b69",
      "name": "Structure List Items1",
      "type": "n8n-nodes-base.code",
      "position": [
        -960,
        3696
      ]
    },
    {
      "id": "e439642e-23db-4956-95ee-a1018058bb7a",
      "name": "Google Sheets – Save Shopping List1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -752,
        3696
      ]
    },
    {
      "id": "6f312e5e-4cc3-4e8a-85c7-f442635645a2",
      "name": "Google Sheets – Read My List1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1168,
        4704
      ]
    },
    {
      "id": "0bad7b13-b2e6-4c18-8e76-d719c78b1ee9",
      "name": "Build My List View1",
      "type": "n8n-nodes-base.code",
      "position": [
        -912,
        4704
      ]
    },
    {
      "id": "9c6454b9-afda-4888-a666-130b2d9fbc3a",
      "name": "Google Sheets – Read Saved Deals1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1184,
        5104
      ]
    },
    {
      "id": "b1a21a36-3c98-467a-b991-c96146670369",
      "name": "Build Deals View1",
      "type": "n8n-nodes-base.code",
      "position": [
        -864,
        5104
      ]
    },
    {
      "id": "0da98dbc-8018-4c14-be6d-3091268a61be",
      "name": "Process Clear1",
      "type": "n8n-nodes-base.code",
      "position": [
        -1136,
        5504
      ]
    },
    {
      "id": "e7d9692b-f8bb-4eac-98c6-5edc140c3961",
      "name": "Google Sheets – Read List for Compare1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1200,
        4352
      ]
    },
    {
      "id": "9508c89f-bc70-43b3-b576-7832139fb32a",
      "name": "Prepare Search Queries1",
      "type": "n8n-nodes-base.code",
      "position": [
        -928,
        4352
      ]
    },
    {
      "id": "9648270c-dc21-4ed1-9478-2d917ed38297",
      "name": "Serper – Search Prices1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -688,
        4352
      ]
    },
    {
      "id": "169321ed-6956-4fb7-8519-038878488530",
      "name": "OpenAI – Extract Best Deal1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -464,
        4352
      ]
    },
    {
      "id": "af99be87-074e-45e2-a491-b0bb268e0478",
      "name": "Process Deal Result1",
      "type": "n8n-nodes-base.code",
      "position": [
        -240,
        4352
      ]
    },
    {
      "id": "c2e8e927-2812-45e5-a71d-40b934f38b84",
      "name": "Google Sheets – Save Deals1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        16,
        4352
      ]
    },
    {
      "id": "580a8a1e-2d20-4b59-8d66-26fa883c3251",
      "name": "Aggregate Comparison Card1",
      "type": "n8n-nodes-base.code",
      "position": [
        256,
        4352
      ]
    },
    {
      "id": "fa355182-765f-4690-8290-fcce9a7f4750",
      "name": "Schedule Trigger – Daily 8AM Alerts1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        1280,
        4672
      ]
    },
    {
      "id": "0b0341cf-7ad4-4cbf-88fa-ecc9095bddde",
      "name": "Google Sheets – Read Deals for Alert1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1520,
        4672
      ]
    },
    {
      "id": "10b9c976-1234-4533-aad3-e7f959280019",
      "name": "Build Alert Messages1",
      "type": "n8n-nodes-base.code",
      "position": [
        1760,
        4672
      ]
    },
    {
      "id": "9698ad3b-7ab1-4675-8665-b6cc8fb755cf",
      "name": "Send a text message5",
      "type": "n8n-nodes-wati.wati",
      "position": [
        -528,
        3696
      ]
    },
    {
      "id": "8c745c6c-06f2-41ac-8362-bd7b444947e2",
      "name": "Send a text message6",
      "type": "n8n-nodes-wati.wati",
      "position": [
        464,
        4352
      ]
    },
    {
      "id": "b55e03ed-b5bb-4aa2-88b9-3305323a86e3",
      "name": "Send a text message7",
      "type": "n8n-nodes-wati.wati",
      "position": [
        -656,
        4704
      ]
    },
    {
      "id": "bba952b7-599a-478c-8f1e-b47f3f6f0541",
      "name": "Send a text message8",
      "type": "n8n-nodes-wati.wati",
      "position": [
        -576,
        5104
      ]
    },
    {
      "id": "e5422e68-f0a6-4a59-affb-b50814add91c",
      "name": "Send a text message9",
      "type": "n8n-nodes-wati.wati",
      "position": [
        -832,
        5504
      ]
    },
    {
      "id": "5eb4b0e0-5bf2-46e7-b64e-8d764b6b3dd2",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1248,
        3552
      ],
      "parameters": {
        "width": 1136,
        "height": 384,
        "content": "**New List path:**\n`OpenAI – Parse List` → `Structure List Items` (generates one row per item + ackMessage) → `Google Sheets – Save Shopping List` → `Send a text message` (confirm to user)"
      }
    },
    {
      "id": "0216abdb-cd4d-4b44-8b3c-e9b6047c0296",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1264,
        5376
      ],
      "parameters": {
        "width": 1040,
        "height": 272,
        "content": "\nSticky Note Title: 🧹 MAINTENANCE\nFunction: Handles the \"Clear\" intent.\nNote: This node currently prepares the \"Success\" message.\nTip: Ensure you have a Google Sheets node following this (or a specifi"
      }
    },
    {
      "id": "bb3d20d1-6036-47d5-9fcb-031850a92415",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1280,
        4992
      ],
      "parameters": {
        "width": 1056,
        "height": 320,
        "content": "Sticky Note Title: 💰 SAVINGS TRACKER\nFunction: Fetches the latest price data from the Deals sheet. Key Features:* Sorts by date to show the most recent prices first.De-duplicates items so the user onl"
      }
    },
    {
      "id": "7368a5fa-05c3-4b23-b627-8b68aa4468cd",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1264,
        4576
      ],
      "parameters": {
        "width": 928,
        "height": 320,
        "content": "Nodes: Google Sheets – Read My List1 & Build My List View1\n\nFunction: Pulls active shopping items from the ShoppingList sheet.Groups items by Category (Dairy, Produce, etc.).Adds specific emojis based"
      }
    },
    {
      "id": "00eea83e-1f55-40cd-8202-90793c3efa32",
      "name": "Wati Trigger",
      "type": "n8n-nodes-wati.watiTrigger",
      "position": [
        -1824,
        4320
      ]
    },
    {
      "id": "38f7f040-5864-4d76-b050-bb5325bdca4e",
      "name": "Send a text message",
      "type": "n8n-nodes-wati.wati",
      "position": [
        2048,
        4672
      ]
    }
  ],
  "connections": {
    "Wati Trigger": {
      "main": [
        [
          {
            "node": "Intent Router1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Intent Router1": {
      "main": [
        [
          {
            "node": "OpenAI – Parse List1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Google Sheets – Read List for Compare1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Google Sheets – Read Saved Deals1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Google Sheets – Read My List1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Process Clear1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process Clear1": {
      "main": [
        [
          {
            "node": "Send a text message9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Deals View1": {
      "main": [
        [
          {
            "node": "Send a text message8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build My List View1": {
      "main": [
        [
          {
            "node": "Send a text message7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process Deal Result1": {
      "main": [
        [
          {
            "node": "Google Sheets – Save Deals1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Alert Messages1": {
      "main": [
        [
          {
            "node": "Send a text message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structure List Items1": {
      "main": [
        [
          {
            "node": "Google Sheets – Save Shopping List1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI – Parse List1": {
      "main": [
        [
          {
            "node": "Structure List Items1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Search Queries1": {
      "main": [
        [
          {
            "node": "Serper – Search Prices1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Serper – Search Prices1": {
      "main": [
        [
          {
            "node": "OpenAI – Extract Best Deal1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate Comparison Card1": {
      "main": [
        [
          {
            "node": "Send a text message6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets – Save Deals1": {
      "main": [
        [
          {
            "node": "Aggregate Comparison Card1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI – Extract Best Deal1": {
      "main": [
        [
          {
            "node": "Process Deal Result1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets – Read My List1": {
      "main": [
        [
          {
            "node": "Build My List View1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets – Read Saved Deals1": {
      "main": [
        [
          {
            "node": "Build Deals View1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets – Save Shopping List1": {
      "main": [
        [
          {
            "node": "Send a text message5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger – Daily 8AM Alerts1": {
      "main": [
        [
          {
            "node": "Google Sheets – Read Deals for Alert1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets – Read Deals for Alert1": {
      "main": [
        [
          {
            "node": "Build Alert Messages1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets – Read List for Compare1": {
      "main": [
        [
          {
            "node": "Prepare Search Queries1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}