Resume Inbox Processing with Azure OpenAI and Google Sheets - n8n Workflow

Recruitment teams and HR professionals managing high volumes of job applications.
Technical users looking for advanced examples of using the n8n AI Agent node with external LLM providers.
Anyone needing robust file handling and data extraction capabilities within an n8n workflow.
Developers seeking ready-to-use n8n templates for complex automation tasks.

Handling a dedicated resume inbox can be time-consuming, requiring manual downloading, text extraction, and data entry. This sophisticated n8n workflow solves this by creating a fully automated pipeline. The moment an email with a resume attachment arrives, this powerful n8n automation takes over. It securely stores the file in Google Drive, extracts the raw text content, and then sends that content to an Azure OpenAI model (like GPT-4o) via the n8n AI Agent. The AI parses the resume text into structured data (name, contact, experience, skills). Finally, the results are formatted and automatically logged into a Google Sheet for easy screening and tracking. This n8n workflow drastically reduces manual effort and speeds up the hiring process.

This comprehensive n8n workflow initiates instantly when a new resume email is received, thanks to the dedicated n8n trigger.

1. Trigger: The Gmail Trigger n8n node listens for new emails that match specific criteria (e.g., subject line or label).


2. Attachment Retrieval: The Gmail n8n node fetches the actual file attachment from the triggered email.


3. Secure Storage: The attachments are immediately uploaded to a specified folder in Google Drive using the Google Drive Upload n8n node.


4. File Preparation: The file data is handled by the subsequent Download file n8n node, ensuring the content is ready for parsing.


5. Text Extraction: The Extract from File n8n node converts the attached document (PDF, DOCX, etc.) into raw, readable text.


6. AI Processing: The AI Agent n8n node takes the extracted text. It is configured to utilize the Azure OpenAI Chat Model to perform complex data extraction, transforming the unstructured resume text into a structured JSON object containing key candidate details.


7. Data Structuring: A Code n8n node executes custom JavaScript to clean, validate, and flatten the structured data output from the AI, preparing it for spreadsheet entry.


8. Logging: The final Google Sheets Append n8n node writes the structured candidate data as a new row in your designated tracking sheet, completing the end-to-end n8n workflow.

To deploy this n8n workflow, follow these steps:

1. Import: Copy the provided JSON code and paste it into your n8n canvas using the 'New' -> 'Import from JSON' option.


2. Credentials Setup:

1. Customization: Review the configurations in the Code n8n node and the prompt settings within the AI Agent to ensure the extracted fields match your Google Sheet column headers.


2. Activation: Once all credentials and configurations are set, activate the n8n workflow to start monitoring your resume inbox.

Gmail Trigger: This n8n trigger node starts the n8n workflow upon detecting a new email. Essential for initiating the automated process immediately upon receiving a resume.
Gmail (Get the attahcment): An n8n node used in the message context to specifically retrieve the file attachments associated with the triggered email.
Google Drive Upload: Used to upload the raw resume file attachments to Google Drive for permanent storage and compliance.
Extract from File: A vital n8n node that reads various document types (like PDFs or DOCX) and outputs the complete text content, which is crucial input for the LLM.
Azure OpenAI Chat Model: This acts as the LLM backend for the AI Agent. It leverages Microsoft's Azure infrastructure to utilize powerful models like GPT-4o for precise, high-stakes data extraction within the n8n workflow.
AI Agent: This specialized n8n node wraps the LLM, providing specific instructions (tools/prompts) to analyze the unstructured resume text and return structured candidate information.
Code: This n8n node is essential for transforming the complex JSON output from the AI into a clean, flat object array required by the Google Sheets n8n node for seamless appending.
Google Sheets Append: The final n8n node in the flow, responsible for writing the extracted and structured candidate data into a designated row in the Google Sheets spreadsheet.