AI CV Extractor: Google Drive to Sheets + GPT-4 & Slack

This workflow monitors a designated Google Drive folder for new or updated PDF resumes. Upon detection, it downloads the file, parses the content, and feeds the raw text to GPT-4 for intelligent extraction of structured candidate data including name, experience, skills, contact info, and more. The AI output is verified and formatted into a clean row for seamless integration.

It then performs an upsert operation on a Google Sheet acting as your central talent database—inserting new profiles or updating existing ones based on email to avoid duplicates. Finally, it sends a concise summary notification to your Slack channel, alerting the hiring team instantly. This end-to-end automation eliminates tedious manual copying, reduces errors, and keeps your candidate pipeline organized and current.

Ideal for recruiters, HR coordinators, and talent acquisition teams managing high-volume hiring via spreadsheets. Benefits include massive time savings (hours per week), improved data accuracy with AI parsing, centralized tracking without CRM costs, and real-time team notifications for faster decisions. Perfect for agencies, startups, or enterprises streamlining ATS-like operations.

Setup is straightforward: configure Drive folder monitoring, link your GPT-4 API, set Sheet credentials for upserts, and connect Slack. Handles various CV formats reliably, scaling effortlessly for dozens of resumes daily.