Automate resume screening & candidate routing with Gemini AI and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 29 nodes and runs on Google Sheets events (row added) (plus 1 other trigger). Along the way it connects Google Drive, Google Gemini Chat Model, Google Sheets and HTTP Request. It also calls api.tavily.com over HTTP.
How it runs
Trigger: On Google Sheets events (row added) (plus 1 other trigger).
- If: checks a condition and branches into true / false
- Switch: routes items into 4 branches
- Upload file (Google Drive): uses Google Drive
- Filters based on the score (If): checks a condition and branches into true / false
- Extract from File: extracts data from a file (pdf)
- Extract from File: extracts data from a file (pdf)
- Extract from File: extracts data from a file (pdf)
- Extract from File: extracts data from a file (pdf)
- Merge: merges the data from its input branches
- Send Email: sends an email over SMTP
…plus 8 more steps. See the full node list below.
Services it uses
HTTP calls to: api.tavily.com
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)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Extract from File
n8n-nodes-base.extractFromFile - Google Drive
n8n-nodes-base.googleDrive - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Merge
n8n-nodes-base.merge - AI Agent
@n8n/n8n-nodes-langchain.agent - No Operation, do nothing
n8n-nodes-base.noOp - Send Email
n8n-nodes-base.emailSend - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - If
n8n-nodes-base.if - Switch
n8n-nodes-base.switch - Http Request Tool
n8n-nodes-base.httpRequestTool
From the author
Streamline your recruitment process with AI-powered resume analysis that goes beyond keyword matching. Overview This workflow revolutionizes hiring by using specialized AI agents to intelligently analyze resumes for different positions. Unlike traditional ATS…