Automated Resume Data Extraction from Gmail Attachments

This n8n workflow automates the extraction and organization of resume information received via Gmail. It starts with a Gmail trigger that monitors for new emails with attachments, specifically PDFs. When an email with a PDF attachment arrives, the workflow downloads the attachment and extracts its content. Using a language model (LLM), it analyzes the PDF text to identify and extract key details such as the candidate’s name, email, telephone, experience, skills, and education. The extracted data is then structured and saved into a database, specifically into different tables for personal information, experience, skills, and education using Supabase. Throughout the process, sticky notes serve as visual guides for the workflow steps, making it easier to understand and maintain.