Turn Interview Transcripts into Structured HR Insights — Automatically
Manually summarizing interviews and filling spreadsheets is slow, error-prone, and inconsistent. This n8n automation simplifies HR interview evaluations by using AI to transform raw interview transcripts into structured Google Sheets entries. No more copy-pasting, no more manual formatting — just clean, standardized data.
This is perfect for growing teams, HR agencies, and fast-paced hiring pipelines looking to scale their evaluation process.
🔧 How the Automation Works
1. Webhook receives the interview transcript
The workflow starts with a Webhook node at/hr-interview-eval. It receives a POST request with JSON containing the full interview transcript and optional metadata like candidate name or date.Manually summarizing interviews and filling spreadsheets is slow, error-prone, and
inconsistent. This n8n automation simplifies HR interview evaluations by using AI to transform raw interview transcripts into structured Google Sheets entries. No more copy-pasting, no more manual formatting — just clean, standardized data.This is perfect for growing teams, HR agencies, and fast-paced hiring pipelines looking to scale their evaluation process.2. DeepSeek R1 via Groq processes the transcript
An AI Agent uses the DeepSeek R1 Distill 70B model through Groq to analyze the transcript. It extracts critical evaluation data:- Candidate Name
- Interview Date & Duration
- Fit Score (1–10)
- Recommendation (Shortlist / Reject / Further Round)
- Strengths & Concerns
- Summary & Next Steps
- 6-digit Call ID & Timestamp
3. Code node parses and sanitizes the AI output
A Code node cleans and validates the AI’s JSON response. It adds fallback values, generates call IDs if missing, and ensures the date is always populated with today’s date when absent.4. Data is logged into Google Sheets
Finally, the structured evaluation is appended as a new row in a predefined Google Sheet, creating a living document of all interviews and decisions.💡 Tips & Variations
- Customize output fields: Add more categories like skill match or communication style.
- Use Slack or Email alerts: Send summaries directly to hiring managers.
- Integrate with ATS: Push structured evaluations into your applicant tracking system for a seamless hiring pipeline.
Need Help Building AI-Powered HR Workflows?
We specialize in building AI-driven automations that save time, improve accuracy, and scale processes across your org.