学生選抜と入学手続きの自動化
中級
これはMiscellaneous分野の自動化ワークフローで、10個のノードを含みます。主にIf, Code, EmailSend, MicrosoftExcel, ScheduleTriggerなどのノードを使用。 Excel、検証、メール通知で学生採用プロセスを自動化する
前提条件
- •HTTP Webhookエンドポイント（n8nが自動生成）
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "avWHNKwWwluMcjge",
"meta": {
"instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
"templateCredsSetupCompleted": true
},
"name": "Student Admission & Onboarding Automation",
"tags": [],
"nodes": [
{
"id": "7a080e11-1f6a-4bad-be9e-2e791f2339b1",
"name": "申請データの検証",
"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": "申請データの処理",
"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": "学生データベースの更新",
"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": "ウェルカムメールの準備",
"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": "成功応答",
"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": "エラー応答",
"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": "学生データの読み取り",
"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": "メール送信",
"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": "毎日午前7時にトリガー",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-940,
-80
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 7
}
]
}
},
"typeVersion": 1.2
},
{
"id": "cd5f1386-0912-4666-9a27-2d0feb24ff4a",
"name": "付箋",
"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
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - その他
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
学校へのお知らせを WhatsApp とメールで配信するワークフロー
WhatsApp、Eメール、Excelを使った学校通知配信の自動化
If
Code
Email Send
+
If
Code
Email Send
10 ノードOneclick AI Squad
その他
航空券価格の自動比較
複数の予約プラットフォームでの航班価格を比較し、メールレポートを生成する
If
Ssh
Code
+
If
Ssh
Code
19 ノードOneclick AI Squad
その他
財務・会計向けAI駆動型請求書リマインダーと支払い追跡ツール
財務・会計業務向けに設計されたAIベースの請求書リマインダーと支払い追跡ツール
If
Set
Code
+
If
Set
Code
35 ノードOneclick AI Squad
請求書処理
AI駆動型スピーカーおよびセッション推薦エンジン
Claude AIとGoogle Sheetsを使用したイベントスピーカーメモ生成
If
Code
Webhook
+
If
Code
Webhook
20 ノードOneclick AI Squad
その他
AI候補者選考・面接スケジュールシステム
AIベースの候補者スクリーニングと面接スケジューリング（OpenAI GPTとGoogleスイート）
If
Code
Webhook
+
If
Code
Webhook
18 ノードOneclick AI Squad
人事
複数プラットフォームからホテル料金をクロールしメールレポートで自動比較
ホテル価格比較を複数プラットフォームでのスクレイピングとメールレポートで自動化
If
Set
Code
+
If
Set
Code
19 ノードOneclick AI Squad
市場調査
ワークフロー情報
難易度
中級
ノード数10
カテゴリー1
ノードタイプ7
作成者
Oneclick AI Squad
@oneclick-aiThe AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.
外部リンク
n8n.ioで表示 →
このワークフローを共有