Screen job applications from Google Forms with Google Gemini and email results
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 14 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets and Google Gemini Chat Model.
How it runs
Trigger: On Google Sheets events (row added).
- Read All Rows (Google Sheets): uses Google Sheets
- Filter Unprocessed Rows (Code): runs custom JavaScript code
- Extract Fields & Load JD (Code): runs custom JavaScript code
- AI Resume Scorer (AI Agent): runs an AI agent, with model: Google Gemini Chat Model
- Parse AI Output (Code): runs custom JavaScript code
- Build Sheet Request (Code): runs custom JavaScript code
- Update Sheet Row (HTTP Request): calls an HTTP API (PUT)
- Check Score ≥ (If): checks a condition and branches into true / false
- Alert HR Team (Send Email): sends an email over SMTP
- Wait: pauses before continuing
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Code
n8n-nodes-base.code - Wait
n8n-nodes-base.wait - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Google Sheets
n8n-nodes-base.googleSheets - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Send Email
n8n-nodes-base.emailSend
From the author
🤖 AI Resume Screener — Google Forms to Automated Shortlisting & Email Automatically score every job application with AI, update your tracking sheet, and send personalised emails to candidates — all without human review. --- 📖 Description This workflow…