AutomationFlowsAI & RAG › Generate Ai-powered Interview Briefs From Resumes Using Google Sheets & Gpt-4o

Generate Ai-powered Interview Briefs From Resumes Using Google Sheets & Gpt-4o

ByRahul Joshi @rahul08 on n8n.io

This workflow automates the creation of comprehensive interviewer brief packs by extracting candidate resume data and generating professional HTML interview preparation materials. It saves recruiters time by consolidating candidate information, analyzing resumes, and producing…

Event trigger★★★★☆ complexityAI-powered16 nodesGmailGoogle SheetsChain LlmLm Chat Azure Open AiGoogle Drive
AI & RAG Trigger: Event Nodes: 16 Complexity: ★★★★☆ AI nodes: yes Added:

This workflow corresponds to n8n.io template #8514 — we link there as the canonical source.

This workflow follows the Chainllm → Gmail recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "id": "Q0XfAnTulsSa2PXw",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Interviewer Brief Pack",
  "tags": [],
  "nodes": [
    {
      "id": "9f6ee7bd-dbb4-4424-90af-96f3c4cef415",
      "name": "Send Follow-up Email1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        688,
        48
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "05512004-69c4-40c1-a927-32437eabad10",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -608,
        48
      ],
      "parameters": {},
      "typeVersion": 4
    },
    {
      "id": "755efe2a-92f7-424c-8dc1-23b8b078accc",
      "name": "Basic LLM Chain",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        288,
        48
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "6ab7fa6e-1f6d-406d-b87f-14aedbeab062",
      "name": "Azure OpenAI Chat Model1",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        288,
        288
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "b5f63b84-daf1-49d9-a7dd-7fed1fd033de",
      "name": "When clicking \u2018Execute workflow\u2019",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -816,
        48
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "70d8f7be-01f2-430a-871a-f469a1c0cd3c",
      "name": "Download file",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -400,
        48
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "4d83ae47-dc8d-4541-b4d5-16ec90038f48",
      "name": "Extract from File",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        -176,
        48
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "9f7ac343-94f8-4079-834e-d0cf046476b6",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "position": [
        48,
        48
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "3a1b8614-1fdb-4c85-9a4b-fc7ce839d0ee",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -880,
        256
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "19f95e7e-5946-4f11-87c0-c6850395bbb3",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -672,
        -208
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d03282dc-712e-454e-a4d0-698751192101",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -448,
        224
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "71c24508-72ba-4d20-8ae7-c7cb19e84848",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -240,
        -192
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "7c158ad5-823b-4fa7-a238-4bbb456b56d9",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -16,
        224
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "4f01fb48-f4c8-4074-a5f4-023d149cc199",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        288,
        -384
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "92f3441a-b1c4-41a4-aaec-c4e22acd8d83",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        640,
        208
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "eb0e2eb5-5e7a-4bca-8cea-c2cb84613095",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        272,
        432
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "61a5ee71-d3cb-42cd-9348-5e3f61568aea",
  "connections": {
    "Code": {
      "main": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download file": {
      "main": [
        [
          {
            "node": "Extract from File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Basic LLM Chain": {
      "main": [
        [
          {
            "node": "Send Follow-up Email1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract from File": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Download file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Azure OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "When clicking \u2018Execute workflow\u2019": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This workflow automates the creation of comprehensive interviewer brief packs by extracting candidate resume data and generating professional HTML interview preparation materials. It saves recruiters time by consolidating candidate information, analyzing resumes, and producing…

Source: https://n8n.io/workflows/8514/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

This workflow automates personalized candidate communication for both shortlisted and rejected applicants. It fetches candidate details, processes resumes, checks for errors, and uses GPT-4o to genera

Google Sheets, Google Drive, Lm Chat Azure Open Ai +2
AI & RAG

This workflow automates the candidate rejection process after interviews. It retrieves interview feedback from Google Sheets, uses AI to structure and score candidate data, applies a scoring threshold

Google Sheets, ClickUp, Chain Llm +2
AI & RAG

This workflow is perfect for graphic designers, creative agencies, marketing teams, or freelancers who regularly use AI-generated images in their projects. It's specifically beneficial for teams that

Google Sheets, Google Drive, HTTP Request +5
AI & RAG

This workflow automates the full lifecycle of a vehicle insurance claim — from an incoming Gmail email to a signed, watermarked PDF decision letter delivered back to the claimant.

Gmail Trigger, N8N Nodes Pdf Api Hub, Google Sheets +4
AI & RAG

This workflow automates the creation, storage, and reporting of personalized sales collateral for booked leads using GPT-4o, Google Sheets, Google Drive, and Gmail. It pulls leads from a central sheet

Google Sheets, Lm Chat Azure Open Ai, Agent +2