{
  "name": "Match students to scholarships with Claude AI, Airtable, and Google Sheets",
  "nodes": [
    {
      "id": "fd2b4029-1979-4e20-9d21-5bde07251b9d",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -368,
        -304
      ],
      "parameters": {
        "width": 960,
        "height": 1848,
        "content": "## Automated Scholarship Eligibility Matcher\n\nThis workflow ingests student profiles from a form submission or CRM, loads the active scholarship catalogue, uses Claude AI to score each student's eligi"
      }
    },
    {
      "id": "0bbac8b0-8bfc-4802-ba43-7683dc15b97e",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1024,
        416
      ],
      "parameters": {
        "width": 428,
        "height": 464,
        "content": "## 1. Intake & Data Loading\n### Student Profiles · Scholarship Catalogue"
      }
    },
    {
      "id": "de5ca0a7-a3fa-4ddc-8a0c-d9c057e85788",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1488,
        304
      ],
      "parameters": {
        "width": 396,
        "height": 592,
        "content": "## 2. Profile Normalisation & Scholarship Pairing\n### Data Cleaning · Criteria Extraction · Pair Builder"
      }
    },
    {
      "id": "55433aba-5389-4d44-914b-f613c91ec70e",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1926,
        424
      ],
      "parameters": {
        "width": 564,
        "height": 568,
        "content": "## 3. Claude AI Eligibility Scoring & Ranking"
      }
    },
    {
      "id": "a8c123f1-ff12-49b1-b2ca-134ee307d08f",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2528,
        320
      ],
      "parameters": {
        "width": 1148,
        "height": 716,
        "content": "## 4. Filtering · Personalised Notifications · CRM Update · Audit Log"
      }
    },
    {
      "id": "d04cac7e-596b-4da1-945c-8da92ade6e9f",
      "name": "Receive Student Profile Submission",
      "type": "n8n-nodes-base.webhook",
      "position": [
        1104,
        720
      ]
    },
    {
      "id": "9bb3a2bc-9e57-406b-b555-78a76675b6d7",
      "name": "Nightly Batch Schedule",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        1104,
        528
      ]
    },
    {
      "id": "a8ff9cd3-5a6f-4886-b83e-8752a6f9d32b",
      "name": "Load Student Profiles",
      "type": "n8n-nodes-base.airtable",
      "position": [
        1328,
        528
      ]
    },
    {
      "id": "73644939-369a-451a-8559-12f0cb881941",
      "name": "Load Scholarship Catalogue",
      "type": "n8n-nodes-base.airtable",
      "position": [
        1328,
        720
      ]
    },
    {
      "id": "ee8975c2-6bc9-453c-b44b-97b3a5787317",
      "name": "Normalise Profiles & Build Pairs",
      "type": "n8n-nodes-base.code",
      "position": [
        1552,
        624
      ]
    },
    {
      "id": "ab1f5be9-6c81-48c1-a992-9b036f5ce828",
      "name": "Pre-Filter Hard Ineligibility",
      "type": "n8n-nodes-base.code",
      "position": [
        1776,
        624
      ]
    },
    {
      "id": "97fed899-22cb-4a2a-b01c-0af8be176f15",
      "name": "AI Eligibility Scorer",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        2000,
        624
      ]
    },
    {
      "id": "bf374fba-c7eb-461b-97ab-bfe815768f07",
      "name": "Claude AI Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
      "position": [
        2072,
        848
      ]
    },
    {
      "id": "bcc5634b-6f4c-4f0d-a9e3-f55b69c7ffef",
      "name": "Parse & Rank Match Results",
      "type": "n8n-nodes-base.code",
      "position": [
        2352,
        624
      ]
    },
    {
      "id": "a1fa618d-05c2-45e2-9bb2-a65ddf6a089b",
      "name": "Filter Qualified Matches",
      "type": "n8n-nodes-base.filter",
      "position": [
        2576,
        624
      ]
    },
    {
      "id": "9761a356-a5b6-4434-9aee-097e51377535",
      "name": "Build Personalised Student Email",
      "type": "n8n-nodes-base.code",
      "position": [
        2800,
        624
      ]
    },
    {
      "id": "53e65a9a-33b2-438f-8368-49e8c7d37500",
      "name": "Send Scholarship Email to Student",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        3024,
        432
      ]
    },
    {
      "id": "cfc9871e-cc66-46d1-b67d-75b31479a397",
      "name": "Notify Academic Advisor on Slack",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        3024,
        624
      ]
    },
    {
      "id": "49594012-3fc9-4021-90d5-51eff246e015",
      "name": "Update Student CRM Record",
      "type": "n8n-nodes-base.airtable",
      "position": [
        3024,
        816
      ]
    },
    {
      "id": "3d38ac05-8006-4fdd-bd09-e8ed3c5de13d",
      "name": "Write Match Audit Log",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3248,
        624
      ]
    },
    {
      "id": "97634972-1920-41ca-ab63-d4a203a260ce",
      "name": "Return Match Results to Caller",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        3472,
        624
      ]
    }
  ],
  "connections": {
    "Claude AI Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Eligibility Scorer",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "AI Eligibility Scorer": {
      "main": [
        [
          {
            "node": "Parse & Rank Match Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Load Student Profiles": {
      "main": [
        [
          {
            "node": "Normalise Profiles & Build Pairs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Write Match Audit Log": {
      "main": [
        [
          {
            "node": "Return Match Results to Caller",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Nightly Batch Schedule": {
      "main": [
        [
          {
            "node": "Load Student Profiles",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Qualified Matches": {
      "main": [
        [
          {
            "node": "Build Personalised Student Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Student CRM Record": {
      "main": [
        [
          {
            "node": "Write Match Audit Log",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Load Scholarship Catalogue": {
      "main": [
        [
          {
            "node": "Normalise Profiles & Build Pairs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse & Rank Match Results": {
      "main": [
        [
          {
            "node": "Filter Qualified Matches",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Pre-Filter Hard Ineligibility": {
      "main": [
        [
          {
            "node": "AI Eligibility Scorer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Personalised Student Email": {
      "main": [
        [
          {
            "node": "Send Scholarship Email to Student",
            "type": "main",
            "index": 0
          },
          {
            "node": "Notify Academic Advisor on Slack",
            "type": "main",
            "index": 0
          },
          {
            "node": "Update Student CRM Record",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Normalise Profiles & Build Pairs": {
      "main": [
        [
          {
            "node": "Pre-Filter Hard Ineligibility",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Notify Academic Advisor on Slack": {
      "main": [
        [
          {
            "node": "Write Match Audit Log",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Scholarship Email to Student": {
      "main": [
        [
          {
            "node": "Write Match Audit Log",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Receive Student Profile Submission": {
      "main": [
        [
          {
            "node": "Load Scholarship Catalogue",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}