{
  "name": "Event Sponsor Matching with Google Sheets, GPT & Gmail",
  "nodes": [
    {
      "id": "6eb9a11e-7e74-41e1-8d0f-0edaf2d9037d",
      "name": "Set Workflow Variables",
      "type": "n8n-nodes-base.set",
      "position": [
        -18224,
        2672
      ]
    },
    {
      "id": "8f06ecd8-3a1c-4202-810f-21bf3e6d0bea",
      "name": "Fetch Sponsors Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -17888,
        2592
      ]
    },
    {
      "id": "18785402-bec0-4dcb-9d73-46babc60200b",
      "name": "Fetch Packages Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -17888,
        2752
      ]
    },
    {
      "id": "31f792d9-48ac-4c4e-9862-a50d2cd3ce3f",
      "name": "Aggregate Packages",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        -17664,
        2752
      ]
    },
    {
      "id": "51d3e91d-5de0-4036-beec-446df55ac27c",
      "name": "Match Packages with GPT-4o",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -17104,
        2576
      ]
    },
    {
      "id": "faa82b3c-0c36-4fff-aa09-686c5a6b3563",
      "name": "Parse AI Response",
      "type": "n8n-nodes-base.set",
      "position": [
        -16848,
        2576
      ]
    },
    {
      "id": "e3753ec4-9b72-40ac-8673-500592de848d",
      "name": "Log Results to Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -16240,
        2752
      ]
    },
    {
      "id": "79ee6bbd-eb21-41b6-88a4-10bb1aeed81d",
      "name": "Loop Over Sponsors",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -17664,
        2592
      ]
    },
    {
      "id": "64bff306-38a1-4590-ba1c-10f7c52b7fdf",
      "name": "Merge Sponsor with Packages",
      "type": "n8n-nodes-base.merge",
      "position": [
        -17472,
        2592
      ]
    },
    {
      "id": "75f69710-4ba6-4e8c-9e45-d595c2f57719",
      "name": "Prepare AI Context",
      "type": "n8n-nodes-base.set",
      "position": [
        -17232,
        2576
      ]
    },
    {
      "id": "bdcabb00-e7cf-44e0-938f-4af7358366c6",
      "name": "Extract Top Match Rankings",
      "type": "n8n-nodes-base.code",
      "position": [
        -16640,
        2576
      ]
    },
    {
      "id": "7df7df3a-1bf8-4a5c-b30f-348216162a9d",
      "name": "If Match Score ≥ 70",
      "type": "n8n-nodes-base.if",
      "position": [
        -16496,
        2576
      ]
    },
    {
      "id": "5b234747-7098-49f1-ad5a-e22a055d1f56",
      "name": "Send Match Summary via Gmail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -16240,
        2576
      ]
    },
    {
      "id": "41939ab6-d366-4bca-9563-06b519509d15",
      "name": "Intro: Sponsor-Package Matching Agent",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -18528,
        1968
      ],
      "parameters": {
        "width": 540,
        "height": 960,
        "content": "## Sponsor-Package Matching Agent\n\n### **What it does:**\nAutomatically matches event sponsors to the best-fit sponsorship packages using AI scoring, then sends personalized email recommendations and l"
      }
    },
    {
      "id": "40b7ad35-7e26-4eab-b077-92615f5d1c0c",
      "name": "Section 1: Fetch & Prepare Data",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -17968,
        2400
      ],
      "parameters": {
        "width": 684,
        "height": 520,
        "content": "## 1. Fetch & Prepare Data\n\nReads sponsor profiles and sponsorship packages from two Google Sheets, then aggregates the package catalog for AI context injection.\n\n- **Sponsors Sheet:** SponsorName, In"
      }
    },
    {
      "id": "277649dd-6d71-4752-8b1d-466676970d94",
      "name": "Section 2: AI Matching Engine",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -17264,
        2400
      ],
      "parameters": {
        "width": 580,
        "height": 520,
        "content": "## 2. AI Matching Engine\n\nLoops through each sponsor, merges their profile with the full package catalog, and sends the context to GPT-4o. The model returns a JSON object with the top 3 package matche"
      }
    },
    {
      "id": "adcb5365-69f1-4e9c-a11d-e9424f5ae431",
      "name": "Section 3: Outreach & Logging",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -16672,
        2400
      ],
      "parameters": {
        "width": 668,
        "height": 520,
        "content": "## 3. Outreach & Logging\n\nParses the AI response, filters out low-confidence matches (score < 70), sends personalized Gmail recommendations to qualifying sponsors, and logs all results to a Google She"
      }
    },
    {
      "id": "ade9ee4f-0501-44b8-ad22-2005ca3577f4",
      "name": "Run Weekdays at 9 AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -18464,
        2672
      ]
    },
    {
      "id": "c46f9dca-e830-4175-8648-4e52020ea605",
      "name": "Contact: Braia Labs",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -15968,
        1712
      ],
      "parameters": {
        "width": 540,
        "height": 1200,
        "content": "## Was this helpful? Get in touch! \n\n[![clic](https://vptkuqoipqbebipqjnqw.supabase.co/storage/v1/object/public/Milo%20Bravo/seeAxWUupcOOXY5tntexZ_video.gif)](https://tally.so/r/EkKGgB)\n\nI really hope"
      }
    }
  ],
  "connections": {
    "Parse AI Response": {
      "main": [
        [
          {
            "node": "Extract Top Match Rankings",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate Packages": {
      "main": [
        [
          {
            "node": "Merge Sponsor with Packages",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Loop Over Sponsors": {
      "main": [
        [
          {
            "node": "Merge Sponsor with Packages",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare AI Context": {
      "main": [
        [
          {
            "node": "Match Packages with GPT-4o",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Packages Sheet": {
      "main": [
        [
          {
            "node": "Aggregate Packages",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Sponsors Sheet": {
      "main": [
        [
          {
            "node": "Loop Over Sponsors",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Run Weekdays at 9 AM": {
      "main": [
        [
          {
            "node": "Set Workflow Variables",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If Match Score ≥ 70": {
      "main": [
        [
          {
            "node": "Send Match Summary via Gmail",
            "type": "main",
            "index": 0
          },
          {
            "node": "Log Results to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Workflow Variables": {
      "main": [
        [
          {
            "node": "Fetch Sponsors Sheet",
            "type": "main",
            "index": 0
          },
          {
            "node": "Fetch Packages Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Top Match Rankings": {
      "main": [
        [
          {
            "node": "If Match Score ≥ 70",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Match Packages with GPT-4o": {
      "main": [
        [
          {
            "node": "Parse AI Response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge Sponsor with Packages": {
      "main": [
        [
          {
            "node": "Prepare AI Context",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log Results to Google Sheets": {
      "main": [
        [
          {
            "node": "Loop Over Sponsors",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}