{
  "name": "Upwork lead generation: Extract client emails with LinkedIn scraping and AI",
  "nodes": [
    {
      "id": "aa72ce26-28ae-4dab-982f-be16fa123d87",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        420,
        360
      ]
    },
    {
      "id": "94fba561-bc7e-4180-9b5d-beb9482b28b6",
      "name": "Run Every X Hours",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        140
      ]
    },
    {
      "id": "603403fa-6f4b-4124-90ee-f852954e67a4",
      "name": "Fetch Latest Upwork Jobs (Apify)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        220,
        140
      ]
    },
    {
      "id": "0ed2ab83-1fcb-459c-aa6d-ef81c8414b45",
      "name": "Extract Company or Person Name from Job",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        440,
        140
      ]
    },
    {
      "id": "ccd6cf3c-2666-45eb-8dc3-6575180c897b",
      "name": "Name is Found?",
      "type": "n8n-nodes-base.if",
      "position": [
        800,
        140
      ]
    },
    {
      "id": "c9721e93-707d-45c1-a06b-68606157f995",
      "name": "No Name Found - End Early",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1240,
        320
      ]
    },
    {
      "id": "4164b6e9-9ba7-4fc6-a1b6-c976f626aea5",
      "name": "Is It a Person or Company?",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1180,
        40
      ]
    },
    {
      "id": "93c7b341-6257-4ee2-a54f-ecbfcdf0f89b",
      "name": "Person or Company?",
      "type": "n8n-nodes-base.if",
      "position": [
        1540,
        40
      ]
    },
    {
      "id": "7dcacf79-eb65-454c-97fd-16ea6aed2f94",
      "name": "Search LinkedIn for Company (Phantombuster)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1960,
        -120
      ]
    },
    {
      "id": "e2f7db77-373e-462a-bc57-57653e067e30",
      "name": "Scrape LinkedIn Company Profile",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2180,
        -120
      ]
    },
    {
      "id": "14d7f669-dbc1-484e-b3c0-3d1e83d4c74f",
      "name": "Find Company Email (Hunter.io)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2400,
        -120
      ]
    },
    {
      "id": "4fd05ce5-495e-4d3a-8998-3120c3456e57",
      "name": "Search LinkedIn for Person (Phantombuster)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1960,
        1280
      ]
    },
    {
      "id": "f048e198-cc4b-4739-be7d-d3d885c6d2bb",
      "name": "Scrape LinkedIn Person Profile",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2180,
        1280
      ]
    },
    {
      "id": "dbc8c317-b469-4125-b939-614524a0339b",
      "name": "Find Personal Email (Hunter.io)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2400,
        1280
      ]
    },
    {
      "id": "047146a8-2b02-4098-a0e9-f8366c42aa4f",
      "name": "Store Results in Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2760,
        20
      ]
    },
    {
      "id": "1e9dee68-e0c2-4588-b6ca-666534d14dd4",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1820,
        -2200
      ],
      "parameters": {
        "width": 1300,
        "height": 320,
        "content": "=======================================\n            WORKFLOW ASSISTANCE\n=======================================\nFor any questions or support, please contact:\n    Yaron@nofluff.online\n\nExplore more tip"
      }
    },
    {
      "id": "2085a7ca-f68b-490a-9dcb-3c96fc6a739d",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1820,
        -1860
      ],
      "parameters": {
        "width": 1289,
        "height": 5558,
        "content": "# 🚀 **Automated Upwork Lead Enrichment Workflow**\n\n> ✨ *Fetch potential clients from Upwork, extract their info using AI, search them on LinkedIn, gather emails, and store all in Google Sheets* ✨\n\n---"
      }
    },
    {
      "id": "5bda85dd-7559-4239-9b38-c887a39dbb54",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -60,
        -2180
      ],
      "parameters": {
        "width": 1800,
        "height": 2680,
        "content": "## 🧩 **1. Trigger & Data Collection**\n\n---\n\n### ⏰ `Trigger - Run Every X Hours`\n\n**🔧 Node Type**: Schedule Trigger\n**🧠 Purpose**:\nThis node starts your automation periodically. You define how often it"
      }
    },
    {
      "id": "aa30a465-97e4-449f-a0b4-07a97a0f3d2c",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1880,
        -1300
      ],
      "parameters": {
        "width": 700,
        "height": 1420,
        "content": "## 🏢 **4A. Company Path**\n\n---\n\n### 🔍 `Search LinkedIn for Company (Phantombuster)`\n\n**🔧 Node Type**: HTTP Request\n**📡 Purpose**:\nUses [Phantombuster’s LinkedIn Search API](https://phantombuster.com/)"
      }
    },
    {
      "id": "7d7ec4da-d52c-4563-94df-3dcf88c85ff0",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1900,
        160
      ],
      "parameters": {
        "width": 640,
        "height": 1300,
        "content": "## 👤 **4B. Person Path**\n\n---\n\n### 🔍 `Search LinkedIn for Person (Phantombuster)`\n\n**🔧 Node Type**: HTTP Request\n**📡 Purpose**:\nSearches for the extracted **person’s name** like \"John Smith\" using Pha"
      }
    },
    {
      "id": "46f24197-38da-43a1-ba03-1e394169340a",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2680,
        -520
      ],
      "parameters": {
        "width": 260,
        "height": 720,
        "content": "## 📑 **5. Store Everything in Google Sheets**\n\n---\n\n### 🧾 `Store Results in Google Sheet`\n\n**🔧 Node Type**: Google Sheets (Append Row)\n**🧠 Purpose**:\nSaves:\n\n* Job title\n* Description\n* Client Name\n* "
      }
    }
  ],
  "connections": {
    "Name is Found?": {
      "main": [
        [
          {
            "node": "Is It a Person or Company?",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "No Name Found - End Early",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Extract Company or Person Name from Job",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "Is It a Person or Company?",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Run Every X Hours": {
      "main": [
        [
          {
            "node": "Fetch Latest Upwork Jobs (Apify)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Person or Company?": {
      "main": [
        [
          {
            "node": "Search LinkedIn for Company (Phantombuster)",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Search LinkedIn for Person (Phantombuster)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Is It a Person or Company?": {
      "main": [
        [
          {
            "node": "Person or Company?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Find Company Email (Hunter.io)": {
      "main": [
        [
          {
            "node": "Store Results in Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Scrape LinkedIn Person Profile": {
      "main": [
        [
          {
            "node": "Find Personal Email (Hunter.io)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Find Personal Email (Hunter.io)": {
      "main": [
        [
          {
            "node": "Store Results in Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Scrape LinkedIn Company Profile": {
      "main": [
        [
          {
            "node": "Find Company Email (Hunter.io)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Latest Upwork Jobs (Apify)": {
      "main": [
        [
          {
            "node": "Extract Company or Person Name from Job",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Company or Person Name from Job": {
      "main": [
        [
          {
            "node": "Name is Found?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Search LinkedIn for Person (Phantombuster)": {
      "main": [
        [
          {
            "node": "Scrape LinkedIn Person Profile",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Search LinkedIn for Company (Phantombuster)": {
      "main": [
        [
          {
            "node": "Scrape LinkedIn Company Profile",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}