Score CVs from Gmail into Airtable

Scores CVs from Gmail on a 1 to 10 scale. This n8n template polls a Gmail inbox every minute for job application emails and pulls the resume attachments. A form trigger is an alternate intake. Resumes are saved to Google Drive, converted to plain text, and an information extractor pulls name, email and phone. An AI agent summarizes education, job history and skills and assigns a 1 to 10 suitability score with a justification. A row is appended to Google Sheets and a record created in Airtable. It suits recruiters who receive applications by email and want a structured candidate table.

n8nRead on 2026-11-168 steps

Steps

  1. Trigger: Gmail and form triggers capture resumesGmail
  2. Uploads each file to Google DriveGoogle Drive
  3. Downloads and converts the resume to textGoogle Drive
  4. Extracts structured contact details
  5. AI agent summarizes and scores the CVOpenRouter
    Education, job history, skills, suitability score.
  6. Cleanup step normalizes and merges the data
  7. Output: Candidate record saved into Google SheetsGoogle Sheets
  8. Output: Candidate record saved into AirtableAirtable

Limits

  • Needs Gmail, Drive, Sheets, Airtable and AI credentials.

What it does well

  • Handles resumes arriving by email or from a form.

Before you import

You need: Gmail, Google Drive, Google Sheets, Airtable and OpenRouter/OpenAI.

Similar templates