AI招生审核：论文分析、综合评分与候选人排名

• •Google 账号和 Gmail API 凭证
• •Slack Bot Token 或 Webhook URL
• •Google Sheets API 凭证
• •OpenAI API Key

{
  "id": "86CnelIf3P5nQIhx",
  "meta": {
    "instanceId": "277842713620d9f5554de3b1518b865a152c8c4db680008bd8aec536fc18b4a8"
  },
  "name": "AI招生审核：论文分析、综合评分与候选人排名",
  "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 聊天模型",
      "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": "## 📝 申请接收"
      },
      "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论文分析"
      },
      "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": "## 🎯 综合评审AI代理"
      },
      "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": "## 🌟 强烈录取路径"
      },
      "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": "## 🤔 委员会评审路径"
      },
      "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": "## ❌ 标准处理路径"
      },
      "typeVersion": 1
    },
    {
      "id": "c5436167-4d5e-40f7-8a5b-5edbebd86666",
      "name": "## 📊 财务分析与审计追踪",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        800,
        112
      ],
      "parameters": {
        "width": 392,
        "height": 348,
        "content": "## 📊 招生分析"
      },
      "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": {
    "Strong Admit?": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a message": {
      "main": [
        [
          {
            "node": "Email Admissions Director",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "JotForm Trigger": {
      "main": [
        [
          {
            "node": "Extract Application Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Essay Analysis": {
      "main": [
        [
          {
            "node": "AI Holistic Review Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Committee Review?": {
      "main": [
        [
          {
            "node": "Request Committee Review",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Standard Acknowledgment",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Holistic Review Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "AI Holistic Review Agent": {
      "main": [
        [
          {
            "node": "Strong Admit?",
            "type": "main",
            "index": 0
          },
          {
            "node": "Committee Review?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Application Data": {
      "main": [
        [
          {
            "node": "AI Essay Analysis",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Request Committee Review": {
      "main": [
        [
          {
            "node": "Send Acknowledgment Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "AI Holistic Review Agent",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Email Admissions Director": {
      "main": [
        [
          {
            "node": "Send Interview Invitation",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Acknowledgment Email": {
      "main": [
        [
          {
            "node": "Log to Admissions Database",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Interview Invitation": {
      "main": [
        [
          {
            "node": "Log to Admissions Database",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Standard Acknowledgment": {
      "main": [
        [
          {
            "node": "Log to Admissions Database",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}