Back to Templates

Screen Resumes & Send Follow-ups with OpenAI GPT-4o, Google Sheets & Gmail

Created by

Created by: Abdulaziz || abdulaziz747

Abdulaziz

Last update

Last update 10 hours ago

Share


This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

🧠 How It Works

This workflow automates the process of screening resumes using AI, logging results to Google Sheets, and sending follow-up emails via Gmail.

  1. User uploads their resume via a form (PDF only).
  2. Resume content is extracted and sent to OpenAI for evaluation.
  3. AI scores the resume based on:
    • Role-specific must-have qualifications
    • Soft skills / strategic fit questions
  4. Based on the score threshold, the candidate is classified as:
    • Accepted → Saved to Accepted sheet + Gmail invite
    • Rejected → Logged to Rejected sheet + Gmail rejection message
  5. Output is stored in Google Sheets with detailed justification.

⚙️ Set Up Steps

  1. 🔑 Connect your OpenAI and Google Sheets credentials.
  2. Replace the placeholder tags in the AI prompt:
    • COMPANY_NAME
    • ROLE_NAME
    • ROLE_DESCRIPTION
    • CRITERIA_1 to CRITERIA_5
    • Q1 to Q5
    • THRESHOLD (score to pass)
  3. Customize Gmail messages (optional).
  4. ✅ Make sure your sheet has two tabs: Accepted and Rejected.

📌 Notes

Sticky Notes included in the flow explain:

  • What each node does
  • Where to replace variables
  • Tips for improving match scoring