{
  "name": "Automated job extraction & publishing with RAG, Jina AI and OpenAI to WordPress",
  "nodes": [
    {
      "id": "9db5c8cc-2c9a-4256-94b9-b404fcfed9b8",
      "name": "Search File",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -592,
        -464
      ]
    },
    {
      "id": "a011a33b-a34c-490a-a541-fa44a6d210ad",
      "name": "Get Data",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -368,
        -464
      ]
    },
    {
      "id": "e9ccaf88-ef3d-4e0d-b341-20674e225c26",
      "name": "Supabase Vector Store",
      "type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase",
      "position": [
        96,
        -464
      ]
    },
    {
      "id": "f96b0b9c-ea89-4265-a8b9-7cf7d5b8718c",
      "name": "Embeddings OpenAI",
      "type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
      "position": [
        80,
        -240
      ]
    },
    {
      "id": "9fac2f4e-8fe6-408b-b2d1-4de537a51654",
      "name": "Default Data Loader",
      "type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
      "position": [
        208,
        -240
      ]
    },
    {
      "id": "01ed8e12-4569-4982-b4b2-86c48c607862",
      "name": "Recursive Character Text Splitter",
      "type": "@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter",
      "position": [
        304,
        -32
      ]
    },
    {
      "id": "5f82a988-cf41-4494-a6ec-ff69b880e940",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -144,
        -464
      ]
    },
    {
      "id": "29b8633d-5190-48c7-a2e1-b09eb1a74585",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -3472,
        -272
      ]
    },
    {
      "id": "8fd148f9-604e-471b-b65f-4632b1b484c9",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -3440,
        -48
      ]
    },
    {
      "id": "11daf090-c929-4ed5-a4dc-267d0c402e1e",
      "name": "Supabase Vector Store1",
      "type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase",
      "position": [
        -1216,
        448
      ]
    },
    {
      "id": "6f32182f-8acc-4468-a993-f2ba0a31f2d8",
      "name": "Embeddings OpenAI1",
      "type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
      "position": [
        -1120,
        656
      ]
    },
    {
      "id": "2bf347a0-d2db-4b3f-b339-f82dc00245a2",
      "name": "Google Drive Trigger",
      "type": "n8n-nodes-base.googleDriveTrigger",
      "position": [
        -816,
        -464
      ]
    },
    {
      "id": "11c1c54b-6bad-4ef7-8703-7c80dc60099d",
      "name": "📥 New Job Link via Telegram",
      "type": "n8n-nodes-base.telegramTrigger",
      "position": [
        -3456,
        496
      ]
    },
    {
      "id": "b8fc0c2c-93ec-4b62-b0da-0948c3dc9661",
      "name": "🔧 Prepare URL for Extraction",
      "type": "n8n-nodes-base.set",
      "position": [
        -3232,
        496
      ]
    },
    {
      "id": "964df60e-eeeb-4c60-b4fc-dca6f083ea0d",
      "name": "🧮 Map Job Type & Category IDs",
      "type": "n8n-nodes-base.code",
      "position": [
        -816,
        176
      ]
    },
    {
      "id": "9c03e317-3ac7-4a5c-9612-02b99746a725",
      "name": "📥 Download Company Logo",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -144,
        176
      ]
    },
    {
      "id": "609b0e95-43f2-45c2-b5a1-29636581446d",
      "name": "☁️ Upload Logo to WordPress",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        80,
        176
      ]
    },
    {
      "id": "51e02ad8-611e-4738-a92b-8fbde4fe9c90",
      "name": "📦 Format Final Job Post Data",
      "type": "n8n-nodes-base.set",
      "position": [
        304,
        176
      ]
    },
    {
      "id": "591abeb6-03fd-453c-9001-aaae56976d16",
      "name": "✅ All Fields Available?",
      "type": "n8n-nodes-base.if",
      "position": [
        528,
        160
      ]
    },
    {
      "id": "3f58a822-4aa3-411b-9e5b-ad63be12a940",
      "name": "if not valid",
      "type": "n8n-nodes-base.telegram",
      "position": [
        752,
        -144
      ]
    },
    {
      "id": "771818fd-47d1-48ab-a83a-7bc232a52ab5",
      "name": "notify: processing job",
      "type": "n8n-nodes-base.telegram",
      "position": [
        -2560,
        400
      ]
    },
    {
      "id": "5c78034b-8194-4d3b-bf81-1f524f7dcea5",
      "name": "notify: extracting",
      "type": "n8n-nodes-base.telegram",
      "position": [
        -2112,
        400
      ]
    },
    {
      "id": "eac3a8c7-bab1-44ad-b199-4c11b563033c",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        -1664,
        320
      ]
    },
    {
      "id": "9b3c64ac-49ee-4b97-8137-4b87e1a6e902",
      "name": "notify: success extract",
      "type": "n8n-nodes-base.telegram",
      "position": [
        -1440,
        224
      ]
    },
    {
      "id": "ad03815f-6870-49da-89b9-4bfd84fe74e8",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -864,
        -512
      ],
      "parameters": {
        "width": 1400,
        "height": 620,
        "content": "## RAG DATA\n**Double click** to edit me. [Guide](https://docs.n8n.io/workflows/sticky-notes/)"
      }
    },
    {
      "id": "1378e1e2-6f80-4d75-9694-5906e9df1942",
      "name": "📚 Load Valid Job Types & Categories",
      "type": "n8n-nodes-base.set",
      "position": [
        -3008,
        496
      ]
    },
    {
      "id": "fe3fedf2-e2a4-49a7-907a-ecf8d5eb4240",
      "name": "notify: error",
      "type": "n8n-nodes-base.telegram",
      "position": [
        -816,
        528
      ]
    },
    {
      "id": "fdcf1297-9022-48d5-bcd1-c3a2059b60a6",
      "name": "Wait",
      "type": "n8n-nodes-base.wait",
      "position": [
        -2336,
        400
      ]
    },
    {
      "id": "f6853ad4-dce9-4577-aa1c-3a900cac6c1e",
      "name": "valid url?",
      "type": "n8n-nodes-base.if",
      "position": [
        -2784,
        496
      ]
    },
    {
      "id": "9b25199a-31f8-4225-85ef-c122daa1fa2e",
      "name": "notify: wrong url",
      "type": "n8n-nodes-base.telegram",
      "position": [
        -2560,
        592
      ]
    },
    {
      "id": "f7ea2c35-ec76-4d71-a412-99359c8e151a",
      "name": "🧠 Extract Job Data with GPT",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -1216,
        224
      ]
    },
    {
      "id": "b92d849d-80be-42a2-aff9-3b2681f9ddbf",
      "name": "Postgres Chat Memory",
      "type": "@n8n/n8n-nodes-langchain.memoryPostgresChat",
      "position": [
        -3312,
        -48
      ]
    },
    {
      "id": "55a3e64e-d45a-4c21-8c74-bfcfaf7a07a4",
      "name": "Extract",
      "type": "n8n-nodes-base.jinaAi",
      "position": [
        -1888,
        400
      ]
    },
    {
      "id": "3fbf0e5a-176a-4cfe-86a1-64d16e31d09f",
      "name": "Create Url",
      "type": "n8n-nodes-base.code",
      "position": [
        -368,
        176
      ]
    },
    {
      "id": "91f978ad-7ca1-4637-b0fe-38df1f7aa549",
      "name": "notify: openai success",
      "type": "n8n-nodes-base.telegram",
      "position": [
        -592,
        176
      ]
    },
    {
      "id": "37945719-b7e1-4ae6-89d2-d5fc39f500f3",
      "name": "Edit Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        752,
        576
      ]
    },
    {
      "id": "486d3276-9a3e-4a78-8ee8-ea56cc2da643",
      "name": "📥 Download Company Logo - Alt",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        976,
        576
      ]
    },
    {
      "id": "7bbac7a6-8800-42c7-a72d-576f8df60aeb",
      "name": "☁️ Upload Logo to WordPress - Alt",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1200,
        576
      ]
    },
    {
      "id": "b8b9261a-0298-4548-bf93-e8d86a2b68fb",
      "name": "📦 Format Final Job Post Data - Alt",
      "type": "n8n-nodes-base.set",
      "position": [
        1424,
        576
      ]
    },
    {
      "id": "c2d5191b-f159-4430-9c19-93996038cbf8",
      "name": "✅ All Fields Available? - Alt",
      "type": "n8n-nodes-base.if",
      "position": [
        1648,
        560
      ]
    },
    {
      "id": "52dc5cda-9f9e-4762-a772-f6eda4009951",
      "name": "📊 Did Publish Succeed?1",
      "type": "n8n-nodes-base.if",
      "position": [
        2096,
        576
      ]
    },
    {
      "id": "734362fc-4cf0-4845-84d1-b82da537f549",
      "name": "📨 Notify Success - Alt",
      "type": "n8n-nodes-base.telegram",
      "position": [
        2320,
        576
      ]
    },
    {
      "id": "c1387f6c-95c1-47c2-92f6-535795f8a7d8",
      "name": "📨 Notify Failed - Alt",
      "type": "n8n-nodes-base.telegram",
      "position": [
        2320,
        768
      ]
    },
    {
      "id": "4c33212f-24f9-4761-98e9-2353861092df",
      "name": "📊 Did Publish Succeed?2",
      "type": "n8n-nodes-base.if",
      "position": [
        976,
        112
      ]
    },
    {
      "id": "f6621fcd-cd0c-437c-850e-5aec4aced243",
      "name": "notify: failed extract",
      "type": "n8n-nodes-base.telegram",
      "position": [
        -1440,
        432
      ]
    },
    {
      "id": "f157c006-e030-4022-af65-b31c622ffc84",
      "name": "Error",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1200,
        272
      ]
    },
    {
      "id": "6850d7c9-d6c3-4238-bfba-26f1a293a2eb",
      "name": "changing method",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1200,
        -144
      ]
    },
    {
      "id": "3d7a6168-1425-4761-83a0-217df65810c0",
      "name": "Wait1",
      "type": "n8n-nodes-base.wait",
      "position": [
        1424,
        -144
      ]
    },
    {
      "id": "27c05704-1592-4113-9164-3708cf95939a",
      "name": "Wait2",
      "type": "n8n-nodes-base.wait",
      "position": [
        976,
        -144
      ]
    },
    {
      "id": "5cd30671-f93e-4d97-83dd-50d2cc61013e",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3472,
        176
      ],
      "parameters": {
        "width": 660,
        "height": 260,
        "content": "## Monitoring - leave as it is"
      }
    },
    {
      "id": "d5f5cf7f-64df-4e26-a78b-69927c65d92e",
      "name": "Error Trigger",
      "type": "n8n-nodes-base.errorTrigger",
      "position": [
        -3408,
        272
      ]
    },
    {
      "id": "3706df36-ce1e-4b6a-9c08-ab6e767f9654",
      "name": "Kirim ke Telegram",
      "type": "n8n-nodes-base.telegram",
      "position": [
        -2960,
        272
      ]
    },
    {
      "id": "530ec964-11ab-43e1-8411-b26eabd7c845",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "position": [
        -3184,
        272
      ]
    },
    {
      "id": "340a435c-0f51-4136-a7d3-57a847bd490c",
      "name": "Publiched!",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1200,
        64
      ]
    },
    {
      "id": "80395252-aa0f-4f96-b49c-4c6a461fb2f4",
      "name": "🚀 Publish to Your web",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        752,
        112
      ]
    },
    {
      "id": "f7c7f5fe-fd08-43a5-a2d7-536d79ac2425",
      "name": "🚀 Publish to Yourweb - Alt",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1872,
        576
      ]
    },
    {
      "id": "3a79707a-fb2a-4ad4-9222-48887e67f5e1",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -832,
        -32
      ],
      "parameters": {
        "width": 370,
        "height": 100,
        "content": "## ☕ Appreciate This Workflow?\n\nSupport the creator by sending coffee:\n\n**PayPal:** [paypal.me/khmuhtadin](https://paypal.me/khmuhtadin)\n\nThank you! 🚀"
      }
    }
  ],
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "notify: success extract",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "notify: failed extract",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code": {
      "main": [
        [
          {
            "node": "Kirim ke Telegram",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait": {
      "main": [
        [
          {
            "node": "notify: extracting",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait2": {
      "main": [
        [
          {
            "node": "changing method",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "notify: error",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Data": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Url": {
      "main": [
        [
          {
            "node": "📥 Download Company Logo",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "valid url?": {
      "main": [
        [
          {
            "node": "notify: processing job",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "notify: wrong url",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "📥 Download Company Logo - Alt",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Search File": {
      "main": [
        [
          {
            "node": "Get Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "if not valid": {
      "main": [
        [
          {
            "node": "Wait2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Error Trigger": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Supabase Vector Store",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "changing method": {
      "main": [
        [
          {
            "node": "Wait1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Embeddings OpenAI": {
      "ai_embedding": [
        [
          {
            "node": "Supabase Vector Store",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Embeddings OpenAI1": {
      "ai_embedding": [
        [
          {
            "node": "Supabase Vector Store1",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "notify: extracting": {
      "main": [
        [
          {
            "node": "Extract",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Default Data Loader": {
      "ai_document": [
        [
          {
            "node": "Supabase Vector Store",
            "type": "ai_document",
            "index": 0
          }
        ]
      ]
    },
    "Google Drive Trigger": {
      "main": [
        [
          {
            "node": "Search File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Postgres Chat Memory": {
      "ai_memory": [
        [
          {
            "node": "AI Agent",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "Supabase Vector Store": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Supabase Vector Store1": {
      "ai_tool": [
        [
          {
            "node": "🧠 Extract Job Data with GPT",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "notify: openai success": {
      "main": [
        [
          {
            "node": "Create Url",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "notify: processing job": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "notify: success extract": {
      "main": [
        [
          {
            "node": "🧠 Extract Job Data with GPT",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🚀 Publish to Your web": {
      "main": [
        [
          {
            "node": "📊 Did Publish Succeed?2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "✅ All Fields Available?": {
      "main": [
        [
          {
            "node": "🚀 Publish to Your web",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "if not valid",
            "type": "main",
            "index": 0
          },
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Error",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📊 Did Publish Succeed?1": {
      "main": [
        [
          {
            "node": "📨 Notify Success - Alt",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "📨 Notify Failed - Alt",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📊 Did Publish Succeed?2": {
      "main": [
        [
          {
            "node": "Publiched!",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Error",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📥 Download Company Logo": {
      "main": [
        [
          {
            "node": "☁️ Upload Logo to WordPress",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🚀 Publish to Yourweb - Alt": {
      "main": [
        [
          {
            "node": "📊 Did Publish Succeed?1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📥 New Job Link via Telegram": {
      "main": [
        [
          {
            "node": "🔧 Prepare URL for Extraction",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🧠 Extract Job Data with GPT": {
      "main": [
        [
          {
            "node": "🧮 Map Job Type & Category IDs",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "notify: error",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "☁️ Upload Logo to WordPress": {
      "main": [
        [
          {
            "node": "📦 Format Final Job Post Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "✅ All Fields Available? - Alt": {
      "main": [
        [
          {
            "node": "🚀 Publish to Yourweb - Alt",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "📨 Notify Failed - Alt",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "📨 Notify Failed - Alt",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📦 Format Final Job Post Data": {
      "main": [
        [
          {
            "node": "✅ All Fields Available?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🔧 Prepare URL for Extraction": {
      "main": [
        [
          {
            "node": "📚 Load Valid Job Types & Categories",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📥 Download Company Logo - Alt": {
      "main": [
        [
          {
            "node": "☁️ Upload Logo to WordPress - Alt",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🧮 Map Job Type & Category IDs": {
      "main": [
        [
          {
            "node": "notify: openai success",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Recursive Character Text Splitter": {
      "ai_textSplitter": [
        [
          {
            "node": "Default Data Loader",
            "type": "ai_textSplitter",
            "index": 0
          }
        ]
      ]
    },
    "☁️ Upload Logo to WordPress - Alt": {
      "main": [
        [
          {
            "node": "📦 Format Final Job Post Data - Alt",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📦 Format Final Job Post Data - Alt": {
      "main": [
        [
          {
            "node": "✅ All Fields Available? - Alt",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📚 Load Valid Job Types & Categories": {
      "main": [
        [
          {
            "node": "valid url?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}