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.
Steps
- Trigger: Gmail and form triggers capture resumesGmail
- Uploads each file to Google DriveGoogle Drive
- Downloads and converts the resume to textGoogle Drive
- Extracts structured contact details
- AI agent summarizes and scores the CVOpenRouter
Education, job history, skills, suitability score. - Cleanup step normalizes and merges the data
- Output: Candidate record saved into Google SheetsGoogle Sheets
- 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
Jotform resume scoring with OpenAI
Also for hiring and onboarding, 5 steps.
Resume ranking with four AI agents
Also for hiring and onboarding, 7 steps.
Screen resumes with OpenAI, Airtable
Also for hiring and onboarding, 9 steps.
Gmail and Google Sheets: 22 templates compared
Same two apps, different steps.
Gmail and Google Drive: 12 templates compared
Same two apps, different steps.
Google Drive and Google Sheets: 12 templates compared
Same two apps, different steps.
Gmail and OpenRouter: 6 templates compared
Same two apps, different steps.
Google Sheets and OpenRouter: 3 templates compared
Same two apps, different steps.
Airtable and Gmail: 2 templates compared
Same two apps, different steps.
Airtable and Google Drive: 2 templates compared
Same two apps, different steps.
Airtable and Google Sheets: 2 templates compared
Same two apps, different steps.
Google Drive and OpenRouter: 2 templates compared
Same two apps, different steps.
Sort incoming requests
Other templates that do this task.