{
  "name": "Airline web check-in data extraction with Ollama AI, Google Sheets & Postgres Vector DB",
  "nodes": [
    {
      "id": "ee7a49bf-a2dc-4d12-aef0-9add291a398c",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -220,
        175
      ]
    },
    {
      "id": "049cfbd5-bbc7-483c-964e-a32cdab1e6b8",
      "name": "Fetch Airline URLs\t",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -440,
        175
      ]
    },
    {
      "id": "7e2ca713-229f-490c-bd2e-481cf8f18184",
      "name": "Chat Trigger - Start\t",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        -660,
        175
      ]
    },
    {
      "id": "c11c66ea-3e36-4c12-a263-109d03d8be1a",
      "name": "Scrape Airline Webpage\t",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        0,
        0
      ]
    },
    {
      "id": "27072e20-58dc-49e2-ae6b-1053750607f9",
      "name": "Extract Info with LLM\t",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        220,
        0
      ]
    },
    {
      "id": "ba090b45-e6e8-434a-9577-51d281dd4a5b",
      "name": "Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOllama",
      "position": [
        308,
        220
      ]
    },
    {
      "id": "d557adab-856e-460e-aa81-f929a66ca465",
      "name": "Wait for Response",
      "type": "n8n-nodes-base.wait",
      "position": [
        580,
        0
      ]
    },
    {
      "id": "279b24fc-e1f3-4a1c-9c70-0177b13f32d8",
      "name": "Store Extracted Info\t",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        816,
        0
      ]
    },
    {
      "id": "866e9eca-68ad-419e-acf0-c28141bf7727",
      "name": "Generate Embeddings\t",
      "type": "@n8n/n8n-nodes-langchain.embeddingsOllama",
      "position": [
        1036,
        220
      ]
    },
    {
      "id": "56553cae-a61f-4b64-8709-06dbab314bce",
      "name": "Prepare Text for Vector DB\t",
      "type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
      "position": [
        1156,
        222.5
      ]
    },
    {
      "id": "82da65d6-9ecd-451a-b2f8-466795cd07a0",
      "name": "Split Long Text\t",
      "type": "@n8n/n8n-nodes-langchain.textSplitterTokenSplitter",
      "position": [
        1244,
        420
      ]
    },
    {
      "id": "a670a7c1-af95-452d-92e5-a82d5be2d0a5",
      "name": "Save to Vector DB\t",
      "type": "@n8n/n8n-nodes-langchain.vectorStorePGVector",
      "position": [
        1052,
        0
      ]
    },
    {
      "id": "7c4941f0-4dff-49d0-ac9b-901a23987686",
      "name": "Wait Before Next Batch\t",
      "type": "n8n-nodes-base.wait",
      "position": [
        1532,
        175
      ]
    },
    {
      "id": "0fef87ce-bfc3-4edd-aff8-8e10a0e7489a",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -740,
        -860
      ],
      "parameters": {
        "width": 660,
        "height": 860,
        "content": "\n\n### 📝 Web Check-in Details Extractor (LLM Prompt Guide)\n\n#### ✅ What is this?\n\nThis is a powerful AI prompt used inside the **\"Basic LLM Chain\"** node. It tells the AI how to **extract structured ai"
      }
    }
  ],
  "connections": {
    "Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Extract Info with LLM\t",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Scrape Airline Webpage\t",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Long Text\t": {
      "ai_textSplitter": [
        [
          {
            "node": "Prepare Text for Vector DB\t",
            "type": "ai_textSplitter",
            "index": 0
          }
        ]
      ]
    },
    "Wait for Response": {
      "main": [
        [
          {
            "node": "Store Extracted Info\t",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Save to Vector DB\t": {
      "main": [
        [
          {
            "node": "Wait Before Next Batch\t",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Airline URLs\t": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Embeddings\t": {
      "ai_embedding": [
        [
          {
            "node": "Save to Vector DB\t",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "Chat Trigger - Start\t": {
      "main": [
        [
          {
            "node": "Fetch Airline URLs\t",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Store Extracted Info\t": {
      "main": [
        [
          {
            "node": "Save to Vector DB\t",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Info with LLM\t": {
      "main": [
        [
          {
            "node": "Wait for Response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Scrape Airline Webpage\t": {
      "main": [
        [
          {
            "node": "Extract Info with LLM\t",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait Before Next Batch\t": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Text for Vector DB\t": {
      "ai_document": [
        [
          {
            "node": "Save to Vector DB\t",
            "type": "ai_document",
            "index": 0
          }
        ]
      ]
    }
  }
}