Automate DEI eligibility screening with Azure GPT-4o, Google Drive and Sheets
Ready for 3.0What this workflow does
This AI workflow has 11 nodes and runs on Google Drive events (file created). Along the way it connects Azure OpenAI Chat Model, Google Sheets, Google Drive and Gmail.
How it runs
Trigger: On Google Drive events (file created).
- Download CV (Google Drive): download
- Extract from PDF (Extract from File): extracts data from a file (pdf)
- Check for DEI Eligibility (AI Agent): runs an AI agent, with model: Azure OpenAI Chat Model; 1 tool (Get row(s) in sheet in Google Sheets); output parser: Structured Output Parser
- Update on Sheet (Google Sheets): append
- Logic (If): checks a condition and branches into true / false
- Create Email (Code): runs custom JavaScript code
- Email to Manager (Gmail): uses Gmail
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 (11)
- Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail
From the author
Description This workflow is designed to evaluate newly added CVs for Diversity, Equity, and Inclusion (DEI) eligibility. It automatically ingests CVs from Google Drive, extracts key fields, analyzes them with Azure OpenAI, logs structured DEI outcomes in…