Get Started
Back to Templates

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

Created by

Created by: Rahul Joshi || rahul08

Rahul Joshi

Last update

Last update 22 days ago

Categories

Share

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., 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”). ✍️