Process resumes from Google Drive to ClickUp using GPT-4o and Google Sheets

Description Process new resumes from Google Drive, extract structured candidate data with AI, save to Google Sheets, and auto-create a ClickUp hiring task. Gain a centralized, searchable candidate database and instant task kickoff—no manual data entry. 🚀

What This Template Does - Watches a Google Drive folder for new resume PDFs and triggers the workflow. 📂 - Downloads the file and converts the PDF to clean, readable text. 📄 - Analyzes resume text with an AI Resume Analyzer to extract structured candidate info (name, email, phone, experience, skills, education). 🤖 - Cleans and validates the AI JSON output for reliability. 🧹 - Appends or updates a candidate row in Google Sheets and creates a ClickUp hiring task. ✅

Key Benefits - Save hours with end-to-end, hands-off resume processing. ⏱️ - Never miss a candidate—every upload triggers automatically. 🔔 - Keep a single source of truth in Sheets, always up-to-date. 📊 - Kickstart hiring instantly with auto-created ClickUp tasks. 🗂 - Works with varied resume formats using AI extraction. 🧠

Features - Google Drive “Watch for New Resumes” trigger (every minute). ⏲ - PDF-to-text extraction optimized for text-based PDFs. 📘 - AI-powered resume parsing into standardized JSON fields. 🧩 - JSON cleanup and validation for safe storage. 🧰 - Google Sheets append-or-update for a central candidate database. 📑 - ClickUp task creation with candidate-specific titles and assignment. 🎯

Requirements - n8n instance (cloud or self-hosted); recommended n8n version 1.106.3 or higher. 🔧 - Google Drive access to a dedicated resumes folder (PDF resumes recommended). 📂 - Google Sheets credential with edit access to the candidate database sheet. 📈 - ClickUp workspace/project access to create tasks for hiring. 📌 - AI service credentials for the Resume Analyzer step (add in n8n Credentials). 🤖

Target Audience - HR and Talent Acquisition teams needing faster screening. 👥 - Recruiters and staffing agencies handling high volumes. 🏢 - Startups and ops teams standardizing candidate intake. 🚀 - No-code/low-code builders automating hiring workflows. 🧩

Step-by-Step Setup Instructions - Connect Google Drive, Google Sheets, ClickUp, and your AI service in n8n Credentials. 🔐 - Set the Google Drive “watched” folder (e.g., Resumestore). 📁 - Import the workflow, assign credentials to all nodes, and map your Sheets columns. 🗂️ - Adjust the ClickUp task details (title pattern, assignee, list). 📝 - Run once with a sample PDF to test, then enable scheduling (every 1 minute). ▶️ - Optionally rename the email/task nodes for clarity (e.g., “Create Hiring Task in ClickUp”). ✍️