Quick overview
Quick overview This workflow automatically processes job applications received via Gmail. It extracts the job code from the email subject and parses the attached CV using Gemini AI to retrieve applicant details.Each applicant is then scored against job requirements fetched from Airtable, with results and AI notes logged automatically to Applications table. How it works The workflow watches for new emails with attachments arriving under a specified Gmail label and triggers automatically on each new match. The job code is extracted from the email subject line (e.g., FN-001) and raw text is extracted from the attached CV PDF file. Gemini AI parses the extracted CV text and returns structured applicant data including name, email, years of experience, and skills. The extracted job code is used to retrieve the matching job post details and requirements from your Airtable Job Posts table. Gemini compares the applicant's profile against the job requirements, assigns a score from 1–100, and generates a brief reasoning summary in Bahasa Indonesia. The applicant's data, score, and AI-generated notes are saved as a new record in the Airtable Applications table. Setup Prepare your Airtable base with two tables: Job Posts (Job Code, Job Title, Required Skills, Minimum Experience, Job Description) and Applications (Applicant Name, Email, Score, Notes) with a linked field pointing to Job Posts. Add your Gmail, Google AI (Gemini), and Airtable credentials in the n8n Credential Manager before configuring any nodes. Open the Gmail Trigger node and set your label filter (e.g., label:job-applications). In the Extract Job Code node, verify the regex matches your format — default is ([A-Z]{2}-\d{3}). Open both the Find Job Post and Save Applicant Airtable nodes and select your correct base and table in each. Save and activate the workflow — new CV submissions will now be processed, scored, and logged to Airtable automatically. Additional info Published by Fahmi Fahreza, Indonesia’s first official n8n Brand Ambassador and founder of WithMi Automation, built from real client implementations, not tutorials. → Let us build it for you: withmiautomation.com → Learn to build it yourself: academy.withmiautomation.com → Bring Fahmi to your team (training, workshop, talkshow): fahmiiireza.com. An n8n automation workflow template by Fahmi Fahreza.
Fahmi Fahreza
web
free
Others in the same category, ranked by how often they are opened.
