Extract and Process CV Data
detail.loadingPreview
Extracts information from uploaded CVs, processes it, and saves it to Google Sheets.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow automates the process of receiving CVs submitted through a form, extracting key information like educational qualifications, job history, and skills using AI, summarizing the extracted data, and then populating a Google Sheet with the processed candidate information.
Key Features
- Form submission trigger for CV uploads.
- AI-powered extraction of educational qualifications, job history, and skills from PDF CVs.
- Data summarization for a concise overview.
- Automatic population of a Google Sheet with candidate data.
- Handles PDF file uploads.
How To Use
- Set up the Form Trigger: Configure the 'On form submission' node with a form title and fields for Name, Email, and CV (PDF only).
- Configure Extract from File: Ensure the 'CV' binary property name matches the file upload field in the form.
- Define Extraction Attributes: In the 'Qualifications' node (Information Extractor), specify the attributes to extract: 'Educational qualification', 'Job History', and 'Skills', along with their descriptions.
- Set up Google Sheets Integration: Provide the correct Google Sheets Document ID and Sheet Name.
- Map Columns: In the 'Google Sheets' node, map the desired columns to the extracted and processed data. Ensure correct references to other nodes using
$('NodeName').item.json.... - Test the Workflow: Submit a test CV through the form to verify data extraction and sheet population.
Apps Used
Workflow JSON
{
"id": "ea71f00a-235f-41de-94e2-e8595ca50b30",
"name": "Extract and Process CV Data",
"nodes": 0,
"category": "Data Processing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: ea71f00a-235f...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Verification Info
Related Integrations
- Google Sheets + Schedule Trigger(394 workflows)
- Google Sheets + Split Out(277 workflows)
- Google Sheets + Slack(268 workflows)
- Gmail + Google Sheets(245 workflows)
- Google Drive + Google Sheets(203 workflows)
- Form Trigger + Google Sheets(163 workflows)
- Google Drive + Google Drive Trigger(135 workflows)
- Google Drive + Split Out(134 workflows)
- Google Sheets + Telegram(118 workflows)
- Execute Workflow Trigger + Google Sheets(101 workflows)
Related Workflows
Discover more workflows you might like
Stripe Checkout Session Metadata Generator
Generates metadata for Stripe checkout sessions based on custom fields.
Remove PII From CSV Files
Automatically removes personally identifiable information (PII) from CSV files stored in Google Drive.
Extract and Process Product Brochure
Extracts text from a product brochure PDF, creates embeddings, and stores them for querying.
Get n8n Executions to CSV
Retrieve all n8n workflow executions and convert them to a CSV file.
Parse DMARC Reports
This workflow parses DMARC reports received via IMAP and stores the data in a MySQL database.
Google Drive CSV PII Remover
Automatically removes Personally Identifiable Information (PII) from CSV files uploaded to Google Drive.