{
  "name": "Automate CV screening and candidate scoring with Gemini AI and Google Sheets",
  "nodes": [
    {
      "id": "2c5eefc2-dea1-4ce8-95c7-ced6a7c05496",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1728,
        -1712
      ],
      "parameters": {
        "width": null,
        "height": 496,
        "content": "Form TRIGGER:\nPut the Answers of Question on the form and upload the CV"
      }
    },
    {
      "id": "93dca7c6-1b73-4b9d-b4db-7033e3b2f332",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1472,
        -1712
      ],
      "parameters": {
        "width": 272,
        "height": 576,
        "content": "UPLOAD THE FILE:\nIncoming attachment (CV) is uploaded to the configured Google Drive folder and named from the sender."
      }
    },
    {
      "id": "11e1a03b-63ab-48f3-b6cf-83e560ab7c18",
      "name": "Sticky Note13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1184,
        -1712
      ],
      "parameters": {
        "width": 160,
        "height": 576,
        "content": "EXTRACT FROM FILE:\nExtract from File converts the CV (PDF) into plain text."
      }
    },
    {
      "id": "67b1aaf1-0c9f-4df7-85ca-f2b31efa12e1",
      "name": "On form submission",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -1616,
        -1504
      ]
    },
    {
      "id": "e61a5cc7-888b-487d-b3a3-1c8da6f509d0",
      "name": "Upload CV to Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -1472,
        -1328
      ]
    },
    {
      "id": "b2cf1ee8-ae9e-433b-8f8c-97986506e6ca",
      "name": "Download CV",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -1312,
        -1328
      ]
    },
    {
      "id": "fbf85dc4-eb37-485d-b3c9-baea539939a1",
      "name": "Extract CV Text",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        -1152,
        -1328
      ]
    },
    {
      "id": "cf300ed5-3ea2-4526-8ccf-a83a0c5d673d",
      "name": "AI Comparison & Scoring",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -624,
        -1488
      ]
    },
    {
      "id": "39b6c6d4-d99a-4303-aeb9-45e29c3c7194",
      "name": "Parse AI Results",
      "type": "n8n-nodes-base.code",
      "position": [
        -320,
        -1488
      ]
    },
    {
      "id": "eac75239-6849-4def-9498-a0067dafd42d",
      "name": "Get All Rows",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        224,
        -1488
      ]
    },
    {
      "id": "007f90d7-449f-4c01-a94b-08fd1a3c1970",
      "name": "Sort by Final Score",
      "type": "n8n-nodes-base.code",
      "position": [
        400,
        -1488
      ]
    },
    {
      "id": "d933071d-3ac8-435d-b806-7e73566b32c0",
      "name": "Clear Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        576,
        -1488
      ]
    },
    {
      "id": "a7d7948c-71de-4f18-a6b7-956d1ba22ad9",
      "name": "Write Sorted Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        752,
        -1488
      ]
    },
    {
      "id": "4ca956b4-c726-434c-952a-51c83a41337d",
      "name": "Merge Form + CV1",
      "type": "n8n-nodes-base.merge",
      "position": [
        -976,
        -1488
      ]
    },
    {
      "id": "2f209679-9ec9-4332-967f-1345f4c96b7d",
      "name": "Google Gemini Chat Model1",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        -576,
        -1280
      ]
    },
    {
      "id": "1c385e5b-1459-4a3a-979b-a1215d642a7e",
      "name": "Getting Score",
      "type": "n8n-nodes-base.code",
      "position": [
        -144,
        -1488
      ]
    },
    {
      "id": "3fea28de-e1ce-4cd5-b458-c8f1de1ae527",
      "name": "Comparison Data",
      "type": "n8n-nodes-base.code",
      "position": [
        -800,
        -1488
      ]
    },
    {
      "id": "a7404cf7-ee31-46cf-b21f-62965b8afb3f",
      "name": "Save to Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        32,
        -1488
      ]
    },
    {
      "id": "a305785f-ac90-446e-9aef-a24fe5a2aaa1",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1008,
        -1712
      ],
      "parameters": {
        "width": 166,
        "height": 576,
        "content": "Merge node to combine the CV data and Answers of Question"
      }
    },
    {
      "id": "bed2791f-0183-44c1-97f2-e9e44ee531c8",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -832,
        -1712
      ],
      "parameters": {
        "width": 166,
        "height": 576,
        "content": "compare the incoming data \"Answers of Question and the CV data\""
      }
    },
    {
      "id": "e5e6261f-a800-47f6-995d-b7680be6220e",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -656,
        -1712
      ],
      "parameters": {
        "width": 288,
        "height": 576,
        "content": "AI Agent node : \nWrite the summary on the bases of compare data"
      }
    },
    {
      "id": "3cd73546-3a4c-45cf-835a-2e10aee4baa8",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -352,
        -1712
      ],
      "parameters": {
        "width": 336,
        "height": 576,
        "content": "Code node : \nGet the AI Results and the mark the score"
      }
    },
    {
      "id": "731f3d2f-74b6-4d46-965d-519c030472d5",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        -1712
      ],
      "parameters": {
        "width": 166,
        "height": 576,
        "content": "Sava data in the google sheet"
      }
    },
    {
      "id": "24512dd9-c364-48e9-9d5c-29717202a28f",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        176,
        -1712
      ],
      "parameters": {
        "width": 166,
        "height": 576,
        "content": "Get all the rows "
      }
    },
    {
      "id": "d6bcf2f6-9ab8-4d2e-a58f-3eb784136709",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        352,
        -1712
      ],
      "parameters": {
        "width": 166,
        "height": 576,
        "content": "Sort the data based on the scoring"
      }
    },
    {
      "id": "5dcfb8eb-da59-46be-8329-67011031eeba",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        544,
        -1712
      ],
      "parameters": {
        "width": 336,
        "height": 576,
        "content": "Clear the sheet and again save the data based on the scoring"
      }
    },
    {
      "id": "378342c4-f97f-49b5-90dd-f654e3c6a230",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1072,
        -1936
      ],
      "parameters": {
        "width": 1168,
        "height": null,
        "content": "# Automated AI-Powered CV Screening and Candidate Scoring System"
      }
    }
  ],
  "connections": {
    "Clear Sheet": {
      "main": [
        [
          {
            "node": "Write Sorted Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download CV": {
      "main": [
        [
          {
            "node": "Extract CV Text",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get All Rows": {
      "main": [
        [
          {
            "node": "Sort by Final Score",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Getting Score": {
      "main": [
        [
          {
            "node": "Save to Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Save to Sheets": {
      "main": [
        [
          {
            "node": "Get All Rows",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Comparison Data": {
      "main": [
        [
          {
            "node": "AI Comparison & Scoring",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract CV Text": {
      "main": [
        [
          {
            "node": "Merge Form + CV1",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Merge Form + CV1": {
      "main": [
        [
          {
            "node": "Comparison Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse AI Results": {
      "main": [
        [
          {
            "node": "Getting Score",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "On form submission": {
      "main": [
        [
          {
            "node": "Upload CV to Drive",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge Form + CV1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload CV to Drive": {
      "main": [
        [
          {
            "node": "Download CV",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sort by Final Score": {
      "main": [
        [
          {
            "node": "Clear Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Comparison & Scoring": {
      "main": [
        [
          {
            "node": "Parse AI Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "AI Comparison & Scoring",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    }
  }
}