{
  "name": "Automated resume review system using OpenAI + Google Sheets",
  "nodes": [
    {
      "id": "8585c01d-f26c-453e-a705-7783b3a28a46",
      "name": "On form submission",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -780,
        180
      ]
    },
    {
      "id": "d7acbd9b-f24a-4801-9a00-94308df9a55e",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        540,
        140
      ]
    },
    {
      "id": "68f1cb96-fca5-473b-b79c-707682206135",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1600,
        340
      ]
    },
    {
      "id": "04b20070-141a-466c-87d3-7de4323f83df",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1900,
        120
      ]
    },
    {
      "id": "dab7587f-890d-4571-b03d-1a2948baa91c",
      "name": "Personal Info",
      "type": "@n8n/n8n-nodes-langchain.informationExtractor",
      "position": [
        -140,
        80
      ]
    },
    {
      "id": "5c815337-80c4-4332-9179-77c0a446c205",
      "name": "Qualification",
      "type": "@n8n/n8n-nodes-langchain.informationExtractor",
      "position": [
        -140,
        320
      ]
    },
    {
      "id": "ad245152-b1cc-4dcd-b9bc-c8ec8a592115",
      "name": "HR Expert",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        1500,
        120
      ]
    },
    {
      "id": "86a37824-a3d0-4199-bb2d-c7608d65f6de",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -820,
        -140
      ],
      "parameters": {
        "width": 500,
        "height": 660,
        "content": "## Submission, Saving to Google Drive & Extraction\n\n**Captures user info from the form.**\n**Uploads resume to Google Drive.**\n**Extracts data from the PDF (resume).**"
      }
    },
    {
      "id": "6a42aedf-e2a0-44fc-ae02-00d25ab56a91",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -300,
        -140
      ],
      "parameters": {
        "width": 560,
        "height": 660,
        "content": "## Extraction (Personal Info & Qualification)\n\n**Extracts personal details (name, city, etc.).**\n**Retrieves educational qualifications and job history.**"
      }
    },
    {
      "id": "17134f76-322d-4621-ab85-340d1f9ea115",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        280,
        -140
      ],
      "parameters": {
        "width": 1120,
        "height": 660,
        "content": "## Merge & Summarization\n\n**Merges extracted information.**\n**Generates a concise professional summary.**\n\n"
      }
    },
    {
      "id": "cf09a615-65dc-4c4d-8419-f05cadeb9405",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1420,
        -140
      ],
      "parameters": {
        "width": 640,
        "height": 660,
        "content": "## Voting, Consideration & Google Sheets\n\n**HR expert reviews and analyzes the summary.\n\nAssigns a rating (1-10) and provides hiring insights.\n\nAppends all details to Google Sheets for record-keeping."
      }
    },
    {
      "id": "ee76a66a-ce2a-4a4f-8c57-0cc48b8f7dcb",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1960,
        -140
      ],
      "parameters": {
        "width": 1060,
        "height": 660,
        "content": "# Automated Resume Processing & Evaluation System\n\n**This workflow streamlines the process of handling resume submissions, extracting key details, summarizing qualifications, and aiding HR in the deci"
      }
    },
    {
      "id": "51e5290b-fadd-4f7c-99fc-8bfd54a1ee27",
      "name": "Upload to google drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -440,
        100
      ]
    },
    {
      "id": "b69e22ba-ab56-4199-830a-4d74fd8c8e74",
      "name": "Resume extraction",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        -440,
        260
      ]
    },
    {
      "id": "653d83ad-309f-4e09-acf5-e7d0a1890e1e",
      "name": "wanted profile",
      "type": "n8n-nodes-base.set",
      "position": [
        1240,
        120
      ]
    },
    {
      "id": "9ed47811-30d8-48e7-a05e-e5213f0e0526",
      "name": "Summarizer",
      "type": "@n8n/n8n-nodes-langchain.chainSummarization",
      "position": [
        840,
        120
      ]
    },
    {
      "id": "56329dd0-53e2-4617-ba54-c91e9f96d6ca",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        860,
        400
      ]
    }
  ],
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "Summarizer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HR Expert": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Summarizer": {
      "main": [
        [
          {
            "node": "wanted profile",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Personal Info": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Qualification": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "wanted profile": {
      "main": [
        [
          {
            "node": "HR Expert",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Qualification",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "Personal Info",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "Summarizer",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "HR Expert",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Resume extraction": {
      "main": [
        [
          {
            "node": "Personal Info",
            "type": "main",
            "index": 0
          },
          {
            "node": "Qualification",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "On form submission": {
      "main": [
        [
          {
            "node": "Upload to google drive",
            "type": "main",
            "index": 0
          },
          {
            "node": "Resume extraction",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "HR Expert",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    }
  }
}