{
  "name": "Job post to sales lead pipeline with Scrape.do, Apollo.io & OpenAI",
  "nodes": [
    {
      "id": "723a8fe4-824f-4a45-932b-3b31e246d34b",
      "name": "🎯 Input Options",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -112,
        496
      ],
      "parameters": {
        "width": 392,
        "height": 464,
        "content": "## How it works\nThis workflow automates the lead sourcing process by scraping job listings from Indeed using Scrape.do. It enriches company data and finds decision-makers (e.g., CTOs, Founders) via Ap"
      }
    },
    {
      "id": "5c1491b4-1896-4c1d-9afd-dda5caf9d4fe",
      "name": "🔍 Scrape.do Details",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        528,
        432
      ],
      "parameters": {
        "width": 1096,
        "height": 576,
        "content": "## 1. Job Scraping\nAccepts search criteria via Form or Manual trigger, fetches job postings from Indeed via Scrape.do, and parses the markdown output."
      }
    },
    {
      "id": "d6064e7b-e510-4cad-83c9-77d90f9e151f",
      "name": "🏢 Apollo Org Search",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1776,
        432
      ],
      "parameters": {
        "width": 1176,
        "height": 576,
        "content": "## 2. Data Enrichment\nLogs companies to Sheets to avoid duplicates, then uses Apollo.io to fetch detailed organization data and find key decision-makers."
      }
    },
    {
      "id": "ddbf64fe-aff4-47a2-8771-f1eb2055f899",
      "name": "👥 Apollo People",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3008,
        432
      ],
      "parameters": {
        "width": 1128,
        "height": 576,
        "content": "## 3. Personalization & Output\nFormats the lead data, uses OpenAI to write a custom LinkedIn connection message based on the job context, and saves the final lead list to Google Sheets."
      }
    },
    {
      "id": "ae5cd22b-868d-4ac1-9044-0eaff387b494",
      "name": "🔧 Troubleshooting",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4192,
        736
      ],
      "parameters": {
        "width": 424,
        "height": 256,
        "content": "# 🔧 Troubleshooting\n\n- **Apollo error:** companyName may be empty\n- **No credentials:** Select credential in node\n- **Empty results:** Check Scrape.do output\n- **Rate limit:** Add Wait node\n\n✅ Test ea"
      }
    },
    {
      "id": "28901e2c-cd7e-4adc-a7e0-9301c95fe370",
      "name": "Form Trigger (Optional)",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        560,
        832
      ]
    },
    {
      "id": "87345ccf-303c-46fb-a1b4-b71861163ab7",
      "name": "Set Search Parameters",
      "type": "n8n-nodes-base.set",
      "position": [
        864,
        784
      ]
    },
    {
      "id": "091e1c17-98ab-406c-af3d-a887b77c92f2",
      "name": "Scrape.do Indeed API",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1152,
        784
      ]
    },
    {
      "id": "5261333a-c6fd-4c99-8f7d-a58ec8b75b8e",
      "name": "Parse Indeed Jobs",
      "type": "n8n-nodes-base.code",
      "position": [
        1504,
        784
      ]
    },
    {
      "id": "9c7f51f0-55f2-41b2-9e24-1422422f2ca2",
      "name": "Add New Company",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1824,
        784
      ]
    },
    {
      "id": "27a365b9-0ef9-475e-9c10-eb9edebe19b3",
      "name": "Apollo Organization Search",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2160,
        784
      ]
    },
    {
      "id": "e8e1e95a-d11d-4591-933d-8c16467225c4",
      "name": "Extract Apollo Org Data",
      "type": "n8n-nodes-base.code",
      "position": [
        2528,
        784
      ]
    },
    {
      "id": "2a98ba5c-f9a5-41a2-bc04-d42e6035dd35",
      "name": "Apollo People Search",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2832,
        784
      ]
    },
    {
      "id": "74407d73-6082-4708-9e66-3f7b41219e1f",
      "name": "Format Leads",
      "type": "n8n-nodes-base.code",
      "position": [
        3072,
        784
      ]
    },
    {
      "id": "4b069297-0707-436d-9fbb-725e2b8e8c49",
      "name": "Generate Personalized Message",
      "type": "n8n-nodes-base.openAi",
      "position": [
        3408,
        784
      ]
    },
    {
      "id": "01e00970-f643-4ffb-b9d4-18bd4b83a961",
      "name": "Merge Lead + Message",
      "type": "n8n-nodes-base.code",
      "position": [
        3712,
        784
      ]
    },
    {
      "id": "0428310e-637c-430d-bb0d-f33e0293b0c7",
      "name": "Save Leads to Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3936,
        784
      ]
    },
    {
      "id": "ed5a727c-d38e-4f58-bfeb-dcbe6134cdda",
      "name": "Manual Trigger",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        560,
        624
      ]
    }
  ],
  "connections": {
    "Format Leads": {
      "main": [
        [
          {
            "node": "Generate Personalized Message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Manual Trigger": {
      "main": [
        [
          {
            "node": "Set Search Parameters",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add New Company": {
      "main": [
        [
          {
            "node": "Apollo Organization Search",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse Indeed Jobs": {
      "main": [
        [
          {
            "node": "Add New Company",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Apollo People Search": {
      "main": [
        [
          {
            "node": "Format Leads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge Lead + Message": {
      "main": [
        [
          {
            "node": "Save Leads to Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Scrape.do Indeed API": {
      "main": [
        [
          {
            "node": "Parse Indeed Jobs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Search Parameters": {
      "main": [
        [
          {
            "node": "Scrape.do Indeed API",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Apollo Org Data": {
      "main": [
        [
          {
            "node": "Apollo People Search",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Form Trigger (Optional)": {
      "main": [
        [
          {
            "node": "Set Search Parameters",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Apollo Organization Search": {
      "main": [
        [
          {
            "node": "Extract Apollo Org Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Personalized Message": {
      "main": [
        [
          {
            "node": "Merge Lead + Message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}