Zurück zu den Vorlagen
WORKFLOW-VORLAGE
On Form Submission 2 | Operasyon için n8n Otomasyon İş Akışı Şablonu (Google Sheets, Typeform, Slack)
n8n için hazır otomasyon şablonu: On Form Submission 2. 40 düğüm. Entegrasyonlar: Google Sheets, Typeform, Slack. JSON'u kopyalayıp n8n'e içe aktarın.
40 KnotenOn_Form_Submission_2-workflow.json
{"meta": {"instanceId": "b0c38aaab6bebe08413b40e26aa2ee99136cd8edfd3a296014b1e2af1b2d5383"},"nodes": [{"id": "8a152592-2259-4884-92dc-6e23158bf58f","name": "On form submission","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": "Extract from File","type": "n8n-nodes-base.extractFromFile","position": [680,420],"parameters": {},"typeVersion": 1},{"id": "6a848708-0a9b-4bbf-bcf7-4f7195e6196d","name": "Structured Output Parser","type": "@n8n/n8n-nodes-langchain.outputParserStructured","position": [2960,560],"parameters": {},"typeVersion": 1.2},{"id": "da721ba9-e799-4eb0-8d5f-d65eec959cbe","name": "Upload CV","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": "Applicant's Details","type": "@n8n/n8n-nodes-langchain.informationExtractor","position": [1320,420],"parameters": {},"typeVersion": 1},{"id": "8a537b27-4418-406b-a204-04249295298a","name": "Sticky Note","type": "n8n-nodes-base.stickyNote","position": [0,280],"parameters": {"content": ""},"typeVersion": 1},{"id": "ca220bd7-6621-4920-b9ea-47ed338fd0e9","name": "Sticky Note1","type": "n8n-nodes-base.stickyNote","position": [560,0],"parameters": {"content": ""},"typeVersion": 1},{"id": "8405dc04-3d99-45f0-a93b-2343e7ad5583","name": "Sticky Note2","type": "n8n-nodes-base.stickyNote","position": [920,240],"parameters": {"content": ""},"typeVersion": 1},{"id": "e66f542e-2a8d-46ee-95df-aa2655b12be4","name": "Add Applicant's Details in Google Sheet","type": "n8n-nodes-base.googleSheets","position": [1040,420],"parameters": {},"typeVersion": 4.5},{"id": "d04a0c55-546d-41aa-91c5-c9fe0941981b","name": "Sticky Note3","type": "n8n-nodes-base.stickyNote","position": [1280,240],"parameters": {"content": ""},"typeVersion": 1},{"id": "e90fc56b-7878-46f3-a079-e95dab695f9f","name": "Summarize Applicant's Profile","type": "@n8n/n8n-nodes-langchain.chainSummarization","position": [1680,420],"parameters": {},"typeVersion": 2},{"id": "d9c3773a-daa4-4f71-970d-d4d7ea2ddbf3","name": "Sticky Note4","type": "n8n-nodes-base.stickyNote","position": [1640,240],"parameters": {"content": ""},"typeVersion": 1},{"id": "22b9732c-82b9-4eba-b195-62fd08744cce","name": "Get Job Description from Google Sheets","type": "n8n-nodes-base.googleSheets","position": [2120,420],"parameters": {},"typeVersion": 4.5},{"id": "664e0387-c69b-4f4a-a431-db2e9fc98d3f","name": "Sticky Note5","type": "n8n-nodes-base.stickyNote","position": [2000,240],"parameters": {"content": ""},"typeVersion": 1},{"id": "e7dbb219-28da-40d4-806b-ff44be167cc4","name": "Sticky Note6","type": "n8n-nodes-base.stickyNote","position": [2360,240],"parameters": {"content": ""},"typeVersion": 1},{"id": "ce417cff-854e-4e5b-8ff8-966f132fa07e","name": "Summarize Job Role Description","type": "@n8n/n8n-nodes-langchain.chainSummarization","position": [2400,420],"parameters": {},"typeVersion": 2},{"id": "3c684c15-bfc4-48ca-990f-c8bb12bb809a","name": "Semantic Fit & Evaluation by HR Expert","type": "@n8n/n8n-nodes-langchain.chainLlm","position": [2760,420],"parameters": {},"typeVersion": 1.5},{"id": "6940c4b0-b6b3-4e69-9203-a5c298ed77da","name": "Sticky Note7","type": "n8n-nodes-base.stickyNote","position": [2720,140],"parameters": {"content": ""},"typeVersion": 1},{"id": "c43f554f-4d28-407e-aa32-164af6be244e","name": "Update Evaluation Results in Google Sheets","type": "n8n-nodes-base.googleSheets","position": [2120,900],"parameters": {},"typeVersion": 4.5},{"id": "bcde088b-7689-42e5-9cdc-7bedd070ccd8","name": "Sticky Note8","type": "n8n-nodes-base.stickyNote","position": [2000,720],"parameters": {"content": ""},"typeVersion": 1},{"id": "4190f1dc-88f2-4b97-bc2d-3cbb94e687c4","name": "Sticky Note9","type": "n8n-nodes-base.stickyNote","position": [2360,720],"parameters": {"content": ""},"typeVersion": 1},{"id": "0e84b074-633a-4b45-8150-c8e734adcdf6","name": "Notify TA for Approval via Email","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": "Approval Check - IF Condition","type": "n8n-nodes-base.if","position": [2840,900],"parameters": {},"typeVersion": 2.2},{"id": "aa7c8080-62a9-47e8-90e1-35594164ac7d","name": "Sticky Note10","type": "n8n-nodes-base.stickyNote","position": [2720,720],"parameters": {"content": ""},"typeVersion": 1},{"id": "2c6d927f-d7e2-4a61-aef1-6f0eb0273792","name": "Sticky Note11","type": "n8n-nodes-base.stickyNote","position": [3520,320],"parameters": {"content": ""},"typeVersion": 1},{"id": "2abddb6e-c726-4610-9cb4-3acf1f6e2b18","name": "Send Shortlist Email to Candidate","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": "Send Rejection Email to Candidate","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": "Sticky Note12","type": "n8n-nodes-base.stickyNote","position": [3520,740],"parameters": {"content": ""},"typeVersion": 1},{"id": "f0f37e05-5b00-42bb-aa9d-80a1855791a6","name": "Sticky Note14","type": "n8n-nodes-base.stickyNote","position": [3120,300],"parameters": {"content": ""},"typeVersion": 1},{"id": "72ba03a4-5dd8-4d42-b2f4-3adee73df626","name": "Update Applicant's Status as REJECTED","type": "n8n-nodes-base.googleSheets","position": [3240,920],"parameters": {},"typeVersion": 4.5},{"id": "81b96523-426f-4d78-bf48-ded4df362faa","name": "Sticky Note15","type": "n8n-nodes-base.stickyNote","position": [3120,740],"parameters": {"content": ""},"typeVersion": 1},{"id": "cc11a04b-543d-44a7-9f24-31fe71307e2c","name": "Run Daily at 09:00 AM","type": "n8n-nodes-base.scheduleTrigger","position": [100,920],"parameters": {},"typeVersion": 1.2},{"id": "bd500d66-fb06-405e-b278-dc570d7f5da5","name": "Fetch Records with Status \"Resume Selected\"","type": "n8n-nodes-base.googleSheets","position": [320,920],"parameters": {},"typeVersion": 4.5},{"id": "c1c21c4b-03bc-49a9-a1a3-5bcf9d20931b","name": "Loop to Send Assessment Link to Each Candidate","type": "n8n-nodes-base.splitInBatches","position": [580,920],"parameters": {},"typeVersion": 3},{"id": "7037b68b-4b0b-447f-b51f-be8039995ed7","name": "Get Assessment Form URL","type": "n8n-nodes-base.googleSheets","position": [880,940],"parameters": {},"typeVersion": 4.5},{"id": "3e155bf1-b5eb-4c86-aa9b-5b7773be15eb","name": "Send Assessment Submission Email","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": "Update Status to Assessment Sent","type": "n8n-nodes-base.googleSheets","position": [1440,940],"parameters": {},"typeVersion": 4.5},{"id": "9930d8fd-a3fa-43a1-9a8c-1bef8876cb61","name": "Sticky Note17","type": "n8n-nodes-base.stickyNote","position": [0,720],"parameters": {"content": ""},"typeVersion": 1},{"id": "7e40f8fa-df27-418e-9dc6-3cc73202feea","name": "Technical Support Engineer Assessment Trigger","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": "Technical Project Manager Assessment Trigger","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": "Update Applicant Status to Assessment Submitted","type": "n8n-nodes-base.googleSheets","position": [420,1460],"parameters": {},"typeVersion": 4.5},{"id": "f32d787a-36b6-4cbf-aee1-1e7bc261092a","name": "Notify TA via Email for Assessment Submission","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": "Notify TA via Slack for Assessment Submission","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": "Trigger when Interview booked by applicant in 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": "Update Status to Interview Booked","type": "n8n-nodes-base.googleSheets","position": [780,1880],"parameters": {},"typeVersion": 4.6},{"id": "cfe93e15-863b-447d-826c-3f319fec28ba","name": "Get Triggered when Applicant Status Update in Google Sheet","type": "n8n-nodes-base.googleSheetsTrigger","position": [1240,1720],"parameters": {},"typeVersion": 1},{"id": "5ff66e2e-c71d-48cc-bf66-df4d4c616569","name": "Route actions based on Status","type": "n8n-nodes-base.switch","position": [1480,1640],"parameters": {},"typeVersion": 3.2},{"id": "de0fac71-bf7f-4196-8126-d612805df08f","name": "Send Interview Invite Email","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": "Send Assessment Failed Email","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": "Send Interview Cancelled Email","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": "Interview Reschedule Invite Email","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": "Send Interview Passed/Shortlisted Email","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": "Send Interview Failed Email","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": "No Operation, do nothing","type": "n8n-nodes-base.noOp","position": [880,780],"parameters": {},"typeVersion": 1},{"id": "1e5241e3-cc08-487d-a82d-b8005fb73091","name": "Sticky Note16","type": "n8n-nodes-base.stickyNote","position": [0,1200],"parameters": {"content": ""},"typeVersion": 1},{"id": "6ed12099-5d4d-41d5-884d-c1e3723e877c","name": "Sticky Note18","type": "n8n-nodes-base.stickyNote","position": [140,1840],"parameters": {"content": ""},"typeVersion": 1},{"id": "636939ce-caef-4a1c-918b-5dffd681b941","name": "Sticky Note19","type": "n8n-nodes-base.stickyNote","position": [1060,1200],"parameters": {"content": ""},"typeVersion": 1},{"id": "e6227def-3091-4b16-a573-dbe12a02d68a","name": "Sticky Note20","type": "n8n-nodes-base.stickyNote","position": [-560,140],"parameters": {"content": ""},"typeVersion": 1},{"id": "fc0eabbb-0cfe-49fd-9fef-ff6d6afd4681","name": "Update Applicant's Status as RESUME SELECTED","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}]]}}}
Im n8n Editor: mit Strg+V einfügen→Workflow wird erstellt