Extract skill matrix to Google Sheets with Google Drive and GPT-4o
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 8 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Azure OpenAI Chat Model, Google Drive and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Search Resume (Google Drive): work with file folder
- Download Resume (Google Drive): download
- Extract content from File (Extract from File): extracts data from a file (pdf)
- Skill analyser (AI Agent): runs an AI agent, with model: Azure OpenAI Chat Model
- Parse structure json (Code): runs custom JavaScript code
- Update sheet with skill matrix (Google Sheets): append or update
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - AI Agent
@n8n/n8n-nodes-langchain.agent - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
Description Automatically extract a structured skill matrix from PDF resumes in a Google Drive folder and store results in Google Sheets. Uses Azure OpenAI (GPT-4o-mini) to analyze predefined tech stacks and filters for relevant proficiency. Fast, consistent…