Parse resumes from Gmail to Google Sheets with Azure OpenAI GPT-4o

Description:

Stop manually reviewing resumes—let AI do the heavy lifting with this n8n workflow template! Automatically capture resumes from your Gmail inbox, extract key candidate details with AI, and store structured profiles in Google Sheets—ready for your recruitment pipeline.

This automation connects directly to your email inbox, downloads attachments, archives resumes in Google Drive, extracts text from PDFs, and uses AI to identify essential fields like name, email, phone, experience, skills, and education. The parsed candidate data is then cleaned, structured, and saved in Google Sheets for easy access, filtering, and recruiting workflows.

What This Template Does:

📧 Monitors Gmail inbox for resumes (attachments or subject line matches) 📂 Automatically uploads resumes to Google Drive for safe storage 📄 Extracts text content from PDF resumes 🧠 Uses AI to parse resumes into structured JSON fields (name, contact, experience, skills, education) 🔍 Cleans & validates AI output for consistency 📊 Stores candidate details in Google Sheets (auto-update & dedupe) 🌟 Hands-free resume management: from inbox to recruitment sheet

Built-in Logic Ensures:

✔️ Clean JSON-based AI extraction of candidate data ✔️ Deduplication to avoid repeated entries in Google Sheets ✔️ Permanent storage of resumes in Google Drive for compliance & reference ✔️ Ready-to-use candidate database for recruitment teams

Requirements: - Gmail account with incoming resumes - Google Drive for archiving resumes - Google Sheets for structured candidate database - Azure OpenAI (or compatible) account for AI-powered parsing - n8n instance (self-hosted or cloud)