Automated Resume Review System Using OpenAI + Google Sheets
Configured with Chain LLM, Chain Summarization, Extract From File, Form Trigger, and additional nodes. Review the connections and setup before adapting this template.
Node categories in this workflow
- Trigger
- Transform
- Data store
- AI & models
- Files / media
Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.
Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.
How it works
The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.
| Node | Category | Type | Operation |
|---|---|---|---|
| On form submission | Trigger | Form Trigger | See node parameters |
| Merge | Transform | Merge | See node parameters |
| Structured Output Parser | Transform | Output Parser Structured | See node parameters |
| Google Sheets | Data store | Google Sheets | append |
| Personal Info | AI & models | Information Extractor | See node parameters |
| Qualification | AI & models | Information Extractor | See node parameters |
| HR Expert | AI & models | Chain LLM | See node parameters |
| Upload to google drive | Files / media | Google Drive | See node parameters |
| Resume extraction | Transform | Extract From File | |
| wanted profile | Transform | Edit Fields | See node parameters |
| Summarizer | AI & models | Chain Summarization | See node parameters |
| OpenAI Chat Model | AI & models | OpenAI Chat Model | See node parameters |
Setup
- Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
- Connect your own credentials through n8n’s credential store. Replace
REPLACE_WITH_*values with your resource identifiers. - Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
- Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.
Requirements
An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.
Credential types declared in the source
googleDriveOAuth2ApigoogleSheetsOAuth2ApiopenAiApi
Workflow notes
Submission, Saving to Google Drive & Extraction
Submission, Saving to Google Drive & Extraction
Captures user info from the form. Uploads resume to Google Drive. Extracts data from the PDF (resume).
Extraction (Personal Info & Qualification)
Extraction (Personal Info & Qualification)
Extracts personal details (name, city, etc.). Retrieves educational qualifications and job history.
Merge & Summarization
Merge & Summarization
Merges extracted information. Generates a concise professional summary.
Voting, Consideration & Google Sheets
Voting, Consideration & Google Sheets
**HR expert reviews and analyzes the summary.
Assigns a rating (1-10) and provides hiring insights.
Appends all details to Google Sheets for record-keeping.**
Automated Resume Processing & Evaluation System
Automated Resume Processing & Evaluation System
This workflow streamlines the process of handling resume submissions, extracting key details, summarizing qualifications, and aiding HR in the decision-making process.
1. Submission, Saving to Google Drive & Extraction
The user submits a resume via a form. The system saves the uploaded file to Google Drive for record-keeping. AI-powered text extraction retrieves personal details, qualifications, and job history from the document.
2. Extraction (Personal Info & Qualification)
The workflow identifies and extracts key details such as the candidate’s name, contact information, and location. It scans for educational background, certifications, and past work experiences.
3. Merge & Summarization
The extracted data is merged into a structured format. A concise summary is generated, highlighting the candidate’s most relevant qualifications and experiences.
4. Voting, Consideration & Google Sheets
HR reviews the summarized profile and assigns a rating (1-10). Hiring insights and comments are recorded for evaluation. All processed data, including extracted details and review scores, are appended to a Google Sheet for tracking and further consideration.
Automated Resume Review System Using OpenAI + Google Sheets
Automated Resume Review System Using OpenAI + Google Sheets
Purpose and structure
This folder contains the Automated Resume Review System Using OpenAI + Google Sheets workflow. Its executable nodes use chainLlm, chainSummarization, extractFromFile, formTrigger, googleDrive, googleSheets, informationExtractor, lmChatOpenAi, merge, outputParserStructured, set. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.
Setup
Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.
Entry points
On form submission
Verification
Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.
Attribution
https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Extractfromfile/1501_Extractfromfile_Form_Automate_Triggered.json MIT; preserve source notices.