AI Recruitment Automation: Resume Screening & GSheets

# Automate candidate screening from forms with AI resume analysis and Google Sheets sync

This automation streamlines candidate processing by extracting CV data, evaluating job fit using AI (LangChain + OpenAI), updating statuses in Google Sheets, and sending automated email notifications. Designed for HR teams, recruiters, and high-volume hiring environments.

## Who it´s for
- HR specialists automating recruitment workflows
- Recruiters in IT companies assessing technical candidates
- Talent managers needing fast resume filtering
- Companies with high hiring volume requiring candidate scoring
- Recruitment agencies using Google Sheets as an ATS

## What the automation does
- Triggers on form submissions (Typeform), Calendly events, or scheduled runs
- Extracts structured data from uploaded CVs
- Uses LangChain and OpenAI to analyze skills, experience, and job fit
- Computes a semantic match score for objective evaluation
- Updates candidate row in Google Sheets with new status (e.g., ´Shortlisted´, ´Rejected´)
- Sends automated emails via SMTP based on status changes
- Posts notifications to Slack for key updates

## What´s included
- Ready-to-use n8n workflow
- Trigger logic for forms, calendar events, and cron schedules
- Integrations with Google Sheets, Typeform, Calendly, Email SMTP, Slack
- Basic text instructions for setup and adaptation

## Requirements for setup
- n8n instance with workflow import capability
- Google Drive and Google Sheets (for candidate database)
- Typeform and/or Calendly accounts (for application intake)
- SMTP server for email delivery
- OpenAI API access (to power LangChain agent)
- Optional: Slack workspace for notifications

## Benefits and outcomes
- Reduces manual resume review by up to 80%
- Centralized candidate tracking in Google Sheets with auto-updates
- Objective AI-driven fit assessment, minimizing bias
- Faster candidate communication via automated emails
- Seamless integration with existing HR tools
- Scalable: process hundreds of applicants with one template

## 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 chat