Automated Resume Review System Using OpenAI + Google Sheets

Who is this for? This workflow is ideal for:

• HR teams and recruiters seeking to streamline resume screening.
• Hiring managers who want quick, summarized candidate insights.
• Recruitment agencies handling large volumes of applicant data.
• Startups and small businesses looking to automate hiring without complex systems.
• AI and automation professionals who want to build smart HR workflows using n8n and OpenAI.

What problem is this workflow solving? / Use Case

• Manually reviewing resumes is time-consuming, inconsistent, and prone to human bias.
• This workflow automates the resume intake and evaluation process—ensuring that each applicant is screened, summarized, and scored using a consistent, data-driven method.
• It enhances efficiency and supports better hiring decisions.

What this workflow does

• Accepts resume submissions via form and saves files to Google Drive.
• Extracts key information from resumes using AI (e.g., name, contact, education, experience).
• Summarizes candidate qualifications into a short, readable profile.
• Allows HR to rate applicants and leave comments.
• Logs all extracted data and evaluations into a centralized Google Sheet for tracking.

Setup

• Resume is submitted through an n8n form.
• The uploaded file is automatically stored in Google Drive.
• n8n uses OpenAI and document parsing tools to extract candidate data.
• Extracted information is structured and summarized using GPT.
• A review form is triggered for internal HR rating and notes.
• All data is appended to a Google Sheet for records and filtering.

How to customize this workflow to your needs

• Change the form tool (e.g., Typeform, Tally, or custom HTML) based on your stack.
• Adapt the summary prompt to align with your specific role requirements.
• Add filters to auto-flag top-tier candidates based on score or skills.
• Integrate Slack or email to notify hiring managers when top resumes are processed.
• Connect to your ATS if you want to push processed resumes into your recruitment system.