Screen CVs for multiple roles with OpenRouter, Google Sheets, Gmail and Calendly
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 33 nodes and runs on Google Sheets events (row added) (plus 2 other triggers). Along the way it connects OpenRouter Chat Model, Google Sheets, Google Drive and Gmail.
How it runs
Trigger: On Google Sheets events (row added) (plus 2 other triggers).
- Extract CV File ID (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Route by Event Type (Switch): routes items into 2 branches
- Is Email Unique? (Data table): row not exists
- Switch: routes items into 2 branches
- Extract Booking Details (Edit Fields (Set)): sets 2 fields: email, start_time
- Skip if Rescheduled (If): checks a condition and branches into true / false
- Add Email to Table (Data table): uses Data table
- Invitation Message (Edit Fields (Set)): sets 3 fields: email, message, subject
- Rejection Message (Edit Fields (Set)): sets 3 fields: email, message, subject
…plus 18 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 (15)
- Code
n8n-nodes-base.code - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Switch
n8n-nodes-base.switch - Data table
n8n-nodes-base.dataTable - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Calendly Trigger
n8n-nodes-base.calendlyTrigger - Date & Time
n8n-nodes-base.dateTime
From the author
This template automates the complete hiring pipeline for digital agencies managing applications across multiple job roles. When a candidate submits a Google Form with their CV, the system scores it with AI against a role-specific weighted job profile, lets HR…