What This Automation Does
This workflow makes hiring easier by taking job applications and managing them without much human work.
It solves problems like slow resume review, mistakes from manual work, and keeps hiring fast.
You get candidate data stored, scores on qualifications, automatic interview invites, and booked meetings.
Applicants submit forms with their CVs.
The system uploads CVs to cloud storage.
Then, AI reads CVs to give scores against job needs.
Candidates who qualify well are invited automatically by email.
Interviews are scheduled on Google Calendar and info saved for interviewers.
Tools and Services Used
- n8n Form Trigger: Captures submitted applicant data.
- Google Drive API: Stores uploaded CV files.
- Airtable API: Tracks candidate details and statuses.
- OpenAI Chat Model via LangChain: Reads resumes, scores candidates, writes emails and questions.
- Google Calendar API: Books interview slots with interviewer availability.
- SMTP Email Server: Sends personalized emails to candidates.
How the Workflow Works
Inputs
The system starts when a job applicant fills a public form.
This form collects name, phone, email, work experience, and a PDF CV.
Processing Steps
First, the CV file uploads to Google Drive for safe keeping.
Applicant info is organized and saved in Airtable as a new record.
Then the CV file is downloaded back and text is extracted using PDF parsing.
OpenAI compares CV text to the job description.
The AI gives a qualification score from 0 to 1 and a short explanation.
An IF node checks if the score meets a threshold (0.7).
Qualified candidates get marked “Potential Hire” in Airtable.
Others get “Rejected” status.
For hires, AI creates 5 interview questions tailored to their CV and role.
Candidates answer these via a form, which updates Airtable.
Then AI drafts a personalized email inviting candidates to phone interviews.
The email is sent using SMTP.
Interview slots are auto-booked in Google Calendar after AI suggests times that suit interviewer availability.
Confirmed times are saved in Airtable.
Finally, AI generates extra screening questions for interviewers based on candidate info.
These are saved so interviewers prepare better.
Outputs
The user gets:
- Airtable records with candidate data and status.
- CVs saved securely in Google Drive.
- Emails sent automatically inviting candidates.
- Google Calendar events booked for interviews.
- Interview questions ready for phone interviews.
Who Should Use This Workflow
Anyone hiring for tech roles can use this to save hours sorting resumes.
It is good for small HR teams or solo recruiters wanting to avoid manual mistakes.
This helps keep a fast, fair, and organized hiring process.
Beginner Step-by-Step: How to Use This Workflow in n8n
1. Import the Workflow
- Download the workflow file using the Download button on this page.
- Open your n8n editor where you manage automations.
- Click “Import from File” and choose the downloaded workflow.
2. Configure Credentials
- Add your Google Drive OAuth credentials in the corresponding nodes.
- Connect your Airtable API key and configure base and table IDs for “Applicants” and “Positions”.
- Enter your OpenAI API key in the LangChain or OpenAI nodes.
- Set up Google Calendar OAuth for interview scheduling.
- Provide SMTP email credentials (such as Gmail SMTP) for sending emails.
3. Update Variables
- Check any fixed values like the job description text; update if needed.
- Verify folder IDs on Google Drive where CVs should go.
- Update email templates or prompts if desired.
4. Test the Workflow
- Submit a test application through the provided form URL.
- Watch the workflow execute in n8n editor, check for errors.
- Confirm CV gets uploaded, Airtable updates, and email sends.
5. Activate for Production
- Switch workflow status to “Active” in n8n to make it run automatically.
- Share the public form URL with job applicants.
If hosting or running on your own server, use self-host n8n for control and security.
Inputs and Outputs
Inputs
- Applicant form submission with personal info and CV PDF.
- Job description text from Airtable positions table.
Processing
- CV upload and storage in Google Drive.
- Text extraction from CV PDF.
- AI scoring by comparing CV with job description.
- Database record creation and updates in Airtable.
- Questionnaire creation and candidate response capture.
- Email generation and sending.
- Interview scheduling on Google Calendar.
- Screening questions preparation.
Outputs
- Stored CV files.
- Updated Airtable candidate records.
- Sent personalized email invitations.
- Scheduled interviews on calendar.
- Interview questions ready for review.
Common Problems and How to Fix Them
- File upload fails or no data: Check the file binary field name matches exactly between form and Google Drive nodes.
- AI returns no score: Ensure prompts have correct job and CV text variables and test with samples.
- Emails not sent: Confirm SMTP credentials and email fields like “To”, “Subject”, and body are set correctly.
Customization Ideas
- Change the job description text within the form trigger fields to hire different roles.
- Adjust the qualification score threshold in the IF node to be stricter or easier.
- Edit AI prompts for interview questions and emails to fit your company style.
- Add more storage integrations for CVs like Dropbox.
Summary
✓ Saves hours of manual screening work.
✓ Removes errors from manual data handling.
✓ Uses AI to rate and select candidates fairly.
✓ Automates interviews and communication.
✓ Keeps all data in organized cloud services.
→ Helps recruiters make faster and better hiring decisions.
