{
  "name": "Sync events from Excel to Google Calendar with GPT-4o-Mini smart summaries",
  "nodes": [
    {
      "id": "0f6ea127-37bf-4232-b115-8a2147e62562",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -2784,
        -352
      ]
    },
    {
      "id": "4ea9696c-5b24-4642-a406-76f842da7ab4",
      "name": "Read Excel File",
      "type": "n8n-nodes-base.spreadsheetFile",
      "position": [
        -2320,
        -352
      ]
    },
    {
      "id": "6df965c6-b497-47ea-a7cd-79063f125983",
      "name": "Google Drive - Download Excel",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -2480,
        -352
      ]
    },
    {
      "id": "89473215-2fe1-41d1-a27b-d0b52d59b2a3",
      "name": "Set Excel File ID",
      "type": "n8n-nodes-base.set",
      "position": [
        -2640,
        -352
      ]
    },
    {
      "id": "f81be40d-c060-4333-84b5-dec3702981f0",
      "name": "Filter Valid Events",
      "type": "n8n-nodes-base.filter",
      "position": [
        -2144,
        -352
      ]
    },
    {
      "id": "f55e51ce-185b-47dc-9f00-7b0228e8654d",
      "name": "Google Calendar - Create Event",
      "type": "n8n-nodes-base.googleCalendar",
      "position": [
        -1280,
        -208
      ]
    },
    {
      "id": "561f037c-2402-4e55-9458-cfc19ff776bf",
      "name": "Send Email Summary",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        -368,
        -208
      ]
    },
    {
      "id": "93e37187-97e4-4250-afb1-6aec29ae661e",
      "name": "AI - Analyze Event Context",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -1984,
        -224
      ]
    },
    {
      "id": "53f163ec-9b94-4d4a-a2b8-10d97cfc3e5a",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -2032,
        -48
      ]
    },
    {
      "id": "06b34d52-bf62-4478-8d70-e201cbb19297",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        -1824,
        -48
      ]
    },
    {
      "id": "ce58f968-33a0-4e6c-bb43-8c45f997aabd",
      "name": "Merge AI Insights",
      "type": "n8n-nodes-base.merge",
      "position": [
        -1632,
        -96
      ]
    },
    {
      "id": "e6484d5c-c814-43f7-9f14-f61b68ebe4b9",
      "name": "AI - Generate Smart Summary",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -784,
        -208
      ]
    },
    {
      "id": "f1f696b4-8d0d-495c-b577-090e2a2c7a42",
      "name": "OpenAI Chat Model1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -704,
        16
      ]
    },
    {
      "id": "5b46d55e-866d-4f07-97e5-593f9247fbd1",
      "name": "Enrich Event Data",
      "type": "n8n-nodes-base.set",
      "position": [
        -1472,
        -96
      ]
    },
    {
      "id": "36a9bb8e-d171-4e59-89ae-205e14b8ce4d",
      "name": "Update Calendar Event",
      "type": "n8n-nodes-base.googleCalendar",
      "position": [
        -1104,
        -208
      ]
    },
    {
      "id": "dbec3dc3-12ea-41d6-9515-e0616a41cc5a",
      "name": "Prepare AI Summary Data",
      "type": "n8n-nodes-base.set",
      "position": [
        -928,
        -208
      ]
    },
    {
      "id": "5d55e282-1fff-491c-9576-a840d8f83e45",
      "name": "Format AI Email",
      "type": "n8n-nodes-base.set",
      "position": [
        -528,
        -208
      ]
    },
    {
      "id": "4b2eb9fd-21d2-4e49-9c0d-bce61fab9baa",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3232,
        -624
      ],
      "parameters": {
        "width": 1904,
        "height": 736,
        "content": "## **Introduction**\nAutomatically imports Excel schedules from Google Drive, validates data with AI, syncs to Google Calendar, \nand emails smart summaries. Ideal for educators, managers, and administr"
      }
    },
    {
      "id": "22ceba2a-6fbd-4677-b335-03d3d0cfb9c2",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1312,
        -624
      ],
      "parameters": {
        "width": 512,
        "height": 368,
        "content": "## **Use Cases**\n* **Education:** Sync course schedules and exams.\n* **Projects:** Import milestones, update team calendars.\n* **Events:** Manage venue bookings and notifications.\n* **HR:** Automate i"
      }
    },
    {
      "id": "23b97c18-a4be-46fb-a7b0-60d1ec20b3f9",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -768,
        -624
      ],
      "parameters": {
        "width": 336,
        "height": 224,
        "content": "## **Prerequisites**\n* Google Workspace with Drive & Calendar\n* OpenAI API key\n* Gmail/SMTP setup\n* Standardized Excel schedule\n* n8n instance v1.0+\n* Basic OAuth2 setup"
      }
    }
  ],
  "connections": {
    "Format AI Email": {
      "main": [
        [
          {
            "node": "Send Email Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Excel File": {
      "main": [
        [
          {
            "node": "Filter Valid Events",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate Events": {
      "main": [
        [
          {
            "node": "Prepare Email Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Set Excel File ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Enrich Event Data": {
      "main": [
        [
          {
            "node": "Google Calendar - Create Event",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge AI Insights": {
      "main": [
        [
          {
            "node": "Enrich Event Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI - Analyze Event Context",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Set Excel File ID": {
      "main": [
        [
          {
            "node": "Google Drive - Download Excel",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "AI - Generate Smart Summary",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Filter Valid Events": {
      "main": [
        [
          {
            "node": "Google Calendar - Create Event",
            "type": "main",
            "index": 0
          },
          {
            "node": "AI - Analyze Event Context",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge AI Insights",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Prepare Email Summary": {
      "main": [
        [
          {
            "node": "Send Email Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Calendar Event": {
      "main": [
        [
          {
            "node": "Prepare AI Summary Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare AI Summary Data": {
      "main": [
        [
          {
            "node": "AI - Generate Smart Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "AI - Analyze Event Context",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "AI - Analyze Event Context": {
      "main": [
        [
          {
            "node": "Merge AI Insights",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI - Generate Smart Summary": {
      "main": [
        [
          {
            "node": "Format AI Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Drive - Download Excel": {
      "main": [
        [
          {
            "node": "Read Excel File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Calendar - Create Event": {
      "main": [
        [
          {
            "node": "Aggregate Events",
            "type": "main",
            "index": 0
          },
          {
            "node": "Update Calendar Event",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}