Workflow overview
Why this workflow matters
Improves internal consulting operations and productivity. Relevant for managed services and support workflows.
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 AlekSystem instance (cloud or self-hosted); recommended AlekSystem 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 AlekSystem 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 AlekSystem Credentials. 🔐 Set the Google Drive “watched” folder (e.g., Resume_store). 📁 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”). ✍️
Best fit
Categories
Services
Use cases
Need another direction?