AI招聘助手

• •Google 账号和 Gmail API 凭证
• •Google Sheets API 凭证
• •Google Gemini API Key

{
  "id": "qayGRtfzMMxmzYDz",
  "meta": {
    "instanceId": "061ca141d020a6e1355b8c7fe05f92a699e37e92079ad2e150a506ee8bbe9e11"
  },
  "name": "AI 招聘助手",
  "tags": [],
  "nodes": [
    {
      "id": "51badbe5-a196-4d58-a80c-ea193988c0ac",
      "name": "表单提交时",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -320,
        272
      ],
      "webhookId": "78e59dcf-52a0-45c9-99d8-4325d7b7cb2e",
      "parameters": {
        "options": {},
        "formTitle": "Apply For Executive Assistant at SAMSUNG",
        "formFields": {
          "values": [
            {
              "fieldLabel": "Name",
              "placeholder": "Full Name",
              "requiredField": true
            },
            {
              "fieldLabel": "Email Address",
              "placeholder": "example@anything.com",
              "requiredField": true
            },
            {
              "fieldType": "dropdown",
              "fieldLabel": "Job",
              "fieldOptions": {
                "values": [
                  {
                    "option": "Executive Assistant"
                  },
                  {
                    "option": "IT Specialist"
                  },
                  {
                    "option": "Manager"
                  }
                ]
              },
              "requiredField": true
            },
            {
              "fieldType": "file",
              "fieldLabel": "Resume",
              "multipleFiles": false,
              "requiredField": true,
              "acceptFileTypes": ".pdf"
            }
          ]
        },
        "formDescription": "Give your Info carefully"
      },
      "typeVersion": 2.2
    },
    {
      "id": "739b76a2-8e21-4bff-bf1a-92498e4327fd",
      "name": "从文件提取",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        -128,
        272
      ],
      "parameters": {
        "options": {},
        "operation": "pdf",
        "binaryPropertyName": "Resume"
      },
      "typeVersion": 1
    },
    {
      "id": "87526f30-5696-4961-a9b3-63e563d684af",
      "name": "AI 代理",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        64,
        272
      ],
      "parameters": {
        "text": "=Name: {{ $('On form submission').item.json.Name }}\nJob Name: {{ $('On form submission').item.json.Job }}\nResume: {{ $json.text }}",
        "options": {
          "systemMessage": "=You are a hiring agent for SAMSUNG. You will evaluate a candidate based on three inputs: the person's name, their job title, and their resume.\n\nYour task:\n1. Rate the resume out of 10 in terms of how suitable it is for the job title.\n2. Give a status: \"Accepted\" if score >= 7, else \"Rejected\".\n3. Generate an email:\n   - If \"Accepted\", write a short congratulatory email with the subject \"Congratulations on Joining Samsung!\" and mention the start date as 1st October 2026.\n   - If \"Rejected\", write a polite rejection email with the subject \"Regarding Your Application at Samsung\" in a soft and respectful tone.\n\nExample Output:\n\nScore: 8\nStatus: Accepted\nEmail: \n    Subject: Congratulations on Joining Samsung!\n    Body:\nDear Rakin Jakaria,\nWe are pleased to inform you that you have been selected for the position of Video Editor at Samsung. Your start date will be 1st October 2026.\nWelcome to the team!\n\nBest regards,\nSamsung HR Team"
        },
        "promptType": "define"
      },
      "typeVersion": 2
    },
    {
      "id": "63100817-7331-4dd7-a6c6-9151563ec47c",
      "name": "信息提取器",
      "type": "@n8n/n8n-nodes-langchain.informationExtractor",
      "position": [
        400,
        272
      ],
      "parameters": {
        "text": "={{ $json.output }}",
        "options": {},
        "attributes": {
          "attributes": [
            {
              "name": "Score",
              "type": "number",
              "required": true,
              "description": "the score"
            },
            {
              "name": "Status",
              "required": true,
              "description": "Accepted or Rejected"
            },
            {
              "name": "Mail Subject",
              "required": true,
              "description": "only the subject of the mail"
            },
            {
              "name": "Mail Body",
              "description": "the body of the mail without the subject"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "821f75ad-48ce-44cc-989a-5da5fcf2cc20",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        736,
        272
      ],
      "webhookId": "9ce2f294-f38c-4c4c-88c8-7828088511c5",
      "parameters": {
        "sendTo": "={{ $('On form submission').item.json['Email Address'] }}",
        "message": "={{ $json.output['Mail Body'] }}",
        "options": {
          "appendAttribution": false
        },
        "subject": "={{ $json.output['Mail Subject'] }}",
        "emailType": "text"
      },
      "typeVersion": 2.1
    },
    {
      "id": "430d1158-c0ca-4761-ac4f-37bc75e709e0",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        944,
        272
      ],
      "parameters": {
        "columns": {
          "value": {
            "Job": "={{ $('On form submission').item.json.Job }}",
            "Name": "={{ $('On form submission').item.json.Name }}",
            "Email": "={{ $('On form submission').item.json['Email Address'] }}",
            "Score": "={{ $('Information Extractor').item.json.output.Score }}",
            "Status": "={{ $('Information Extractor').item.json.output.Status }}",
            "Email Status": "SENT ✅"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Job",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Job",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Score",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Score",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 78682884,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1YBesKlPbUuWihzOjWx3wdtNZdo1VFKt6zyM6O4A8yWc/edit#gid=78682884",
          "cachedResultName": "Form responses 1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1YBesKlPbUuWihzOjWx3wdtNZdo1VFKt6zyM6O4A8yWc",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1YBesKlPbUuWihzOjWx3wdtNZdo1VFKt6zyM6O4A8yWc/edit?usp=drivesdk",
          "cachedResultName": "Candidate Details"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "dce89416-127c-4a93-9b08-8902cd4ccbb4",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1136,
        -160
      ],
      "parameters": {
        "width": 400,
        "height": 384,
        "content": "## 从这里开始：分步 YouTube 教程 :star:"
      },
      "typeVersion": 1
    },
    {
      "id": "4261dce8-1819-4b11-8651-f660cf621389",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1136,
        256
      ],
      "parameters": {
        "width": 656,
        "height": 688,
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d0964d28-b384-4589-b375-a7d6ceba7787",
      "name": "Google 2.5 Flash",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        240,
        544
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "googlePalmApi": {
          "id": "uIFmTaGcf3XXfitE",
          "name": "Google Gemini(PaLM) Api account 2"
        }
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "81acf62e-3d61-46b4-bc9d-1b1d29a3063e",
  "connections": {
    "Gmail": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent": {
      "main": [
        [
          {
            "node": "Information Extractor",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google 2.5 Flash": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "Information Extractor",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Extract from File": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "On form submission": {
      "main": [
        [
          {
            "node": "Extract from File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Information Extractor": {
      "main": [
        [
          {
            "node": "Gmail",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}