AI採用アシスタント

• •Googleアカウント + Gmail API認証情報
• •Google Sheets API認証情報
• •Google Gemini API Key

{
  "id": "qayGRtfzMMxmzYDz",
  "meta": {
    "instanceId": "061ca141d020a6e1355b8c7fe05f92a699e37e92079ad2e150a506ee8bbe9e11"
  },
  "name": "AI Hiring Agent",
  "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": "## Start here: Step-by Step Youtube Tutorial :star:\n[![I Built an Auto Lead Finder AI Agent](https://img.youtube.com/vi/5bXPl3ud-VA/sddefault.jpg)](https://youtu.be/5bXPl3ud-VA)"
      },
      "typeVersion": 1
    },
    {
      "id": "4261dce8-1819-4b11-8651-f660cf621389",
      "name": "付箋",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1136,
        256
      ],
      "parameters": {
        "width": 656,
        "height": 688,
        "content": "\n---\n\n# 🛠 Setup Guide\n\nFollow these steps to get started:\n\n1. **Set up the Hiring Form**\n   Customize the form fields (Name, Email Address, Job Role, Resume) in the **Form Trigger** node. This is how candidates will submit their applications.\n\n2. **Configure the Resume Extractor**\n   The **Extract from File** node is already set to process PDFs. Ensure applicants only upload `.pdf` resumes.\n\n3. **Add your [Google Gemini](https://aistudio.google.com/apikey) credentials**\n   Gemini powers the AI evaluation in the **AI Agent** node, scoring resumes, assigning Accepted/Rejected status, and generating emails.\n\n4. **Connect your [Gmail](https://mail.google.com/) account**\n   In the **Gmail** node, authorize your Gmail account via OAuth2 so the workflow can send acceptance/rejection emails to candidates automatically.\n\n5. **Connect your [Google Sheets](https://docs.google.com/spreadsheets/)**\n   Link the sheet in the **Google Sheets** node. Ensure your sheet has columns for Name, Job, Score, Status, Email, and Email Status to track all applications.\n\n6. **Customize Email Templates**\n   Edit the AI system message in the **AI Agent** node to refine acceptance and rejection email wording (e.g., change start date, tone, or branding).\n\nOnce all connections are set, your workflow will **collect applications, evaluate resumes, email candidates, and log results automatically** 🚀\n\n---"
      },
      "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": {
    "821f75ad-48ce-44cc-989a-5da5fcf2cc20": {
      "main": [
        [
          {
            "node": "430d1158-c0ca-4761-ac4f-37bc75e709e0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "87526f30-5696-4961-a9b3-63e563d684af": {
      "main": [
        [
          {
            "node": "63100817-7331-4dd7-a6c6-9151563ec47c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d0964d28-b384-4589-b375-a7d6ceba7787": {
      "ai_languageModel": [
        [
          {
            "node": "87526f30-5696-4961-a9b3-63e563d684af",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "63100817-7331-4dd7-a6c6-9151563ec47c",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "739b76a2-8e21-4bff-bf1a-92498e4327fd": {
      "main": [
        [
          {
            "node": "87526f30-5696-4961-a9b3-63e563d684af",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "51badbe5-a196-4d58-a80c-ea193988c0ac": {
      "main": [
        [
          {
            "node": "739b76a2-8e21-4bff-bf1a-92498e4327fd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "63100817-7331-4dd7-a6c6-9151563ec47c": {
      "main": [
        [
          {
            "node": "821f75ad-48ce-44cc-989a-5da5fcf2cc20",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}