AI 招聘省时助手 - 自动化筛选、评估、提醒和面试

• •Slack Bot Token 或 Webhook URL
• •Google Drive API 凭证
• •Google Sheets API 凭证
• •OpenAI API Key

{
  "meta": {
    "instanceId": "b0c38aaab6bebe08413b40e26aa2ee99136cd8edfd3a296014b1e2af1b2d5383"
  },
  "nodes": [
    {
      "id": "8a152592-2259-4884-92dc-6e23158bf58f",
      "name": "表单提交时",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        280,
        420
      ],
      "webhookId": "2a87705d-8ba1-41f1-80ef-85f364ce253e",
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "eda2a030-df56-4989-9986-2d6837b71c78",
      "name": "从文件提取",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        680,
        420
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6a848708-0a9b-4bbf-bcf7-4f7195e6196d",
      "name": "多表：您可以连接多个表以实现有组织的数据结构",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        2960,
        560
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "da721ba9-e799-4eb0-8d5f-d65eec959cbe",
      "name": "上传简历",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        680,
        220
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "f989cbb1-4eb8-4c77-ac03-5f5703afbc76",
      "name": "OpenAI",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1700,
        780
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "e7b5b83c-042c-445c-869d-06d18aaba7d8",
      "name": "申请人详情",
      "type": "@n8n/n8n-nodes-langchain.informationExtractor",
      "position": [
        1320,
        420
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "8a537b27-4418-406b-a204-04249295298a",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        280
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ca220bd7-6621-4920-b9ea-47ed338fd0e9",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        560,
        0
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "8405dc04-3d99-45f0-a93b-2343e7ad5583",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        920,
        240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e66f542e-2a8d-46ee-95df-aa2655b12be4",
      "name": "在 Google Sheets 中添加申请人详情",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1040,
        420
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "d04a0c55-546d-41aa-91c5-c9fe0941981b",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1280,
        240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e90fc56b-7878-46f3-a079-e95dab695f9f",
      "name": "总结申请人资料",
      "type": "@n8n/n8n-nodes-langchain.chainSummarization",
      "position": [
        1680,
        420
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "d9c3773a-daa4-4f71-970d-d4d7ea2ddbf3",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1640,
        240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "22b9732c-82b9-4eba-b195-62fd08744cce",
      "name": "从 Google Sheets 获取职位描述",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2120,
        420
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "664e0387-c69b-4f4a-a431-db2e9fc98d3f",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2000,
        240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e7dbb219-28da-40d4-806b-ff44be167cc4",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2360,
        240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ce417cff-854e-4e5b-8ff8-966f132fa07e",
      "name": "总结职位角色描述",
      "type": "@n8n/n8n-nodes-langchain.chainSummarization",
      "position": [
        2400,
        420
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "3c684c15-bfc4-48ca-990f-c8bb12bb809a",
      "name": "HR专家语义匹配与评估",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        2760,
        420
      ],
      "parameters": {},
      "typeVersion": 1.5
    },
    {
      "id": "6940c4b0-b6b3-4e69-9203-a5c298ed77da",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2720,
        140
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c43f554f-4d28-407e-aa32-164af6be244e",
      "name": "在 Google Sheets 中更新评估结果",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2120,
        900
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "bcde088b-7689-42e5-9cdc-7bedd070ccd8",
      "name": "便签8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2000,
        720
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "4190f1dc-88f2-4b97-bc2d-3cbb94e687c4",
      "name": "便签9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2360,
        720
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0e84b074-633a-4b45-8150-c8e734adcdf6",
      "name": "通过邮件通知招聘专员审批",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        2480,
        900
      ],
      "webhookId": "6941e6ef-63b6-43f9-8911-32fdd84d13fe",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "73b71de6-ea39-456b-8c39-c4debef14f5f",
      "name": "审批检查 - IF 条件",
      "type": "n8n-nodes-base.if",
      "position": [
        2840,
        900
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "aa7c8080-62a9-47e8-90e1-35594164ac7d",
      "name": "便签 10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2720,
        720
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2c6d927f-d7e2-4a61-aef1-6f0eb0273792",
      "name": "便签 11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3520,
        320
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2abddb6e-c726-4610-9cb4-3acf1f6e2b18",
      "name": "向候选人发送入围邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        3620,
        500
      ],
      "webhookId": "5b12b59d-c5b3-44b4-8359-e69ce6401120",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "0adc3251-c510-4ec8-8cb3-38200ac9cfa8",
      "name": "向候选人发送拒绝邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        3620,
        920
      ],
      "webhookId": "5b12b59d-c5b3-44b4-8359-e69ce6401120",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "0eb1fa6a-f927-4dcf-90b6-82a5c75d09e5",
      "name": "便签12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3520,
        740
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "f0f37e05-5b00-42bb-aa9d-80a1855791a6",
      "name": "便签14",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3120,
        300
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "72ba03a4-5dd8-4d42-b2f4-3adee73df626",
      "name": "将申请人状态更新为已拒绝",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3240,
        920
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "81b96523-426f-4d78-bf48-ded4df362faa",
      "name": "便签15",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3120,
        740
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "cc11a04b-543d-44a7-9f24-31fe71307e2c",
      "name": "每日09:00运行",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        100,
        920
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "bd500d66-fb06-405e-b278-dc570d7f5da5",
      "name": "获取状态为\"简历已选\"的记录",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        320,
        920
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "c1c21c4b-03bc-49a9-a1a3-5bcf9d20931b",
      "name": "循环向每位候选人发送评估链接",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        580,
        920
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "7037b68b-4b0b-447f-b51f-be8039995ed7",
      "name": "获取评估表单 URL",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        880,
        940
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "3e155bf1-b5eb-4c86-aa9b-5b7773be15eb",
      "name": "发送评估提交邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        1160,
        940
      ],
      "webhookId": "92dfdc70-ac6d-468d-ae75-fb2c42b8a554",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "585c6022-b645-480f-a2d9-99a114609fbc",
      "name": "将状态更新为评估已发送",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1440,
        940
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "9930d8fd-a3fa-43a1-9a8c-1bef8876cb61",
      "name": "便签17",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        720
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "7e40f8fa-df27-418e-9dc6-3cc73202feea",
      "name": "技术支持工程师评估触发器",
      "type": "n8n-nodes-base.typeformTrigger",
      "position": [
        140,
        1580
      ],
      "webhookId": "5d14bba3-737d-432a-b426-ecba0826e30a",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "675b08ff-2a53-45fc-ba61-c21657b0d123",
      "name": "技术项目经理评估触发器",
      "type": "n8n-nodes-base.typeformTrigger",
      "position": [
        140,
        1360
      ],
      "webhookId": "5d14bba3-737d-432a-b426-ecba0826e30a",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "c35f75d4-eac8-42b6-8a18-7e7643c4c51e",
      "name": "将申请人状态更新为评估已提交",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        420,
        1460
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "f32d787a-36b6-4cbf-aee1-1e7bc261092a",
      "name": "通过邮件通知招聘专员评估提交",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        740,
        1360
      ],
      "webhookId": "92dfdc70-ac6d-468d-ae75-fb2c42b8a554",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "1dbd8726-60ad-4367-aa61-3dbdd1868cbf",
      "name": "通过 Slack 通知招聘专员评估提交",
      "type": "n8n-nodes-base.slack",
      "disabled": true,
      "position": [
        740,
        1580
      ],
      "webhookId": "39e62d5a-b2e4-4912-a8d7-be43e1fe780f",
      "parameters": {},
      "typeVersion": 2.3
    },
    {
      "id": "2ce49266-9987-4e2d-91ed-a8b570f44af2",
      "name": "当申请人在 calendly 中预订面试时触发",
      "type": "n8n-nodes-base.calendlyTrigger",
      "position": [
        560,
        1880
      ],
      "webhookId": "b138a41c-e292-4533-8b02-7a3fea7b73e3",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "1d27e489-0d47-4cb7-a4c6-6cc75f410302",
      "name": "将状态更新为面试已预订",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        780,
        1880
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "cfe93e15-863b-447d-826c-3f319fec28ba",
      "name": "当 Google Sheet 中申请人状态更新时触发",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        1240,
        1720
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "5ff66e2e-c71d-48cc-bf66-df4d4c616569",
      "name": "基于状态路由操作",
      "type": "n8n-nodes-base.switch",
      "position": [
        1480,
        1640
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "de0fac71-bf7f-4196-8126-d612805df08f",
      "name": "发送面试邀请邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        1860,
        1360
      ],
      "webhookId": "92dfdc70-ac6d-468d-ae75-fb2c42b8a554",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "74f4cffe-d362-4aa6-984a-67dca1479186",
      "name": "发送评估失败邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        2080,
        1440
      ],
      "webhookId": "92dfdc70-ac6d-468d-ae75-fb2c42b8a554",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "97383a17-8065-453c-8399-e8481a6608ac",
      "name": "发送面试取消邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        2260,
        1600
      ],
      "webhookId": "92dfdc70-ac6d-468d-ae75-fb2c42b8a554",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "b2735319-d17a-4eed-9385-412a1df5725c",
      "name": "面试重新安排邀请邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        2120,
        1740
      ],
      "webhookId": "92dfdc70-ac6d-468d-ae75-fb2c42b8a554",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "c343af76-bf0c-436d-9d07-06a2049b99fe",
      "name": "发送面试通过/入围邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        1980,
        1860
      ],
      "webhookId": "92dfdc70-ac6d-468d-ae75-fb2c42b8a554",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "9fac2c36-bcec-4a40-a68e-0d359fa1ebf8",
      "name": "发送面试失败邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        1800,
        1960
      ],
      "webhookId": "92dfdc70-ac6d-468d-ae75-fb2c42b8a554",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "5fb01de0-215b-4d6f-ab4a-b7414c5ad24c",
      "name": "无操作，不执行任何动作",
      "type": "n8n-nodes-base.noOp",
      "position": [
        880,
        780
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "1e5241e3-cc08-487d-a82d-b8005fb73091",
      "name": "便签 16",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        1200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6ed12099-5d4d-41d5-884d-c1e3723e877c",
      "name": "便签18",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        140,
        1840
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "636939ce-caef-4a1c-918b-5dffd681b941",
      "name": "便签19",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1060,
        1200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e6227def-3091-4b16-a573-dbe12a02d68a",
      "name": "便签20",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -560,
        140
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fc0eabbb-0cfe-49fd-9fef-ff6d6afd4681",
      "name": "将申请人状态更新为简历已选",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3240,
        500
      ],
      "parameters": {},
      "typeVersion": 4.5
    }
  ],
  "pinData": {
    "Extract from File": [
      {
        "info": {
          "Title": "",
          "Creator": "wkhtmltopdf 0.12.6",
          "Language": null,
          "Producer": "Qt 4.8.7",
          "CreationDate": "D:20250215092349+05'30'",
          "IsLinearized": false,
          "IsXFAPresent": false,
          "PDFFormatVersion": "1.4",
          "EncryptFilterName": null,
          "IsAcroFormPresent": false,
          "IsCollectionPresent": false,
          "IsSignaturesPresent": false
        },
        "text": "Test Applicant\nAssociate Project Manager\n6 Years 9 Months (+91) 9999999999 applicant@gma\nil.com\nProfile Summary\nTechnical Associate Project Manager | AI & Automation | Digital\nTransformation\nExperienced Technical Associate Project Manager with 7+ years of\nexperience in workflow automation, AI solutions, database\nmanagement, and process optimization.\nProficient in MongoDB, MySQL, Microsoft Excel, REST APIs, and\nlow-code platforms, with hands-on experience in designing\nflowcharts, wireframes, and automation workflows to streamline\nbusiness operations. Strong background in managing projects\nrelated to custom software development, system integrations,\nand SaaS solutions, ensuring smooth execution from ideation to\ndeployment.\nCurrently leading an AI-powered WhatsApp support solution,\nutilizing LLMs, RAG frameworks, and automation to enhance\ncustomer interactions. Passionate about digital transformation,\nproblem-solving, and optimizing business processes with\nemerging technologies.\nOpen to collaborations that drive efficiency, innovation, and\ncustomer experience improvements.\nEducation\nWork Experience\nJun 2021 - Present\nKey skills\nAnalytical Skills\nWaterfall Methodology\nAgile Methodology\nSDLC Life Cycle\nTechnical Analysis\nWireframing\nWorkflow\nProcess Flow Charts\nTeam Management\nLeadership\nProblem Analysis\nProblem Solving\nAdaptability\nLearnability\nBusiness Analysis\nMS Office\nMongo DB Basics\nMockups\nArtificial Intelligence\nFine Tuning\nRAG Framework\nAI Agents Creation\nAi Platform\nAi Techniques\nAi Solutions\nAi Builder\nPersonal Information\nCity \nGurugram\nMCA, 2021\nJayoti Vidyapeeth Women\nUniversity\nBCA, 2017\nUniversity of Rajasthan,\nJaipur\n12th, 2014\nRajasthan, English\n10th, 2012\nRajasthan, English\n\nAssociate Project Manager\nNimbuspost\nAs an Associate Project Manager at My company, I oversee\nend-to-end project execution, ensuring timely delivery within scope\nand budget. I develop detailed plans, manage resources, and address\nrisks to keep projects on track. Acting as the key liaison between\nclients, vendors, and teams, I foster seamless communication and\ncollaboration to align projects with business goals.\nI lead cross-functional teams, providing mentorship and feedback to\nenhance performance and productivity. Leveraging project\nmanagement tools, I implement process improvements to streamline\nworkflows and optimize resource utilization. My efforts drive\nsuccessful project outcomes, contributing to business growth and\nclient satisfaction.\nJul 2020 - Jun 2021\nERP Coordinator\nUnited Plywood\nAs an ERP Coordinator at My company, I streamlined ERP processes\nby gathering stakeholder requirements and collaborating with third-\nparty developers to ensure timely delivery. I facilitated seamless ERP\nintegration across departments, enhancing functionality and\noperational efficiency organization-wide.\nNov 2017 - Jun 2020\nProject Coordinator\n My company\n- Orchestrated the company's business processes using ERP and CRM.\n- Conducted research and development for implementing new\ntechnologies to enhance business processes.\n- Executed SMS marketing strategies to reach out to potential\ncustomers.\n- Coordinated and managed IT support tasks to ensure smooth\noperations.\nProjects\n10 Months\nWarehouse Management System\nDeveloped and implemented a Warehouse Management System,\nreducing inventory errors by 15% and improving overall efficiency.\nLed a 5-member cross-functional team in the successful completion\nof a 10-month long Warehouse Management System project.\nUtilized lean principles to streamline warehouse processes, resulting\nin a 20% reduction in operational costs over a period of 10 months.\n2 Months\nFinance Analytics Tool\nDeveloped a finance analytics tool over a 2-month period, resulting\nin increase in data analysis efficiency and reduction in time spent on\nfinancial reporting.\nImplemented advanced financial modeling techniques in the creation\nCountry \nINDIA\nLanguages\nHindi\nEnglish\n\nof a finance analytics tool, leading to improvement in forecasting\naccuracy and reduction in errors in financial data analysis.\nLed a project team in the development of a finance analytics tool,\ncontributing to a increase in overall team productivity and a\nsuccessful project completion within a tight 2-month deadline.\n14 Months\nCall Center System for Outbound Calling (Internal)\nDeveloped an internal call center system to optimize outbound calling\ncampaigns, integrating advanced features such as IVR tools, agent\nmanagement modules, unique IVR numbers for agents, and\ncustomizable fields. The system streamlined operations through API\nand webhook integrations.\nPlanned the project, gathered requirements, and defined scope.\nLed a cross-functional team to design, develop, and deploy the\nsystem.\nStructured and managed the database to ensure scalability and\nefficiency.\nConducted manual testing for quality assurance.\nDelivered training and ongoing support to ensure successful\nadoption.\n6 Months\nLogistics Management Allcoation Engine Microservice\nManaged the development of the Allocation Engine Microservice for\nClient CRED, designed to handle high traffic and streamline logistics\noperations.\nLed the creation of a microservice for shipment booking, tracking,\nand webhook management.\nDesigned and implemented an allocation system to distribute\nrequests based on percentages, optimizing resource usage.\nOversaw the integration of third-party APIs to enhance functionality\nand improve system efficiency.\nCoordinated cross-functional teams to ensure scalability and high-\nperformance under heavy traffic conditions.\nDelivered a robust microservice architecture that improved shipment\nmanagement and operational efficiency.\nDesigned a front end panel to oversee the data and reports as\nrequired.\n2 Months\nAI-Powered Whatsapp Support Solution\nDeveloped an AI-Powered Whatsapp Support Solution, resulting in a\n30% reduction in customer query response time.\nImplemented RAG Framework to provide more accurate & concise\nresponse to customer queries.\nImplemented advanced machine learning algorithms to analyze\n\ncustomer queries, leading to a 20% increase in first-call query\nresolution.\nCollaborated with cross-functional teams to successfully launch the\nAI-powered solution within a strict 2-month timeline, exceeding\nproject milestones.",
        "version": "2.16.105",
        "numpages": 4,
        "numrender": 4
      }
    ],
    "Applicant's Details": [
      {
        "output": {
          "City": "Gurugram",
          "Skills": "- MongoDB\n- MySQL\n- Microsoft Excel\n- REST APIs\n- Low-code platforms\n- Workflow automation\n- AI solutions\n- Project management tools\n- Business Analysis\n- Leadership",
          "Job History": "Currently an Associate Project Manager at My Company, overseeing project execution and cross-functional teams. Previously, an ERP Coordinator at my company, streamlining ERP processes, and a Project Coordinator at my company, managing business processes and IT support.",
          "Educational Qualification": "MCA, 2021 from Jayoti Vidyapeeth Women University; BCA, 2017 from University of Rajasthan, Jaipur; 12th, 2014 from Rajasthan, English; 10th, 2012 from Rajasthan, English."
        }
      }
    ],
    "Get Assessment Form URL": [
      {
        "Job Id": 4,
        "Location": "Gurugram",
        "Department": "Tech",
        "Experience": "6+ Years",
        "row_number": 5,
        "Job Profile": "Technical Project Manager",
        "Job Description": "Job Summary:\nWe are looking for a skilled Technical Project Manager to manage software development projects, coordinate with stakeholders, and ensure successful project delivery. You will be responsible for planning, execution, and tracking of technical projects.\n\nKey Responsibilities:\nDefine project scope, timelines, and resource allocation.\n\nLead cross-functional teams including developers, QA, and designers.\n\nIdentify risks, develop mitigation strategies, and ensure timely delivery.\n\nConduct project status meetings and provide regular updates to stakeholders.\n\nImplement Agile, Scrum, or Waterfall methodologies as required.\n\nManage client communications and handle expectations effectively.\n\nEnsure adherence to project quality standards and compliance.\n\nRequired Qualifications:\nBachelor’s/Master’s degree in Computer Science, IT, or related field.\n\n6+ years of experience in software project management.\n\nStrong technical background with hands-on development understanding.\n\nExcellent project planning, risk management, and leadership skills.\n\nProficiency in project management tools (JIRA, Trello, Asana, MS Project).\n\nExperience managing multiple projects simultaneously.\n\nExcellent verbal and written communication skills.\n\nPreferred Skills (Good to Have):\nProject Management certifications like PMP, PRINCE2, or Certified Scrum Master (CSM).\n\nExperience with DevOps and CI/CD processes.\n\nExposure to cloud technologies and SaaS platforms.\n\nKnowledge of financial management of projects (budgets, cost control).",
        "Assesment Form URL": "form url"
      }
    ],
    "Summarize Applicant's Profile": [
      {
        "response": {
          "text": "Test Applicant, based in Gurugram, holds an MCA (2021) from Jayoti Vidyapeeth Women University and a BCA (2017) from the University of Rajasthan. He currently works as an Associate Project Manager at My Company, managing projects and cross-functional teams. Previously, he served as an ERP Coordinator at my company and as a Project Coordinator at my company. Test applicant is skilled in MongoDB, MySQL, Microsoft Excel, REST APIs, low-code platforms, and AI solutions, alongside expertise in project management and business analysis. You can reach him at applicant@gmail.com or 84938493894."
        }
      }
    ],
    "Summarize Job Role Description": [
      {
        "response": {
          "text": "We're seeking a Technical Project Manager in Gurugram with over 6 years of software project management experience. You’ll lead cross-functional teams, define project scopes, and ensure timely delivery using Agile, Scrum, or Waterfall methodologies. Strong technical understanding and proficiency in tools like JIRA and MS Project are essential. Excellent communication and risk management skills are a must. A degree in Computer Science or related fields is required, along with preferred certifications (PMP, CSM). Experience with DevOps, cloud technologies, and project financial management is a definite plus. Join us to drive successful software development projects!"
        }
      }
    ],
    "Notify TA for Approval via Email": [
      {
        "data": {
          "approved": true
        }
      }
    ],
    "Send Assessment Submission Email": [
      {
        "ehlo": [
          "SIZE 35882577",
          "8BITMIME",
          "AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH",
          "ENHANCEDSTATUSCODES",
          "PIPELINING",
          "CHUNKING",
          "SMTPUTF8"
        ],
        "accepted": [
          "applicant@gmail.com"
        ],
        "envelope": {
          "to": [
            "applicant@gmail.com"
          ],
          "from": "admin@example.com"
        },
        "rejected": [],
        "response": "250 2.0.0 OK  tste1 - gsmtp",
        "messageId": "<9a29fe90-restbcb@gmail.com>",
        "messageSize": 1351,
        "messageTime": 421,
        "envelopeTime": 164
      }
    ],
    "Update Status to Assessment Sent": [
      {
        "EMAIL": "applicant@gmail.com",
        "STATUS": "ASSESSMENT SENT",
        "LAST UPDATED DATE": "08-06-2025 04:22:57"
      }
    ],
    "Send Shortlist Email to Candidate": [
      {
        "ehlo": [
          "SIZE 35882577",
          "8BITMIME",
          "AUTH LOGIN PLAIN XOAUTH2 PLAIN-CLIENTTOKEN OAUTHBEARER XOAUTH",
          "ENHANCEDSTATUSCODES",
          "PIPELINING",
          "CHUNKING",
          "SMTPUTF8"
        ],
        "accepted": [
          "applicant@gmail.com"
        ],
        "envelope": {
          "to": [
            "applicant@gmail.com"
          ],
          "from": "admin@example.com"
        },
        "rejected": [],
        "response": "250 2.0.0 OK  test9.33 - gsmtp",
        "messageId": "test@gmail.com>",
        "messageSize": 1285,
        "messageTime": 391,
        "envelopeTime": 159
      }
    ],
    "Get Job Description from Google Sheets": [
      {
        "Job Id": 4,
        "Location": "Gurugram",
        "Department": "Tech",
        "Experience": "6+ Years",
        "row_number": 5,
        "Job Profile": "Technical Project Manager",
        "Job Description": "Job Summary:\nWe are looking for a skilled Technical Project Manager to manage software development projects, coordinate with stakeholders, and ensure successful project delivery. You will be responsible for planning, execution, and tracking of technical projects.\n\nKey Responsibilities:\nDefine project scope, timelines, and resource allocation.\n\nLead cross-functional teams including developers, QA, and designers.\n\nIdentify risks, develop mitigation strategies, and ensure timely delivery.\n\nConduct project status meetings and provide regular updates to stakeholders.\n\nImplement Agile, Scrum, or Waterfall methodologies as required.\n\nManage client communications and handle expectations effectively.\n\nEnsure adherence to project quality standards and compliance.\n\nRequired Qualifications:\nBachelor’s/Master’s degree in Computer Science, IT, or related field.\n\n6+ years of experience in software project management.\n\nStrong technical background with hands-on development understanding.\n\nExcellent project planning, risk management, and leadership skills.\n\nProficiency in project management tools (JIRA, Trello, Asana, MS Project).\n\nExperience managing multiple projects simultaneously.\n\nExcellent verbal and written communication skills.\n\nPreferred Skills (Good to Have):\nProject Management certifications like PMP, PRINCE2, or Certified Scrum Master (CSM).\n\nExperience with DevOps and CI/CD processes.\n\nExposure to cloud technologies and SaaS platforms.\n\nKnowledge of financial management of projects (budgets, cost control).",
        "Assesment Form URL": "{type form url}"
      }
    ],
    "Semantic Fit & Evaluation by HR Expert": [
      {
        "output": {
          "red_flags": {
            "consideration": "The candidate's employment history appears coherent, with no sign of job-hopping or inconsistencies in timelines.",
            "issues_detected": [
              "None"
            ]
          },
          "soft_skills": [
            "Teamwork",
            "Communication"
          ],
          "semantic_fit": {
            "score": "65%",
            "key_gaps": [
              "Lacks direct experience with Agile, Scrum, or Waterfall methodologies as specified",
              "No experience mentioned with tools like JIRA or MS Project",
              "Missing strong technical background in software development or cloud technologies"
            ],
            "key_matches": [
              "Experience as Associate Project Manager managing projects",
              "Proficiency in project management",
              "Experience with cross-functional teams"
            ],
            "consideration": "The candidate has relevant project management experience but lacks specific methodologies and certain technical skills listed in the JD."
          },
          "overall_evaluation": {
            "final_vote": "5",
            "consideration": "The candidate partially matches the requirements set by the company with relevant project management experience and ability to lead teams. However, significant gaps exist in specified methodologies and tools. Soft skills such as teamwork and communication seem strong, while their background and experience are appropriate, they lack some key qualifications needed for this role, resulting in a neutral score reflecting a moderate fit."
          },
          "experience_analysis": {
            "consideration": "The candidate's career path reflects continuous growth in project roles without any significant employment gaps, indicating a stable employment history.",
            "experience_gap_detected": "No",
            "overqualification_detected": "No"
          }
        }
      }
    ],
    "Add Applicant's Details in Google Sheet": [
      {
        "DATE": "08-06-2025",
        "NAME": "Test Applicant",
        "EMAIL": "applicant@gmail.com",
        "PHONE": 84938493894,
        "STATUS": "CV SUBMITTED",
        "JOB PROFILE": "Technical Project Manager",
        "LINKEDIN URL": "",
        "LAST UPDATED DATE": "08-06-2025 03:50:18"
      }
    ],
    "Update Evaluation Results in Google Sheets": [
      {
        "CITY": "Gurugram",
        "VOTE": "",
        "EMAIL": "applicant@gmail.com",
        "SKILLS": "- MongoDB\n- MySQL\n- Microsoft Excel\n- REST APIs\n- Low-code platforms\n- Workflow automation\n- AI solutions\n- Project management tools\n- Business Analysis\n- Leadership",
        "STATUS": "CV SCORED",
        "KEY GAPS": "[\"Lacks strong technical skills in JIRA and MS Project\",\"No experience mentioned with Agile, Scrum, or Waterfall methodologies\",\"Does not have PMP or CSM certifications\",\"Experience with DevOps, cloud technologies, or project financial management is not mentioned\"]",
        "SUMMARIZE": "Aayushman, based in Gurugram, holds an MCA (2021) from Jayoti Vidyapeeth Women University and a BCA (2017) from the University of Rajasthan. He currently works as an Associate Project Manager at Nimbuspost, managing projects and cross-functional teams. Previously, he served as an ERP Coordinator at United Plywood and as a Project Coordinator at Aask Education. Aayushman is skilled in MongoDB, MySQL, Microsoft Excel, REST APIs, low-code platforms, and AI solutions, alongside expertise in project management and business analysis. You can reach him at ajfreelance0411@gmail.com or 84938493894.",
        "EDUCATIONAL": "MCA, 2021 from Jayoti Vidyapeeth Women University; BCA, 2017 from University of Rajasthan, Jaipur; 12th, 2014 from Rajasthan, English; 10th, 2012 from Rajasthan, English.",
        "JOB HISTORY": "Currently an Associate Project Manager at Nimbuspost, overseeing project execution and cross-functional teams. Previously, an ERP Coordinator at United Plywood, streamlining ERP processes, and a Project Coordinator at Aask Education, managing business processes and IT support.",
        "KEY MATCHES": "[\"Over 6 years of project management experience\",\"Currently working as an Associate Project Manager\",\"Experience in managing cross-functional teams\",\"Proficient in project management and business analysis\"]",
        "SOFT SKILLS": "[\"Teamwork\",\"Communication\",\"Leadership\"]",
        "LAST UPDATED DATE": "08-06-2025 04:06:10",
        "SEMANTIC FIT SCORE": "70%",
        "FINAL CONSIDERATION": "",
        "EXPERIENCE GAP DETECTED": "",
        "RED FLAGS CONSIDERATION": "There are no apparent red flags such as job-hopping or inconsistent timelines.",
        "RED FLAGS ISSUES DETECTED": [],
        "SEMANTIC FIT CONSIDERATION": "The candidate has relevant project management experience but lacks specific technical tools and methodologies mentioned in the JD.",
        "OVER QUALIFICATION DETECTED": "",
        "EXPERIENCE ANALYSIS CONSIDERATION": ""
      }
    ],
    "Fetch Records with Status \"Resume Selected\"": [
      {
        "CITY": "Gurugram",
        "DATE": "08/06/2025",
        "NAME": "test",
        "VOTE": "",
        "EMAIL": "applicant@gmail.com",
        "PHONE": 84938493894,
        "STATE": "",
        "SKILLS": "- MongoDB\n- MySQL\n- Microsoft Excel\n- REST APIs\n- Low-code platforms\n- Workflow automation\n- AI solutions\n- Project management tools\n- Business Analysis\n- Leadership",
        "STATUS": "RESUME SELECTED",
        "KEY GAPS": "[\"Lacks strong technical skills in JIRA and MS Project\",\"No experience mentioned with Agile, Scrum, or Waterfall methodologies\",\"Does not have PMP or CSM certifications\",\"Experience with DevOps, cloud technologies, or project financial management is not mentioned\"]",
        "SUMMARIZE": "Aayushman, based in Gurugram, holds an MCA (2021) from Jayoti Vidyapeeth Women University and a BCA (2017) from the University of Rajasthan. He currently works as an Associate Project Manager at Nimbuspost, managing projects and cross-functional teams. Previously, he served as an ERP Coordinator at United Plywood and as a Project Coordinator at Aask Education. Aayushman is skilled in MongoDB, MySQL, Microsoft Excel, REST APIs, low-code platforms, and AI solutions, alongside expertise in project management and business analysis.",
        "row_number": 2,
        "EDUCATIONAL": "MCA, 2021 from Jayoti Vidyapeeth Women University; BCA, 2017 from University of Rajasthan, Jaipur; 12th, 2014 from Rajasthan, English; 10th, 2012 from Rajasthan, English.",
        "JOB HISTORY": "Currently an Associate Project Manager at Nimbuspost, overseeing project execution and cross-functional teams. Previously, an ERP Coordinator at United Plywood, streamlining ERP processes, and a Project Coordinator at Aask Education, managing business processes and IT support.",
        "JOB PROFILE": "Technical Project Manager",
        "KEY MATCHES": "[\"Over 6 years of project management experience\",\"\"]",
        "SOFT SKILLS": "[\"Teamwork\",\"Communication\",\"Leadership\"]",
        "LINKEDIN URL": "",
        "LAST UPDATED DATE": "06/08/2025 04:20:10",
        "SEMANTIC FIT SCORE": 0.7,
        "FINAL CONSIDERATION": "",
        "EXPERIENCE GAP DETECTED": "",
        "RED FLAGS CONSIDERATION": "There are no apparent red flags such as job-hopping or inconsistent timelines.",
        "RED FLAGS ISSUES DETECTED": "[]",
        "SEMANTIC FIT CONSIDERATION": "The candidate has relevant project management experience but lacks specific technical tools and methodologies mentioned in the JD.",
        "OVER QUALIFICATION DETECTED": "",
        "EXPERIENCE ANALYSIS CONSIDERATION": ""
      }
    ],
    "Update Applicant's Status as RESUME SELECTED": [
      {
        "EMAIL": "applicant@gmail.com",
        "STATUS": "RESUME SELECTED",
        "LAST UPDATED DATE": "08-06-2025 04:20:10"
      }
    ]
  },
  "connections": {
    "OpenAI": {
      "ai_languageModel": [
        [
          {
            "node": "Applicant's Details",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "Summarize Applicant's Profile",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "Semantic Fit & Evaluation by HR Expert",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "Summarize Job Role Description",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Extract from File": {
      "main": [
        [
          {
            "node": "Add Applicant's Details in Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "On form submission": {
      "main": [
        [
          {
            "node": "Upload CV",
            "type": "main",
            "index": 0
          },
          {
            "node": "Extract from File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Applicant's Details": {
      "main": [
        [
          {
            "node": "Summarize Applicant's Profile",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Run Daily at 09:00 AM": {
      "main": [
        [
          {
            "node": "Fetch Records with Status \"Resume Selected\"",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Assessment Form URL": {
      "main": [
        [
          {
            "node": "Send Assessment Submission Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Semantic Fit & Evaluation by HR Expert",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Approval Check - IF Condition": {
      "main": [
        [
          {
            "node": "Update Applicant's Status as RESUME SELECTED",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Update Applicant's Status as REJECTED",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Route actions based on Status": {
      "main": [
        [
          {
            "node": "Send Interview Invite Email",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Assessment Failed Email",
            "type": "main",
            "index": 0
          }
        ],
        [],
        [
          {
            "node": "Send Interview Cancelled Email",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Interview Reschedule Invite Email",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Interview Passed/Shortlisted Email",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Interview Failed Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Summarize Applicant's Profile": {
      "main": [
        [
          {
            "node": "Get Job Description from Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Summarize Job Role Description": {
      "main": [
        [
          {
            "node": "Semantic Fit & Evaluation by HR Expert",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Notify TA for Approval via Email": {
      "main": [
        [
          {
            "node": "Approval Check - IF Condition",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Assessment Submission Email": {
      "main": [
        [
          {
            "node": "Update Status to Assessment Sent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Status to Assessment Sent": {
      "main": [
        [
          {
            "node": "Loop to Send Assessment Link to Each Candidate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Applicant's Status as REJECTED": {
      "main": [
        [
          {
            "node": "Send Rejection Email to Candidate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Job Description from Google Sheets": {
      "main": [
        [
          {
            "node": "Summarize Job Role Description",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Semantic Fit & Evaluation by HR Expert": {
      "main": [
        [
          {
            "node": "Update Evaluation Results in Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add Applicant's Details in Google Sheet": {
      "main": [
        [
          {
            "node": "Applicant's Details",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Evaluation Results in Google Sheets": {
      "main": [
        [
          {
            "node": "Notify TA for Approval via Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Records with Status \"Resume Selected\"": {
      "main": [
        [
          {
            "node": "Loop to Send Assessment Link to Each Candidate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Technical Project Manager Assessment Trigger": {
      "main": [
        [
          {
            "node": "Update Applicant Status to Assessment Submitted",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Applicant's Status as RESUME SELECTED": {
      "main": [
        [
          {
            "node": "Send Shortlist Email to Candidate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Technical Support Engineer Assessment Trigger": {
      "main": [
        [
          {
            "node": "Update Applicant Status to Assessment Submitted",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop to Send Assessment Link to Each Candidate": {
      "main": [
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Get Assessment Form URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Applicant Status to Assessment Submitted": {
      "main": [
        [
          {
            "node": "Notify TA via Email for Assessment Submission",
            "type": "main",
            "index": 0
          },
          {
            "node": "Notify TA via Slack for Assessment Submission",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Trigger when Interview booked by applicant in calendly": {
      "main": [
        [
          {
            "node": "Update Status to Interview Booked",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Triggered when Applicant Status Update in Google Sheet": {
      "main": [
        [
          {
            "node": "Route actions based on Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}