n8n

How to Streamline Airtable Candidate Screening?

Hire faster with an AI screening flow that scores resumes, sends custom questions, and books interviews. It suits HR teams and hiring managers who need to review many applicants and keep every step in one place.

The flow starts when a candidate submits a simple form with contact details and a CV file. It saves the CV to Google Drive, reads the PDF text, and pulls the job description from Airtable. An AI model compares the resume to the job needs, returns a score from 0 to 1, and explains why. A rule checks the score. Strong fits move to a shortlist and the system generates a tailored questionnaire using AI, collects answers through a form, and stores results in Airtable. It also writes a personalized email, sends it by SMTP, proposes a meeting time, creates a Google Calendar event, and updates Airtable with the booked time.

Setup needs Airtable, Google Drive, Google Calendar, OpenAI, and an email account that supports SMTP. Expect major time savings on resume screening and interview scheduling. Great for in house HR teams, recruiting agencies, and busy startups that want a consistent and fair screening process.

What are the key features?

  • Form capture collects name, email, phone, and a CV file from applicants.
  • CV files upload to Google Drive and the link is saved back to Airtable.
  • PDF text is extracted from the resume for accurate AI review.
  • Job details load from the Airtable Positions table to guide the match.
  • AI scoring returns a number from 0 to 1 with a short reason using a structured parser.
  • Branch logic shortlists above 0.7 and updates Rejected or Potential Hire records.
  • AI builds a custom questionnaire, collects answers through a public form, and writes results to Airtable.
  • Personalized email is drafted with AI and sent through SMTP.
  • Interview is proposed and booked on Google Calendar and the time is stored in Airtable.
  • Screening questions are generated and posted to Airtable for the hiring team.

What are the benefits?

  • Reduce manual screening from 30 minutes to 3 minutes per applicant
  • Automate about 80 percent of admin tasks like emails, scheduling, and data entry
  • Improve data accuracy by 90 percent by writing clean records to Airtable
  • Handle up to 5 times more applicants with the same team
  • Connect Airtable, Google Drive, Google Calendar, and email in one flow
  • Move strong candidates to interviews faster with a clear AI score threshold

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Airtable, Google Drive, Google Calendar, OpenAI and SMTP. See the Tools Required section above for links to create accounts with these services.
  3. In n8n Cloud, open Credentials and connect Airtable using a Personal Access Token. Name it clearly, for example Airtable HR Prod.
  4. Double click each Airtable node and pick your Airtable credential. Select the correct Base and Tables for Applicants and Positions. Turn on typecast if your fields use select options.
  5. Connect Google Drive. Double click the upload and download nodes, choose your Google account, and set the target folder for CV files.
  6. Connect Google Calendar. Open the Google Calendar node or tool, choose your Google account, and pick the calendar used for interviews.
  7. Add your OpenAI key. Double click the AI nodes, choose Create new credential, and paste your API key. Pick the chat model you prefer.
  8. Set up SMTP. Open the Send Email node, create a new SMTP credential, enter host, port, username, and password, and set the From email address.
  9. Open the form trigger node. Review the path, form title, and description. Replace the sample job description with your live role details.
  10. Check the If node that controls shortlisting. Keep the score threshold at 0.7 or change it to match your policy.
  11. Run a full test. Submit the form with a real PDF resume. Confirm Airtable gets a new applicant, Drive stores the file, and the AI score appears.
  12. Follow the shortlist path. Open the questionnaire link, submit answers, and confirm Airtable updates. Send a test email and verify it in your inbox.
  13. Book a test meeting. Let the flow create a Google Calendar event and check that the meeting time writes back to Airtable.
  14. Troubleshooting: If PDF extraction fails, confirm the file is a PDF. If Airtable errors appear, check field names and types. If email does not send, verify SMTP settings. If the form does not load, make sure your n8n URL is public.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Airtable

Sign up

Free (1,000 API calls / mo)

Google Calendar

Sign up

Free: $0; all Google Calendar API usage is at no additional cost; quota limits apply (no charges for overages).

Google Drive

Sign up

Drive API: $0 (no additional cost; quota-limited)

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.