AI式入試審査：論文分析、総合評価、候補者ランキング
上級
これは自動化ワークフローで、22個のノードを含みます。主にIf, Set, Gmail, Slack, GoogleSheetsなどのノードを使用。 GPT-4o駆動のバイリンガル案内書翻訳ツール
前提条件
- •Googleアカウント + Gmail API認証情報
- •Slack Bot Token または Webhook URL
- •Google Sheets API認証情報
- •OpenAI API Key
使用ノード (22)
カテゴリー
-
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "86CnelIf3P5nQIhx",
"meta": {
"instanceId": "277842713620d9f5554de3b1518b865a152c8c4db680008bd8aec536fc18b4a8"
},
"name": "AI Admissions Review: Essay Analysis, Holistic Scoring & Candidate Ranking",
"tags": [],
"nodes": [
{
"id": "10db75e5-ad2d-4c14-95a0-ba2411ae3384",
"name": "出願データ抽出",
"type": "n8n-nodes-base.set",
"position": [
-1536,
240
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "applicant_name",
"name": "applicant_name",
"type": "string",
"value": "={{ $json.q3_fullName?.first || '' }} {{ $json.q3_fullName?.last || '' }}"
},
{
"id": "applicant_email",
"name": "applicant_email",
"type": "string",
"value": "={{ $json.q4_email }}"
},
{
"id": "applicant_phone",
"name": "applicant_phone",
"type": "string",
"value": "={{ $json.q5_phone }}"
},
{
"id": "high_school",
"name": "high_school",
"type": "string",
"value": "={{ $json.q6_highSchool }}"
},
{
"id": "gpa",
"name": "gpa",
"type": "string",
"value": "={{ $json.q7_gpa }}"
},
{
"id": "sat_score",
"name": "sat_score",
"type": "string",
"value": "={{ $json.q8_sat || 'Not provided' }}"
},
{
"id": "act_score",
"name": "act_score",
"type": "string",
"value": "={{ $json.q9_act || 'Not provided' }}"
},
{
"id": "intended_major",
"name": "intended_major",
"type": "string",
"value": "={{ $json.q10_major }}"
},
{
"id": "personal_statement",
"name": "personal_statement",
"type": "string",
"value": "={{ $json.q11_personalStatement }}"
},
{
"id": "why_our_college",
"name": "why_our_college",
"type": "string",
"value": "={{ $json.q12_whyUs }}"
},
{
"id": "extracurriculars",
"name": "extracurriculars",
"type": "string",
"value": "={{ $json.q13_activities }}"
},
{
"id": "leadership_roles",
"name": "leadership_roles",
"type": "string",
"value": "={{ $json.q14_leadership || 'None' }}"
},
{
"id": "honors_awards",
"name": "honors_awards",
"type": "string",
"value": "={{ $json.q15_awards || 'None' }}"
},
{
"id": "community_service",
"name": "community_service",
"type": "string",
"value": "={{ $json.q16_service || 'None' }}"
},
{
"id": "work_experience",
"name": "work_experience",
"type": "string",
"value": "={{ $json.q17_work || 'None' }}"
},
{
"id": "financial_aid_needed",
"name": "financial_aid_needed",
"type": "string",
"value": "={{ $json.q18_financialAid || 'No' }}"
},
{
"id": "first_generation",
"name": "first_generation",
"type": "string",
"value": "={{ $json.q19_firstGen || 'No' }}"
},
{
"id": "application_id",
"name": "application_id",
"type": "string",
"value": "=APP-{{ $json.submissionID }}-{{ Date.now() }}"
},
{
"id": "submission_date",
"name": "submission_date",
"type": "string",
"value": "={{ new Date().toISOString() }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "e73be677-5d74-44da-aa2e-ee974a051d50",
"name": "AI論文分析",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-1088,
256
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o"
},
"options": {
"temperature": 0.3
},
"messages": {
"values": [
{
"content": "=You are an expert college admissions essay analyst. Analyze the following application essays for quality, authenticity, and fit.\n\n## APPLICANT INFORMATION\n**Name:** {{ $json.applicant_name }}\n**Intended Major:** {{ $json.intended_major }}\n**High School:** {{ $json.high_school }}\n\n## PERSONAL STATEMENT\n{{ $json.personal_statement }}\n\n## WHY OUR COLLEGE ESSAY\n{{ $json.why_our_college }}\n\n---\n\n## YOUR ANALYSIS TASK\n\nProvide detailed essay analysis in markdown format covering:\n\n### 1. OVERALL QUALITY ASSESSMENT\nRate the essays on a 0-10 scale for:\n- Writing quality (grammar, vocabulary, sentence structure)\n- Authenticity (genuine voice, personal reflection)\n- Depth of thought (insight, maturity, self-awareness)\n- Storytelling ability (narrative structure, engagement)\n- Clarity and coherence\n\n### 2. PERSONAL STATEMENT ANALYSIS\n- Main themes and narrative arc\n- What we learn about the applicant\n- Standout moments or quotes\n- Areas of strength\n- Weaknesses or missed opportunities\n- Evidence of genuine voice vs AI-generated\n\n### 3. \"WHY OUR COLLEGE\" ANALYSIS\n- Specificity (generic vs tailored)\n- Research quality (mentions specific programs, professors, opportunities)\n- Fit demonstration (how applicant would contribute)\n- Authenticity (genuine interest vs formulaic)\n- Connection to personal story\n\n### 4. RED FLAGS\nIdentify any concerning elements:\n- Possible AI-generated content (unnatural phrasing, generic statements, lack of personal details)\n- Plagiarism indicators\n- Inconsistencies with application data\n- Privilege blindness or insensitivity\n- Generic or template-based writing\n- Exaggeration or embellishment\n\n### 5. AUTHENTICITY SCORE (0-10)\nHow genuine and personal are these essays? Consider:\n- Specific personal details and anecdotes\n- Unique voice and perspective\n- Vulnerability and self-reflection\n- Consistency with extracurriculars and background\n\n### 6. INSTITUTIONAL FIT ASSESSMENT\nHow well does this applicant align with our college values and culture?\n- Demonstrates understanding of our institution\n- Values alignment\n- Contribution potential\n- Community fit\n\n### 7. KEY THEMES & INSIGHTS\nWhat are the applicant's:\n- Core values and motivations\n- Intellectual interests\n- Personal growth journey\n- Future aspirations\n- Unique qualities or perspectives\n\n### 8. RECOMMENDATION\n- Essay strength rating: Exceptional / Strong / Good / Acceptable / Weak\n- Would these essays support a competitive application?\n- What makes this applicant memorable (or not)?\n\nBe honest and thorough. Provide specific examples from the essays to support your analysis."
}
]
}
},
"credentials": {
"openAiApi": {
"id": "8IkhtT3EbXygnvcr",
"name": "Klinsman OpenAI"
}
},
"typeVersion": 1.8
},
{
"id": "0cb3a49e-c094-4aa3-a9ec-8b59b5fe5070",
"name": "AI総合審査エージェント",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-608,
224
],
"parameters": {
"text": "=You are an expert college admissions officer conducting holistic review of applications. Evaluate this applicant across all dimensions and provide a comprehensive assessment.\n\n---\n\n## APPLICANT PROFILE\n\n**Name:** {{ $('Extract Application Data').item.json.applicant_name }}\n**High School:** {{ $('Extract Application Data').item.json.high_school }}\n**Intended Major:** {{ $('Extract Application Data').item.json.intended_major }}\n\n### ACADEMIC CREDENTIALS\n- **GPA:** {{ $('Extract Application Data').item.json.gpa }}\n- **SAT Score:** {{ $('Extract Application Data').item.json.sat_score }}\n- **ACT Score:** {{ $('Extract Application Data').item.json.act_score }}\n\n### EXTRACURRICULAR INVOLVEMENT\n**Activities:** {{ $('Extract Application Data').item.json.extracurriculars }}\n\n**Leadership Roles:** {{ $('Extract Application Data').item.json.leadership_roles }}\n\n**Honors & Awards:** {{ $('Extract Application Data').item.json.honors_awards }}\n\n**Community Service:** {{ $('Extract Application Data').item.json.community_service }}\n\n**Work Experience:** {{ $('Extract Application Data').item.json.work_experience }}\n\n### BACKGROUND\n- **First Generation College Student:** {{ $('Extract Application Data').item.json.first_generation }}\n- **Financial Aid Needed:** {{ $('Extract Application Data').item.json.financial_aid_needed }}\n\n### ESSAY ANALYSIS SUMMARY\n{{ $json.message.content }}\n\n---\n\n## INSTITUTIONAL CONTEXT\n\n**About Our College:**\nWe are a highly selective liberal arts college (15% acceptance rate) committed to academic excellence, diversity, and developing future leaders. We value:\n- Intellectual curiosity and academic rigor\n- Leadership and community engagement\n- Diversity of thought and background\n- Character, integrity, and resilience\n- Contribution to campus community\n\n**Average Admitted Student Profile:**\n- GPA: 3.8-4.0 unweighted\n- SAT: 1400-1550\n- ACT: 32-35\n- Strong extracurriculars with depth (not just breadth)\n- Exceptional essays demonstrating fit\n- Leadership experience\n\n---\n\n## YOUR COMPREHENSIVE EVALUATION\n\nProvide a detailed holistic review covering:\n\n### 1. ACADEMIC STRENGTH ASSESSMENT (0-100)\nEvaluate:\n- GPA in context of high school rigor\n- Standardized test scores (if provided)\n- Course rigor and academic trajectory\n- Academic awards and honors\n- Intellectual curiosity demonstrated\n\n### 2. EXTRACURRICULAR PROFILE (0-100)\nEvaluate depth vs breadth:\n- Quality over quantity\n- Leadership positions and impact\n- Commitment and longevity\n- Unique talents or achievements\n- Community contribution\n\n### 3. PERSONAL QUALITIES (0-100)\nBased on essays and activities:\n- Character and integrity\n- Resilience and perseverance\n- Maturity and self-awareness\n- Intellectual curiosity\n- Empathy and social consciousness\n- Authenticity and genuineness\n\n### 4. INSTITUTIONAL FIT (0-100)\nHow well does this applicant align with our values and community?\n- Demonstrated interest and research\n- Values alignment\n- Contribution potential to campus\n- Likelihood to thrive here\n- Match with intended major programs\n\n### 5. DIVERSITY CONTRIBUTION (0-100)\nWhat unique perspectives or experiences does this applicant bring?\n- Background and life experiences\n- First-generation status\n- Geographic diversity\n- Unique talents or perspectives\n- Socioeconomic diversity\n- Intellectual diversity\n\n### 6. OVERALL RECOMMENDATION\nClassify applicant:\n- **admit**: Top 15% - clear admit, exceptional across multiple dimensions\n- **strong_maybe**: Top 15-30% - competitive, needs committee discussion\n- **maybe**: Top 30-50% - solid but not standout, waitlist consideration\n- **deny**: Below threshold - does not meet competitive standards\n\n### 7. COMPOSITE SCORE (0-100)\nWeighted average:\n- Academic (35%)\n- Extracurricular (25%)\n- Personal Qualities (20%)\n- Fit (15%)\n- Diversity (5%)\n\n### 8. STRENGTHS & DISTINGUISHING FACTORS\nWhat makes this applicant stand out positively?\n\n### 9. CONCERNS OR WEAKNESSES\nWhat gives you pause about this application?\n\n### 10. INTERVIEW RECOMMENDATION\n- Must interview (top candidates)\n- Should interview (strong maybes)\n- Optional interview (solid candidates)\n- Skip interview (clear deny)\n\n### 11. KEY QUESTIONS FOR INTERVIEW\nIf interviewing, what should we explore?\n\n### 12. COMMITTEE DISCUSSION POINTS\nWhat should admissions committee debate about this applicant?\n\n### 13. PREDICTED MATRICULATION\nIf admitted, likelihood they would enroll:\n- High (this is likely their top choice)\n- Medium (competitive with other schools)\n- Low (we're probably a safety/backup)\n\nBe thorough, objective, and honest. This is holistic review - consider the whole person, not just numbers.",
"options": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2.2
},
{
"id": "10ec7905-b60b-49f4-8895-ac7f35a31093",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-672,
480
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "gpt-4.1-mini"
},
"options": {
"temperature": 0.3
}
},
"credentials": {
"openAiApi": {
"id": "8IkhtT3EbXygnvcr",
"name": "Klinsman OpenAI"
}
},
"typeVersion": 1.2
},
{
"id": "17535f70-a642-4e2d-93ab-428a462443b0",
"name": "構造化出力パーサー",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
-384,
480
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n \"type\": \"object\",\n \"required\": [\n \"academic_score\",\n \"extracurricular_score\",\n \"personal_qualities_score\",\n \"institutional_fit_score\",\n \"diversity_contribution_score\",\n \"composite_score\",\n \"recommendation\",\n \"strengths\",\n \"concerns\",\n \"interview_recommendation\",\n \"interview_questions\",\n \"committee_discussion_points\",\n \"predicted_matriculation\",\n \"detailed_review_markdown\"\n ],\n \"properties\": {\n \"academic_score\": {\n \"type\": \"integer\",\n \"minimum\": 0,\n \"maximum\": 100\n },\n \"extracurricular_score\": {\n \"type\": \"integer\",\n \"minimum\": 0,\n \"maximum\": 100\n },\n \"personal_qualities_score\": {\n \"type\": \"integer\",\n \"minimum\": 0,\n \"maximum\": 100\n },\n \"institutional_fit_score\": {\n \"type\": \"integer\",\n \"minimum\": 0,\n \"maximum\": 100\n },\n \"diversity_contribution_score\": {\n \"type\": \"integer\",\n \"minimum\": 0,\n \"maximum\": 100\n },\n \"composite_score\": {\n \"type\": \"integer\",\n \"minimum\": 0,\n \"maximum\": 100,\n \"description\": \"Weighted composite score\"\n },\n \"recommendation\": {\n \"type\": \"string\",\n \"enum\": [\"admit\", \"strong_maybe\", \"maybe\", \"deny\"]\n },\n \"strengths\": {\n \"type\": \"array\",\n \"items\": {\"type\": \"string\"},\n \"description\": \"Key strengths and standout factors\"\n },\n \"concerns\": {\n \"type\": \"array\",\n \"items\": {\"type\": \"string\"},\n \"description\": \"Weaknesses or areas of concern\"\n },\n \"interview_recommendation\": {\n \"type\": \"string\",\n \"enum\": [\"must_interview\", \"should_interview\", \"optional\", \"skip\"]\n },\n \"interview_questions\": {\n \"type\": \"array\",\n \"items\": {\"type\": \"string\"},\n \"description\": \"Key questions to explore in interview\"\n },\n \"committee_discussion_points\": {\n \"type\": \"array\",\n \"items\": {\"type\": \"string\"}\n },\n \"predicted_matriculation\": {\n \"type\": \"string\",\n \"enum\": [\"high\", \"medium\", \"low\"]\n },\n \"detailed_review_markdown\": {\n \"type\": \"string\",\n \"description\": \"Complete review in markdown\"\n }\n }\n}"
},
"typeVersion": 1.3
},
{
"id": "5d85736b-5b35-4917-a656-c1b218ec7b13",
"name": "強力合格？",
"type": "n8n-nodes-base.if",
"position": [
-208,
224
],
"parameters": {
"options": {},
"conditions": {
"options": {},
"conditions": [
{
"id": "admit-check",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.recommendation }}",
"rightValue": "admit"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "074409ea-eac4-4049-b849-5c42bc40054d",
"name": "委員会審査？",
"type": "n8n-nodes-base.if",
"position": [
-208,
464
],
"parameters": {
"options": {},
"conditions": {
"options": {},
"combinator": "or",
"conditions": [
{
"id": "maybe-check",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.recommendation }}",
"rightValue": "strong_maybe"
},
{
"id": "maybe-check2",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output.recommendation }}",
"rightValue": "maybe"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "34172434-ac1c-4eb8-a973-63ae11be4ae4",
"name": "入学担当ディレクターへメール送信",
"type": "n8n-nodes-base.gmail",
"position": [
320,
112
],
"webhookId": "4d6ac97b-6b39-4e9e-beed-9f57aa144234",
"parameters": {
"sendTo": "admissions-director@college.edu",
"message": "=<!DOCTYPE html>\n<html>\n<head>\n<style>\nbody{font-family:Arial,sans-serif;line-height:1.6;color:#333;max-width:800px;margin:0 auto;padding:20px}\n.header{background:linear-gradient(135deg,#667eea 0%,#764ba2 100%);color:#fff;padding:25px;text-align:center;border-radius:8px 8px 0 0}\n.content{background:#fff;padding:30px;border:2px solid #667eea}\n.score-grid{display:grid;grid-template-columns:repeat(3,1fr);gap:15px;margin:20px 0}\n.score-box{background:#e7f3ff;padding:15px;text-align:center;border-radius:5px;border:2px solid #667eea}\n.score-box strong{display:block;font-size:28px;color:#667eea;margin-bottom:5px}\n.highlight-box{background:#d4edda;padding:20px;border-left:4px solid #28a745;margin:20px 0}\ntable{width:100%;border-collapse:collapse;margin:15px 0}\ntable td{padding:10px;border-bottom:1px solid #ddd}\ntable td:first-child{font-weight:bold;width:35%}\n</style>\n</head>\n<body>\n<div class=\"header\">\n<h1 style=\"margin:0\">🌟 Exceptional Candidate Alert</h1>\n<p style=\"margin:5px 0 0 0;font-size:18px\">Strong Admit Recommendation</p>\n</div>\n<div class=\"content\">\n<p><strong>We have identified an outstanding applicant who should be fast-tracked for admission.</strong></p>\n\n<div class=\"score-grid\">\n<div class=\"score-box\"><strong>{{ $json.output.composite_score }}</strong>Composite Score</div>\n<div class=\"score-box\"><strong>{{ $json.output.academic_score }}</strong>Academic</div>\n<div class=\"score-box\"><strong>{{ $json.output.institutional_fit_score }}</strong>Fit</div>\n</div>\n\n<h3>Applicant Profile</h3>\n<table>\n<tr><td>Name:</td><td><strong>{{ $('Extract Application Data').item.json.applicant_name }}</strong></td></tr>\n<tr><td>Intended Major:</td><td>{{ $('Extract Application Data').item.json.intended_major }}</td></tr>\n<tr><td>High School:</td><td>{{ $('Extract Application Data').item.json.high_school }}</td></tr>\n<tr><td>GPA:</td><td><strong>{{ $('Extract Application Data').item.json.gpa }}</strong></td></tr>\n<tr><td>SAT:</td><td>{{ $('Extract Application Data').item.json.sat_score }}</td></tr>\n<tr><td>ACT:</td><td>{{ $('Extract Application Data').item.json.act_score }}</td></tr>\n<tr><td>First Generation:</td><td>{{ $('Extract Application Data').item.json.first_generation }}</td></tr>\n</table>\n\n<div class=\"highlight-box\">\n<h3 style=\"margin-top:0;color:#28a745\">✨ What Makes This Applicant Exceptional</h3>\n<ul style=\"margin:0;padding-left:20px\">\n{{ $json.output.strengths.map(s => '<li><strong>' + s + '</strong></li>').join('') }}\n</ul>\n</div>\n\n<h3>Score Breakdown</h3>\n<table>\n<tr><td>Academic Strength:</td><td><strong>{{ $json.output.academic_score }}/100</strong></td></tr>\n<tr><td>Extracurricular Profile:</td><td><strong>{{ $json.output.extracurricular_score }}/100</strong></td></tr>\n<tr><td>Personal Qualities:</td><td><strong>{{ $json.output.personal_qualities_score }}/100</strong></td></tr>\n<tr><td>Institutional Fit:</td><td><strong>{{ $json.output.institutional_fit_score }}/100</strong></td></tr>\n<tr><td>Diversity Contribution:</td><td><strong>{{ $json.output.diversity_contribution_score }}/100</strong></td></tr>\n</table>\n\n<h3>Interview Recommendation</h3>\n<p><strong>{{ $json.output.interview_recommendation.replace('_', ' ').toUpperCase() }}</strong></p>\n\n{{ $json.output.concerns.length > 0 ? '<h3>Points to Explore:</h3><ul>' + $json.output.concerns.map(c => '<li>' + c + '</li>').join('') + '</ul>' : '' }}\n\n<h3>Key Interview Questions</h3>\n<ol>\n{{ $json.output.interview_questions.map(q => '<li>' + q + '</li>').join('') }}\n</ol>\n\n<h3>Predicted Matriculation</h3>\n<p>If admitted, likelihood of enrollment: <strong>{{ $json.output.predicted_matriculation.toUpperCase() }}</strong></p>\n\n<h3>AI Recommendation</h3>\n<p style=\"font-size:18px;color:#667eea\"><strong>{{ $json.output.recommendation.toUpperCase().replace('_', ' ') }}</strong></p>\n\n<div style=\"margin-top:30px;padding:20px;background:#667eea;color:#fff;border-radius:5px;text-align:center\">\n<h3 style=\"margin:0 0 10px 0\">📅 Recommended Next Steps</h3>\n<p style=\"margin:0\">1. Schedule interview within 1 week<br>\n2. Fast-track to admissions committee<br>\n3. Consider for merit scholarship</p>\n</div>\n\n<p style=\"margin-top:20px;padding-top:20px;border-top:1px solid #ddd;font-size:12px;color:#666\">\n<strong>Application ID:</strong> {{ $('Extract Application Data').item.json.application_id }}<br>\n<strong>Submitted:</strong> {{ $('Extract Application Data').item.json.submission_date }}<br>\n<strong>AI Review Date:</strong> {{ new Date().toISOString() }}\n</p>\n</div>\n</body>\n</html>",
"options": {},
"subject": "=🌟 Strong Admit Candidate - {{ $('Extract Application Data').item.json.applicant_name }}"
},
"typeVersion": 2.1
},
{
"id": "839f8f0f-c184-4389-994e-9dadeeaddb30",
"name": "面接招待状送信",
"type": "n8n-nodes-base.gmail",
"position": [
528,
112
],
"webhookId": "2d7cd0c9-f2b8-421f-a79d-13b8c9152f22",
"parameters": {
"sendTo": "={{ $('Extract Application Data').item.json.applicant_email }}",
"message": "=<!DOCTYPE html>\n<html>\n<head>\n<style>\nbody{font-family:Arial,sans-serif;line-height:1.6;color:#333;max-width:600px;margin:0 auto;padding:20px}\n.header{background:#667eea;color:#fff;padding:25px;text-align:center;border-radius:8px 8px 0 0}\n.content{background:#fff;padding:30px;border:1px solid #ddd}\n.info-box{background:#e7f3ff;padding:15px;border-radius:5px;margin:20px 0}\n</style>\n</head>\n<body>\n<div class=\"header\">\n<h2 style=\"margin:0\">Congratulations, {{ $('Extract Application Data').item.json.applicant_name.split(' ')[0] }}! 🎉</h2>\n</div>\n<div class=\"content\">\n<p>Dear {{ $('Extract Application Data').item.json.applicant_name }},</p>\n\n<p>Thank you for your application to [College Name]. We're excited to share that after reviewing your application, we'd like to invite you to the next step in our admissions process.</p>\n\n<div class=\"info-box\">\n<p style=\"margin:0\"><strong>📅 Interview Invitation</strong></p>\n<p style=\"margin:5px 0 0 0\">We were impressed by your academic achievements, extracurricular involvement, and thoughtful essays. We'd like to learn more about you through a personal interview.</p>\n</div>\n\n<h3>What This Means</h3>\n<p>Being invited to interview is a significant step and indicates that you are a strong candidate for admission. The interview gives us a chance to get to know you beyond your application and for you to learn more about [College Name].</p>\n\n<h3>Next Steps</h3>\n<ol>\n<li>Our admissions team will contact you within 2-3 business days to schedule your interview</li>\n<li>Interviews are typically 30-45 minutes via video call or in-person</li>\n<li>You'll have the opportunity to ask questions about our programs, campus life, and more</li>\n</ol>\n\n<h3>Interview Preparation</h3>\n<p>We recommend:</p>\n<ul>\n<li>Review your application materials</li>\n<li>Prepare questions about our {{ $('Extract Application Data').item.json.intended_major }} program</li>\n<li>Think about what makes you excited about [College Name]</li>\n<li>Be yourself - we want to know the real you!</li>\n</ul>\n\n<h3>Questions?</h3>\n<p>If you have any questions or need to discuss scheduling, please don't hesitate to contact our admissions office:</p>\n<p>📞 Phone: (555) 123-4567<br>\n📧 Email: admissions@college.edu</p>\n\n<p>We're looking forward to speaking with you soon!</p>\n\n<p>Warm regards,<br>\n<strong>Admissions Committee</strong><br>\n[College Name]</p>\n\n<p style=\"margin-top:30px;padding-top:20px;border-top:1px solid #ddd;font-size:12px;color:#666\">\nApplication ID: {{ $('Extract Application Data').item.json.application_id }}\n</p>\n</div>\n</body>\n</html>",
"options": {},
"subject": "=Next Steps in Your Application - Interview Invitation"
},
"typeVersion": 2.1
},
{
"id": "067de404-fb95-4db3-9277-078ab5f30123",
"name": "委員会審査を依頼",
"type": "n8n-nodes-base.gmail",
"position": [
160,
400
],
"webhookId": "committee-review-webhook",
"parameters": {
"sendTo": "admissions-committee@college.edu",
"message": "=<!DOCTYPE html>\n<html>\n<head>\n<style>\nbody{font-family:Arial,sans-serif;line-height:1.6;color:#333;max-width:800px;margin:0 auto;padding:20px}\n.header{background:#ff9800;color:#fff;padding:20px;text-align:center;border-radius:8px 8px 0 0}\n.content{background:#fff;padding:30px;border:2px solid #ff9800}\n.score-grid{display:grid;grid-template-columns:repeat(3,1fr);gap:15px;margin:20px 0}\n.score-box{background:#fff3cd;padding:15px;text-align:center;border-radius:5px;border:2px solid #ffc107}\n.score-box strong{display:block;font-size:24px;color:#856404}\ntable{width:100%;border-collapse:collapse;margin:15px 0}\ntable td{padding:10px;border-bottom:1px solid #ddd}\ntable td:first-child{font-weight:bold;width:35%}\n.section{background:#f8f9fa;padding:15px;border-radius:5px;margin:15px 0}\n</style>\n</head>\n<body>\n<div class=\"header\">\n<h2 style=\"margin:0\">📋 Application Requires Committee Discussion</h2>\n</div>\n<div class=\"content\">\n<p><strong>This applicant has strengths worth discussing but also raises questions that merit committee deliberation.</strong></p>\n\n<div class=\"score-grid\">\n<div class=\"score-box\"><strong>{{ $json.output.composite_score }}</strong>Composite</div>\n<div class=\"score-box\"><strong>{{ $json.output.academic_score }}</strong>Academic</div>\n<div class=\"score-box\"><strong>{{ $json.output.institutional_fit_score }}</strong>Fit</div>\n</div>\n\n<h3>Applicant Information</h3>\n<table>\n<tr><td>Name:</td><td>{{ $('Extract Application Data').item.json.applicant_name }}</td></tr>\n<tr><td>Intended Major:</td><td>{{ $('Extract Application Data').item.json.intended_major }}</td></tr>\n<tr><td>High School:</td><td>{{ $('Extract Application Data').item.json.high_school }}</td></tr>\n<tr><td>GPA:</td><td>{{ $('Extract Application Data').item.json.gpa }}</td></tr>\n<tr><td>Test Scores:</td><td>SAT: {{ $('Extract Application Data').item.json.sat_score }} | ACT: {{ $('Extract Application Data').item.json.act_score }}</td></tr>\n</table>\n\n<div class=\"section\">\n<h3 style=\"margin-top:0\">✅ Strengths</h3>\n<ul>\n{{ $json.output.strengths.map(s => '<li>' + s + '</li>').join('') }}\n</ul>\n</div>\n\n<div class=\"section\">\n<h3 style=\"margin-top:0\">⚠️ Areas of Concern</h3>\n<ul>\n{{ $json.output.concerns.map(c => '<li>' + c + '</li>').join('') }}\n</ul>\n</div>\n\n<h3>Committee Discussion Points</h3>\n<ol>\n{{ $json.output.committee_discussion_points.map(point => '<li>' + point + '</li>').join('') }}\n</ol>\n\n<h3>Full Score Breakdown</h3>\n<table>\n<tr><td>Academic:</td><td>{{ $json.output.academic_score }}/100</td></tr>\n<tr><td>Extracurricular:</td><td>{{ $json.output.extracurricular_score }}/100</td></tr>\n<tr><td>Personal Qualities:</td><td>{{ $json.output.personal_qualities_score }}/100</td></tr>\n<tr><td>Institutional Fit:</td><td>{{ $json.output.institutional_fit_score }}/100</td></tr>\n<tr><td>Diversity:</td><td>{{ $json.output.diversity_contribution_score }}/100</td></tr>\n</table>\n\n<h3>AI Recommendation</h3>\n<p><strong>{{ $json.output.recommendation.toUpperCase().replace('_', ' ') }}</strong></p>\n\n<h3>Interview Status</h3>\n<p>{{ $json.output.interview_recommendation.replace('_', ' ').toUpperCase() }}</p>\n\n<p style=\"margin-top:30px;padding:20px;background:#fff3cd;border-radius:5px\">\n<strong>Action Required:</strong> Please review this application and vote on admission decision.\n</p>\n\n<p style=\"margin-top:20px;padding-top:20px;border-top:1px solid #ddd;font-size:12px;color:#666\">\nApplication ID: {{ $('Extract Application Data').item.json.application_id }}\n</p>\n</div>\n</body>\n</html>",
"options": {},
"subject": "=Committee Review Required - {{ $('Extract Application Data').item.json.applicant_name }}",
"operation": "sendAndWait"
},
"typeVersion": 2.1
},
{
"id": "b4359d77-a690-463a-8ec2-154977ffee02",
"name": "受領確認メール送信",
"type": "n8n-nodes-base.gmail",
"position": [
368,
400
],
"webhookId": "888d0d0e-f4b1-410e-b6a6-f4b56f747875",
"parameters": {
"sendTo": "={{ $('Extract Application Data').item.json.applicant_email }}",
"message": "=<!DOCTYPE html>\n<html>\n<head>\n<style>\nbody{font-family:Arial,sans-serif;line-height:1.6;color:#333;max-width:600px;margin:0 auto;padding:20px}\n.header{background:#667eea;color:#fff;padding:20px;text-align:center;border-radius:8px 8px 0 0}\n.content{background:#fff;padding:30px;border:1px solid #ddd}\n</style>\n</head>\n<body>\n<div class=\"header\">\n<h2 style=\"margin:0\">Application Received</h2>\n</div>\n<div class=\"content\">\n<p>Dear {{ $('Extract Application Data').item.json.applicant_name }},</p>\n\n<p>Thank you for applying to [College Name]. We have received your application and it is currently under review by our admissions committee.</p>\n\n<p><strong>Application ID:</strong> {{ $('Extract Application Data').item.json.application_id }}</p>\n\n<p>Our committee conducts a thorough, holistic review of each application, considering your academic achievements, extracurricular involvement, essays, and overall fit with our institution.</p>\n\n<h3>What Happens Next</h3>\n<ul>\n<li>Your application will be reviewed by multiple members of our admissions committee</li>\n<li>Admission decisions will be released by [Decision Date]</li>\n<li>You can check your application status at our <a href=\"https://portal.college.edu\">applicant portal</a></li>\n</ul>\n\n<h3>Timeline</h3>\n<p>Regular Decision notifications: April 1<br>\nYou'll receive an email when your decision is available</p>\n\n<p>We appreciate your patience as we carefully review all applications. If you have questions, please contact our admissions office at admissions@college.edu or (555) 123-4567.</p>\n\n<p>Best wishes,<br>\n<strong>Admissions Office</strong><br>\n[College Name]</p>\n\n<p style=\"margin-top:30px;padding-top:20px;border-top:1px solid #ddd;font-size:12px;color:#666\">\nApplication ID: {{ $('Extract Application Data').item.json.application_id }}\n</p>\n</div>\n</body>\n</html>",
"options": {},
"subject": "=Application Status Update"
},
"typeVersion": 2.1
},
{
"id": "cd325ae2-d04e-4b87-9583-7ce2cd53e2f8",
"name": "標準受領確認送信",
"type": "n8n-nodes-base.gmail",
"position": [
304,
784
],
"webhookId": "97958ee0-7fb5-4baf-81c4-2170331b87a0",
"parameters": {
"sendTo": "={{ $('Extract Application Data').item.json.applicant_email }}",
"message": "=<!DOCTYPE html>\n<html>\n<head>\n<style>\nbody{font-family:Arial,sans-serif;line-height:1.6;color:#333;max-width:600px;margin:0 auto;padding:20px}\n.header{background:#6c757d;color:#fff;padding:20px;text-align:center;border-radius:8px 8px 0 0}\n.content{background:#fff;padding:30px;border:1px solid #ddd}\n</style>\n</head>\n<body>\n<div class=\"header\">\n<h2 style=\"margin:0\">Application Received</h2>\n</div>\n<div class=\"content\">\n<p>Dear {{ $('Extract Application Data').item.json.applicant_name }},</p>\n\n<p>Thank you for your interest in [College Name] and for taking the time to complete your application.</p>\n\n<p>Your application has been received and will be reviewed by our admissions committee. We carefully consider each applicant in our holistic review process.</p>\n\n<p><strong>Application ID:</strong> {{ $('Extract Application Data').item.json.application_id }}</p>\n\n<h3>What's Next</h3>\n<p>Admission decisions will be released by [Decision Date]. You'll receive notification via email and can also check your status through our <a href=\"https://portal.college.edu\">applicant portal</a>.</p>\n\n<p>We appreciate your patience during the review process. If you have any questions, please don't hesitate to contact our admissions office.</p>\n\n<p>Warm regards,<br>\n<strong>Admissions Team</strong><br>\n[College Name]</p>\n\n<p style=\"margin-top:30px;padding-top:20px;border-top:1px solid #ddd;font-size:12px;color:#666\">\nApplication ID: {{ $('Extract Application Data').item.json.application_id }}\n</p>\n</div>\n</body>\n</html>",
"options": {},
"subject": "=Thank You for Your Application"
},
"typeVersion": 2.1
},
{
"id": "631d0b66-a2ca-4205-b0dd-0f179aafee51",
"name": "入学データベースへ記録",
"type": "n8n-nodes-base.googleSheets",
"position": [
928,
256
],
"parameters": {
"columns": {
"value": {
"gpa": "={{ $('Extract Application Data').item.json.gpa }}",
"email": "={{ $('Extract Application Data').item.json.applicant_email }}",
"phone": "={{ $('Extract Application Data').item.json.applicant_phone }}",
"status": "={{ $json.status || 'Under Review' }}",
"act_score": "={{ $('Extract Application Data').item.json.act_score }}",
"sat_score": "={{ $('Extract Application Data').item.json.sat_score }}",
"high_school": "={{ $('Extract Application Data').item.json.high_school }}",
"financial_aid": "={{ $('Extract Application Data').item.json.financial_aid_needed }}",
"academic_score": "={{ $json.output.academic_score }}",
"applicant_name": "={{ $('Extract Application Data').item.json.applicant_name }}",
"application_id": "={{ $('Extract Application Data').item.json.application_id }}",
"intended_major": "={{ $('Extract Application Data').item.json.intended_major }}",
"recommendation": "={{ $json.output.recommendation }}",
"composite_score": "={{ $json.output.composite_score }}",
"diversity_score": "={{ $json.output.diversity_contribution_score }}",
"submission_date": "={{ $('Extract Application Data').item.json.submission_date }}",
"first_generation": "={{ $('Extract Application Data').item.json.first_generation }}",
"interview_status": "={{ $json.output.interview_recommendation }}",
"extracurricular_score": "={{ $json.output.extracurricular_score }}",
"institutional_fit_score": "={{ $json.output.institutional_fit_score }}",
"predicted_matriculation": "={{ $json.output.predicted_matriculation }}",
"personal_qualities_score": "={{ $json.output.personal_qualities_score }}"
},
"mappingMode": "defineBelow"
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_GOOGLE_SHEET_ID"
}
},
"typeVersion": 4.5
},
{
"id": "d59b4c1e-5e1e-4cdc-8a1e-d139f9b7c405",
"name": "付箋 - 受付",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1808,
32
],
"parameters": {
"color": 5,
"width": 500,
"height": 408,
"content": "## 📝 Application Intake\n\nCaptures comprehensive college application via **JotForm**.\n\nCreate your form for free on [JotForm using this link](https://www.jotform.com/?partner=mediajade)\n\n**Output:** Complete application ready for AI review"
},
"typeVersion": 1
},
{
"id": "09768e5e-9bc2-4c4a-bcbc-bd40300c5691",
"name": "付箋 - 論文",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
80
],
"parameters": {
"color": 4,
"width": 450,
"height": 348,
"content": "## 📚 AI Essay Analysis\n\nDeep analysis of application essays for quality, authenticity, and fit.\n\n**Result:** Comprehensive essay evaluation for committee"
},
"typeVersion": 1
},
{
"id": "516591aa-7120-4799-9213-1bceccc1bfb2",
"name": "付箋 - 総合評価",
"type": "n8n-nodes-base.stickyNote",
"position": [
-704,
64
],
"parameters": {
"color": 6,
"width": 660,
"height": 612,
"content": "## 🎯 Holistic Review AI Agent\n\nComprehensive evaluation across all application dimensions.\n\n**Result:** Data-driven admission decision support"
},
"typeVersion": 1
},
{
"id": "0adb819c-b7bc-4eb2-8b1c-2a0e303dd91b",
"name": "付箋 - 強力合格",
"type": "n8n-nodes-base.stickyNote",
"position": [
48,
-48
],
"parameters": {
"color": 3,
"width": 616,
"height": 332,
"content": "## 🌟 Strong Admit Path\n\n**For top 15% of applicants (Score 85-100)**\n\n**Goal:** Secure enrollment of top candidates"
},
"typeVersion": 1
},
{
"id": "6b278331-af50-419a-be3a-c50697143b87",
"name": "付箋 - 委員会",
"type": "n8n-nodes-base.stickyNote",
"position": [
96,
304
],
"parameters": {
"color": 7,
"width": 520,
"height": 300,
"content": "## 🤔 Committee Review Path"
},
"typeVersion": 1
},
{
"id": "5529e35e-5431-4f78-8153-d9240ba4305f",
"name": "付箋 - 標準",
"type": "n8n-nodes-base.stickyNote",
"position": [
112,
656
],
"parameters": {
"color": 2,
"width": 472,
"height": 316,
"content": "## ❌ Standard Processing Path\n\n**Goal:** Respectful process for all applicants"
},
"typeVersion": 1
},
{
"id": "c5436167-4d5e-40f7-8a5b-5edbebd86666",
"name": "付箋 - 分析",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
112
],
"parameters": {
"width": 392,
"height": 348,
"content": "## 📊 Admissions Analytics\n\nComprehensive tracking for insights and compliance.\n\n**Result:** Data-driven admissions excellence"
},
"typeVersion": 1
},
{
"id": "de2a9190-597d-4e71-a62e-02336094c164",
"name": "JotFormトリガー",
"type": "n8n-nodes-base.jotFormTrigger",
"position": [
-1760,
240
],
"webhookId": "93c6d540-90d2-4b5b-aeba-21dacd21acb0",
"parameters": {
"form": "252815424602048"
},
"credentials": {
"jotFormApi": {
"id": "cOSh16Q5l4e0EB1A",
"name": "Jotform jitesh@mediajade.com"
}
},
"typeVersion": 1
},
{
"id": "a4db1487-2e0e-48a7-8e64-6ab205ce9d91",
"name": "メッセージ送信",
"type": "n8n-nodes-base.slack",
"position": [
112,
112
],
"webhookId": "10849bc5-43cf-4d74-a2bb-9168d6641c6b",
"parameters": {
"text": "=:star2: *STRONG ADMIT CANDIDATE* :star2:\\n\\n*Applicant:* {{ $('Extract Application Data').item.json.applicant_name }}\\n*Intended Major:* {{ $('Extract Application Data').item.json.intended_major }}\\n*Composite Score:* {{ $json.output.composite_score }}/100\\n*Recommendation:* {{ $json.output.recommendation.toUpperCase() }}\\n\\n*Score Breakdown:*\\n• Academic: {{ $json.output.academic_score }}/100\\n• Extracurricular: {{ $json.output.extracurricular_score }}/100\\n• Personal Qualities: {{ $json.output.personal_qualities_score }}/100\\n• Institutional Fit: {{ $json.output.institutional_fit_score }}/100\\n\\n*Key Strengths:*\\n{{ $json.output.strengths.map(s => '• ' + s).join('\\\\n') }}\\n\\n*Interview:* {{ $json.output.interview_recommendation.replace('_', ' ').toUpperCase() }}\\n\\n:tada: *ACTION:* Schedule interview and fast-track for admissions committee review!",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "list",
"value": ""
},
"otherOptions": {}
},
"typeVersion": 2.3
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "2f63691b-14fa-4a48-bc85-6953c93bde77",
"connections": {
"5d85736b-5b35-4917-a656-c1b218ec7b13": {
"main": [
[
{
"node": "a4db1487-2e0e-48a7-8e64-6ab205ce9d91",
"type": "main",
"index": 0
}
]
]
},
"a4db1487-2e0e-48a7-8e64-6ab205ce9d91": {
"main": [
[
{
"node": "34172434-ac1c-4eb8-a973-63ae11be4ae4",
"type": "main",
"index": 0
}
]
]
},
"de2a9190-597d-4e71-a62e-02336094c164": {
"main": [
[
{
"node": "10db75e5-ad2d-4c14-95a0-ba2411ae3384",
"type": "main",
"index": 0
}
]
]
},
"e73be677-5d74-44da-aa2e-ee974a051d50": {
"main": [
[
{
"node": "0cb3a49e-c094-4aa3-a9ec-8b59b5fe5070",
"type": "main",
"index": 0
}
]
]
},
"074409ea-eac4-4049-b849-5c42bc40054d": {
"main": [
[
{
"node": "067de404-fb95-4db3-9277-078ab5f30123",
"type": "main",
"index": 0
}
],
[
{
"node": "cd325ae2-d04e-4b87-9583-7ce2cd53e2f8",
"type": "main",
"index": 0
}
]
]
},
"10ec7905-b60b-49f4-8895-ac7f35a31093": {
"ai_languageModel": [
[
{
"node": "0cb3a49e-c094-4aa3-a9ec-8b59b5fe5070",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"0cb3a49e-c094-4aa3-a9ec-8b59b5fe5070": {
"main": [
[
{
"node": "5d85736b-5b35-4917-a656-c1b218ec7b13",
"type": "main",
"index": 0
},
{
"node": "074409ea-eac4-4049-b849-5c42bc40054d",
"type": "main",
"index": 0
}
]
]
},
"10db75e5-ad2d-4c14-95a0-ba2411ae3384": {
"main": [
[
{
"node": "e73be677-5d74-44da-aa2e-ee974a051d50",
"type": "main",
"index": 0
}
]
]
},
"067de404-fb95-4db3-9277-078ab5f30123": {
"main": [
[
{
"node": "b4359d77-a690-463a-8ec2-154977ffee02",
"type": "main",
"index": 0
}
]
]
},
"17535f70-a642-4e2d-93ab-428a462443b0": {
"ai_outputParser": [
[
{
"node": "0cb3a49e-c094-4aa3-a9ec-8b59b5fe5070",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"34172434-ac1c-4eb8-a973-63ae11be4ae4": {
"main": [
[
{
"node": "839f8f0f-c184-4389-994e-9dadeeaddb30",
"type": "main",
"index": 0
}
]
]
},
"b4359d77-a690-463a-8ec2-154977ffee02": {
"main": [
[
{
"node": "631d0b66-a2ca-4205-b0dd-0f179aafee51",
"type": "main",
"index": 0
}
]
]
},
"839f8f0f-c184-4389-994e-9dadeeaddb30": {
"main": [
[
{
"node": "631d0b66-a2ca-4205-b0dd-0f179aafee51",
"type": "main",
"index": 0
}
]
]
},
"cd325ae2-d04e-4b87-9583-7ce2cd53e2f8": {
"main": [
[
{
"node": "631d0b66-a2ca-4205-b0dd-0f179aafee51",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
領収書添付あり？
GPT-4o による詐欺検出と QuickBooks で領支付宝を自動抽出して承認
If
Code
Gmail
+
If
Code
Gmail
22 ノードJitesh Dugar
AI医療トリアージ：スマートトリアージ、医師ブリーフィング、緊急事態検出
GPT-4とJotFormに基づく医療分類と予約の自動化
If
Set
Code
+
If
Set
Code
22 ノードJitesh Dugar
GPT-4を使用してJotFormを活用した退職インタビューによる従業員の離職プロセスの自動化
GPT-4を使用してJotFormの入退社インタビューを活用した従業員離職業務の自動化
If
Set
Code
+
If
Set
Code
20 ノードJitesh Dugar
JotForm、GPT-4o-mini、Google Workspaceを使用した従業員の入社業務の自動化
JotForm、GPT-4o-mini、Google Workspaceを使用した従業員採用業務の自動化
If
Set
Code
+
If
Set
Code
14 ノードJitesh Dugar
OpenAIを使ったリード分析と個別メール生成
Jotform、GPT、Gmail を使った potential customer 謁選とパーソナライズされたアプローチの自動化
If
Code
Gmail
+
If
Code
Gmail
16 ノードJitesh Dugar
Jotform、GPT-4 を使用した貸出前審査の自動化と Gmail による通知
Jotform、GPT-4、アнализローン承認前通知をGmailで自動化
If
Set
Code
+
If
Set
Code
21 ノードJitesh Dugar
ワークフロー情報
難易度
上級
ノード数22
カテゴリー-
ノードタイプ11
作成者
Jitesh Dugar
@jiteshdugarAI Automation Specialist - OpenAI, CRM & Automation Expert with a solid understanding of various tools that include Zapier, Make, Zoho CRM, Hubspot, Google Sheets, Airtable, Pipedrive, Google Analytics, and more.
外部リンク
n8n.ioで表示 →
このワークフローを共有