Automated HR screening with VAPI AI calls, Gemini analysis & Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 10 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets and Google Gemini Chat Model. It also calls api.vapi.ai over HTTP.
How it runs
Trigger: On Google Sheets events (row added).
- Rename Required Fields (Edit Fields (Set)): sets 4 fields: First name, Last name, Phone No…
- Get VAPI Assistant (HTTP Request): calls api.vapi.ai
- Make a Call (HTTP Request): calls api.vapi.ai (POST)
- Get Call Transcript (HTTP Request): calls api.vapi.ai
- Call Data Analyser (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model; output parser: Structured Output Parser
- Map Field Names (Edit Fields (Set)): sets 1 field: output
- Update row in sheet (Google Sheets): update
Services it uses
HTTP calls to: api.vapi.ai
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 (7)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - HTTP Request
n8n-nodes-base.httpRequest - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Edit Fields (Set)
n8n-nodes-base.set
From the author
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This n8n template automates candidate outreach, call transcription, and structured feedback capture for HR teams and recruiters. It triggers on a new…