Automated candidate calls in Google Sheets: analyze and

This automation template helps HR professionals and recruitment agencies save time on initial candidate screening. When a new row is added to Google Sheets, the system automatically calls the candidate, analyzes the conversation, and updates the row with key details like experience, salary expectations, and availability.

## Who it´s for
- HR specialists automating initial candidate interviews
- Recruitment agencies processing high volumes of applicants
- Companies implementing hiring automation without a CRM
- Time managers aiming to reduce manual data entry after calls

## What the automation does
- Triggers when a new row is added to Google Sheets with candidate details
- Initiates a voice call via VAPI using a predefined script
- Retrieves the transcript after the call ends
- Processes the transcript using Google Gemini and LangChain to extract structured data
- Updates the original sheet row: experience, current and expected CTC, notice period, availability
- Logs missed calls for follow-up scheduling

## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic based on Google Sheets row additions
- Integrations with Google Sheets, VAPI, and Google Gemini
- Basic textual guide for setup and adaptation

## Requirements for setup
- n8n account (cloud or self-hosted)
- Google account with access to Google Sheets
- VAPI account with a configured voice agent
- Google Gemini API key
- Access to HTTP API for internal node communication

## Benefits and outcomes
- Reduces manual workload for recruiters during data collection
- Accelerates the initial screening process
- Centralizes candidate data in one sheet without manual notes
- Scalable: enables calling dozens of candidates within hours
- Improves data accuracy through automated parsing

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.