Automate Job Applicant Screening with GPT-4, Gmail & Google Sheets

This workflow automates the initial screening process for new job applications, freeing up your recruitment team to focus on qualified candidates. It receives applications from a webhook, uses OpenAI (GPT-4) to analyze resumes for skill and culture fit, generates interview questions, logs the results to Google Sheets, sends interview invitations via Gmail, and notifies your team on Slack.

🚀 Who is this for?

• HR and Recruitment Teams looking to automate repetitive screening tasks.
• Hiring Managers who want a consistent, data-driven first pass on applicants.
• Startups and SMBs aiming to build an efficient, scalable hiring pipeline without a large HR team.

💡 How it works

1. Receive Application: The workflow triggers when a new application is submitted via a webhook from your job board or application form.
2. Extract & Analyze: It downloads the resume/CV, extracts the text, and sends it to OpenAI (GPT-4) with a custom prompt.
3. Score & Generate: The AI scores the candidate on skill match and culture fit, provides a summary, and generates tailored interview questions based on their experience.
4. Log Data: The evaluation scores, AI summary, and candidate information are appended to a new row in a Google Sheet for tracking.
5. Schedule Interview: A personalized email is sent to the candidate via Gmail with a link to schedule their interview.
6. Notify Team: A summary card with the AI evaluation and links to the full report is posted in a Slack channel to keep the hiring team informed.

⚙️ How to set up

1. Configure Credentials: Set up your credentials for OpenAI, Google (for both Sheets and Gmail), and Slack in n8n.
2. Webhook URL: Copy the "Production URL" from the "Webhook: New Application" node and set it as the destination in your job board's webhook settings (e.g., Greenhouse, Lever, Ashby, or a web form).
3. Google Sheet: Create a Google Sheet to track applicants. Update the "G Sheets: Save Evaluation" node with your Spreadsheet ID and Sheet Name. Ensure the columns in your sheet match the data you want to save.
4. Customize Prompts & Email:
   • Modify the prompts in the two OpenAI nodes to match your company's values and the specific job requirements.
   • Update the Gmail node with your email content and the logic for your scheduling link (e.g., Calendly, SavvyCal).

📋 Requirements

• An n8n instance (Cloud or self-hosted).
• An OpenAI API key.
• A Google account for Google Sheets and Gmail.
• A Slack workspace.
• A job application source capable of sending webhooks.