Delivered a hands‑free resume screening system that ingests resumes from Google Drive, analyzes them with Gemini AI, and writes structured insights to Google Sheets. The workflow standardizes shortlisting criteria, speeds up hiring decisions, and provides clear audit trails and documentation.
Key Highlights from Client
90% reduction in manual screening time
Faster, more consistent shortlists with objective scoring
Structured insights auto‑written to Google Sheets
Higher accuracy in identifying qualified candidates
Professional communication, clear documentation, and a Loom walkthrough
Key Features
Automated Intake: Watch folder in Google Drive; dedupe and parse PDFs/DOCs.
AI Evaluation (Gemini): Score against role criteria; extract skills, experience, education, and red flags.
Structured Output: Normalize fields and write candidate scores, summaries, and recommendations to Sheets.
Shortlist Rules: Thresholds, must‑have skills, and knockout questions with explanations.
Alerts & Handoffs: Notify hiring team on high‑scoring candidates; create tasks or send emails automatically.
Auditability: Store raw text, AI prompts/responses, and timestamps for review and compliance.
AI Layer: Google Gemini for extraction, scoring, and summarization
Storage & Docs: Google Drive for files; Google Sheets as the decision ledger
Notifications: Gmail/Slack for status and shortlist alerts
Workflow
Resume added to Drive → 2. Parse text → 3. Gemini analyze/score →
Write structured row to Sheets → 5. Notify team and attach summary →
Optional reviewer approval and notes
Challenges & Solutions
Varied resume formats: Combined OCR + robust parsing; fallback to manual review flag when confidence is low.
Bias & consistency: Standardized criteria and rubric prompts; logged reasoning for transparency.
Throughput & errors: Implemented batching, retries, and idempotent upserts in n8n.
Results
Dramatically less manual work, faster decisions, and clearer candidate comparisons—running reliably from day one with strong documentation and team enablement.
Goal
Provide a reliable, explainable screening pipeline that accelerates hiring while maintaining fairness and transparency—freeing teams to focus on interviews and decision‑making.
Like this project
Posted Jan 12, 2026
Hands‑free pipeline parsing resumes from Drive, scoring with Gemini, and writing insights to Sheets—90% less manual work, faster shortlists.