Automatisierung der Schülerzulassung und Einschreibung

• •HTTP Webhook-Endpunkt (wird von n8n automatisch generiert)

{
  "id": "avWHNKwWwluMcjge",
  "meta": {
    "instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
    "templateCredsSetupCompleted": true
  },
  "name": "Student Admission & Onboarding Automation",
  "tags": [],
  "nodes": [
    {
      "id": "7a080e11-1f6a-4bad-be9e-2e791f2339b1",
      "name": "Bewerbungsdaten validieren",
      "type": "n8n-nodes-base.if",
      "position": [
        -500,
        -80
      ],
      "parameters": {
        "conditions": {
          "string": [
            {
              "value1": "={{$json.firstName}}",
              "operation": "isNotEmpty"
            },
            {
              "value1": "={{$json.lastName}}",
              "operation": "isNotEmpty"
            },
            {
              "value1": "={{$json.email}}",
              "operation": "isNotEmpty"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "fdf26268-f331-4a67-826d-541abe266d1a",
      "name": "Bewerbungsdaten verarbeiten",
      "type": "n8n-nodes-base.code",
      "position": [
        -280,
        -180
      ],
      "parameters": {
        "jsCode": "// Get existing data from Excel\nconst existingData = $input.all();\n\n// Get new application data from webhook\nconst newApplication = $('Webhook - Application Form').first().json;\n\n// Create new student record\nconst newStudent = {\n  'Application ID': 'APP-' + Date.now(),\n  'First Name': newApplication.firstName,\n  'Last Name': newApplication.lastName,\n  'Email': newApplication.email,\n  'Phone': newApplication.phone || '',\n  'Program Interest': newApplication.program || 'General',\n  'Grade Level': newApplication.gradeLevel || '',\n  'School': newApplication.school || '',\n  'Guardian Name': newApplication.guardianName || '',\n  'Guardian Phone': newApplication.guardianPhone || '',\n  'Application Date': new Date().toISOString().split('T')[0],\n  'Status': 'Pending Review',\n  'Notes': newApplication.additionalNotes || ''\n};\n\n// Combine existing data with new application\nconst allData = [...existingData, newStudent];\n\nreturn allData.map(item => ({ json: item }));"
      },
      "typeVersion": 2
    },
    {
      "id": "cf61ad33-7397-4d7b-820d-42f17b88bde8",
      "name": "Studentendatenbank aktualisieren",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        -60,
        -180
      ],
      "parameters": {
        "options": {},
        "resource": "worksheet",
        "workbook": {
          "__rl": true,
          "mode": "id",
          "value": "324t5yttre"
        },
        "operation": "append",
        "worksheet": {
          "__rl": true,
          "mode": "id",
          "value": "=23wrhhh"
        }
      },
      "credentials": {
        "microsoftExcelOAuth2Api": {
          "id": "jevPChvDpEJk6W9v",
          "name": "Microsoft Excel account - test"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "dd051ad2-91b2-411c-a128-26169f78fb3e",
      "name": "Willkommens-E-Mail vorbereiten",
      "type": "n8n-nodes-base.code",
      "position": [
        160,
        -180
      ],
      "parameters": {
        "jsCode": "// Get application data\nconst applicationData = $('Webhook - Application Form').first().json;\n\n// Create email content\nconst emailSubject = 'Welcome! Your Application Has Been Received';\nconst emailBody = `Dear ${applicationData.firstName} ${applicationData.lastName},\n\nThank you for your interest in our program! We have successfully received your application and it is currently under review.\n\nApplication Details:\n- Program of Interest: ${applicationData.program || 'General Program'}\n- Grade Level: ${applicationData.gradeLevel || 'Not Specified'}\n- Application Date: ${new Date().toLocaleDateString()}\n\nWhat happens next?\n1. Our admissions team will review your application within 3-5 business days\n2. You will receive an email with next steps or any additional requirements\n3. If you have any questions, please don't hesitate to contact us\n\nThank you for choosing our institution. We look forward to potentially welcoming you to our community!\n\nBest regards,\nAdmissions Team`;\n\nreturn [{\n  json: {\n    to: applicationData.email,\n    subject: emailSubject,\n    body: emailBody,\n    studentName: `${applicationData.firstName} ${applicationData.lastName}`,\n    program: applicationData.program,\n    applicationDate: new Date().toLocaleDateString()\n  }\n}];"
      },
      "typeVersion": 2
    },
    {
      "id": "717ebb5a-648c-4748-9ef1-573ec09458c9",
      "name": "Success Response",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        600,
        -180
      ],
      "parameters": {
        "options": {},
        "respondWith": "json",
        "responseBody": "={\n  \"success\": true,\n  \"message\": \"Application submitted successfully\",\n  \"applicationId\": \"APP-\" + Date.now(),\n  \"status\": \"pending_review\",\n  \"studentName\": $json.firstName + \" \" + $json.lastName,\n  \"program\": $json.program || \"General\",\n  \"submissionTime\": new Date().toISOString(),\n  \"nextSteps\": \"You will receive an email confirmation shortly and our admissions team will review your application within 3-5 business days.\"\n}"
      },
      "typeVersion": 1
    },
    {
      "id": "40c7a9e4-26da-4e54-9598-105e54b1cd28",
      "name": "Error Response",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        -280,
        20
      ],
      "parameters": {
        "options": {
          "responseCode": 400
        },
        "respondWith": "json",
        "responseBody": "{\n  \"success\": false,\n  \"error\": \"Invalid application data\",\n  \"message\": \"Please ensure all required fields (firstName, lastName, email) are provided.\",\n  \"requiredFields\": [\"firstName\", \"lastName\", \"email\"],\n  \"timestamp\": \"{{ new Date().toISOString() }}\"\n}"
      },
      "typeVersion": 1
    },
    {
      "id": "a0aa2e5a-1d10-4926-8da4-b81402ea0f35",
      "name": "Studentendaten lesen",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        -720,
        -80
      ],
      "parameters": {
        "filters": {},
        "resource": "worksheet",
        "workbook": {
          "__rl": true,
          "mode": "id",
          "value": "1234567uytr4w"
        }
      },
      "credentials": {
        "microsoftExcelOAuth2Api": {
          "id": "jevPChvDpEJk6W9v",
          "name": "Microsoft Excel account - test"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "76950d75-bc2f-47a6-b682-6bc46b921f42",
      "name": "Send email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        380,
        -180
      ],
      "webhookId": "772da57c-1922-4b06-ae50-626d8695c776",
      "parameters": {
        "text": "${applicationData.emailtext}",
        "options": {},
        "subject": "${applicationData.subject}",
        "toEmail": "${applicationData.toemail}",
        "fromEmail": "admin@school.com",
        "emailFormat": "text"
      },
      "credentials": {
        "smtp": {
          "id": "G1kyF8cSWTZ4vouN",
          "name": "SMTP -test"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "0107a249-3bf2-4019-8daf-92eb6a92637a",
      "name": "Trigger at Every Day 7 am",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -940,
        -80
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 7
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "cd5f1386-0912-4666-9a27-2d0feb24ff4a",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -980,
        -440
      ],
      "parameters": {
        "color": 5,
        "width": 640,
        "height": 260,
        "content": "### **Main Components**\n* **Trigger at Every Day 7 am** - Scheduled trigger that runs the workflow daily\n* **Read Student Data** - Reads pending applications from Excel/database\n* **Validate Application Data** - Checks data completeness and format\n* **Process Application Data** - Processes validated applications\n* **Update Student Database** - Updates records in the student database\n* **Prepare Welcome Email** - Creates personalized welcome messages\n* **Send Email** - Sends welcome emails to students/guardians\n* **Success Response** - Confirms successful processing\n* **Error Response** - Handles any processing errors\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "39d210c3-6dc0-4dce-8cea-133208caf718",
  "connections": {
    "76950d75-bc2f-47a6-b682-6bc46b921f42": {
      "main": [
        [
          {
            "node": "717ebb5a-648c-4748-9ef1-573ec09458c9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a0aa2e5a-1d10-4926-8da4-b81402ea0f35": {
      "main": [
        [
          {
            "node": "7a080e11-1f6a-4bad-be9e-2e791f2339b1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "dd051ad2-91b2-411c-a128-26169f78fb3e": {
      "main": [
        [
          {
            "node": "76950d75-bc2f-47a6-b682-6bc46b921f42",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cf61ad33-7397-4d7b-820d-42f17b88bde8": {
      "main": [
        [
          {
            "node": "dd051ad2-91b2-411c-a128-26169f78fb3e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fdf26268-f331-4a67-826d-541abe266d1a": {
      "main": [
        [
          {
            "node": "cf61ad33-7397-4d7b-820d-42f17b88bde8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0107a249-3bf2-4019-8daf-92eb6a92637a": {
      "main": [
        [
          {
            "node": "a0aa2e5a-1d10-4926-8da4-b81402ea0f35",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7a080e11-1f6a-4bad-be9e-2e791f2339b1": {
      "main": [
        [
          {
            "node": "fdf26268-f331-4a67-826d-541abe266d1a",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "40c7a9e4-26da-4e54-9598-105e54b1cd28",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}