Skip to content
FlowHubFluxonLab
B
AI Automationfree

Automated Resume Review System Using OpenAI + Google Sheets

by Mirza Ajmaladapted from n8n official workflow galleryUpdated Aug 2026
RequiresBBasic LLM ChainGoogle DriveGoogle DriveGoogle SheetsGoogle SheetsInformation ExtractorInformation ExtractorOpenAI Chat ModelOpenAI Chat ModelStructured Output ParserStructured Output ParserSummarization ChainSummarization Chain
Share Post Share
FoOn form submissionOn form submiss…MeMergeOPStructured Output ParserStructured Outp…Google SheetsIEPersonal InfoIEQualificationCLHR ExpertUpload to google driveUpload to googl…EFResume extractionResume extracti…Sewanted profileCSSummarizerOpenAI Chat ModelOpenAI Chat Mod…123456789101112131415
1/5
STEPS · 15
Starts on an incoming request

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.

Tags

n8nreference-onlychain-llmchain-summarizationgoogle-drivegoogle-sheetsinformation-extractorlm-chat-open-aioutput-parser-structured
Connects
BBasic LLM ChaingoogledriveGoogle DrivesheetsGoogle SheetsinformationextractorInformation ExtractoropenaichatmodelOpenAI Chat ModelstructuredoutputparserStructured Output Parser
CategoryAI Automation
Triggermanual
Complexitycomplex
Nodes12
AddedMar 25, 2025

Related workflows

See all AI Automation
BsheetsWopenaichatmodel
free

Scrape and score Amazon products with Apify, OpenAI, and Google Sheets

Quick overview This workflow manually scrapes product results from an Amazon search URL via the Apify Amazon Crawler actor, uses OpenAI to generate a structured product analysis (category, key feature, verdict, value score), and appends the enriched results to a Google Sheets spreadsheet. How it works Runs when you manually click “Test workflow” in n8n. Sends the configured Amazon search URL and scraping limits to the apify Amazon Crawler actor and retrieves the dataset items. Filters out any scraper items that are missing a title or contain an error. Uses OpenAI to analyze each product’s title, brand, price, rating, and review count and returns a structured category, key feature, buyer verdict, and 1–10 value score. Combines the scraped fields and AI analysis into a single row format and adds a timestamp. Appends each enriched product as a new row in Google Sheets. Setup Create an apify API token and add it as an HTTP Header Auth credential used by the Apify request. Add an OpenAI API key as an OpenAI credential and choose the model to use in the configuration. Connect a Google Sheets OAuth2 account and select the target spreadsheet, sheet tab, and columns for appending rows. Upda

by Dr. Firas
ACDgmail
free

AI: Summarize podcast episode and enhance using Wikipedia

The workflow automates the process of creating a summarized and enriched podcast digest, which is then sent via email. Note that to use this template, you need to be on n8n version 1.19.4 or later.

by n8n Team
Cgmailgoogledocssheets
free

Turn support emails into FAQ drafts with Gmail, OpenAI, Sheets and Docs

Quick overview This workflow monitors a Gmail inbox for new support-style emails, uses OpenAI to extract a reusable FAQ question and safe draft answer, logs results to Google Sheets, and then creates a Google Docs draft and/or Gmail review drafts for a human reviewer. How it works Polls Gmail every 5 minutes for unread emails matching the configured support-related search query. Cleans the email content by stripping quoted replies, signatures, and HTML to produce a concise plain-text body. Sends the cleaned email and product context to OpenAI to extract a structured FAQ candidate (question, draft answer, category, score, sensitivity flag, tags, and recommended action). Calculates a routing status based on the FAQ score threshold and sensitivity/recommended action, and prepares draft text for a Google Doc and reviewer email. Appends every processed email and extracted fields to a Google Sheets tab for tracking and reporting. If the candidate is strong, creates a Google Docs FAQ draft, inserts the draft content, and creates a Gmail draft notification to the reviewer with the document link. If the candidate needs manual handling, creates a Gmail draft to the reviewer with the review n

by Dr. Firas