Create a master CV Google Sheet from uploaded CVs with easybits
What This Workflow Does Upload your CV as a PDF and instantly get a structured "Master CV" Google Sheet – every experience, education entry, skill, and contact detail extracted into the right tab. This gives you a clean personal CV database you can reuse across other workflows (job tailoring, application tracking, skills gap analysis).
How It Works Upload – Drop your CV PDF into the n8n web form Extract – easybits Extractor pulls structured data (experiences, education, skills, summary) Fan out – A Code node splits the response into rows for each sheet tab Append – Four parallel branches write to the four tabs of your Master CV sheet Done – A completion screen confirms what was imported
Setup Guide
- Prepare Your Master CV Google Sheet Create a Google Sheet named Master CV with four tabs: Master CV** – columns: role, company, dates, bullets, skills Education** – columns: degree, institution, dates, details Skills** – single column: skill Summary** – columns: full_name, email, linkedin_url, location, summary, languages, links
Leave all tabs empty below the headers – the workflow fills them.
- Install & Connect the easybits Extractor The easybits Extractor is a verified n8n community node. On n8n Cloud it's available out of the box. On self-hosted n8n, install it via Settings → Community Nodes → enter @easybits/n8n-nodes-extractor.
Sign up for a free account at easybits.tech to get an API key. Open the easybits: Extract CV node in this workflow and connect your credential.
- Configure the Extraction Pipeline The Extractor node uses 10 fields to pull structured data from the CV. Paste each description into the corresponding field's description box in the Extractor node:
full_name (string) Candidate's full name as it appears at the top of the CV. Null if not present.
email (string) Email address. Null if not present.
linkedin_url (string) Full LinkedIn profile URL. Null if not present.
location (string) Location as written (e.g., "Berlin, Germany"). Null if not present.
summary (string) Personal summary or "about me" paragraph. Return full text as written, do not paraphrase. Null if no summary section.
experiences (array) Each work experience as an object: role, company, dates (range as written), bullets (array, one per bullet point), skills (array of techs/tools used in this specific role). Preserve original wording of bullets – do not summarize. List in CV order.
education (array) Each entry as an object: degree, institution, dates, details (thesis, GPA, honors – null if none). Empty array if no education section.
skills (array) Flat list of all technical skills, tools, frameworks, methodologies, AND certifications listed anywhere in the CV. Each as a short noun phrase. Deduplicate case-insensitively. Exclude soft skills like "communication".
languages (array) Spoken/written languages as objects: language, proficiency (as written, e.g., "C1", "fluent"). Empty array if none.
links (array) Professional URLs other than LinkedIn (GitHub, portfolio, personal site) as objects: label, url. Empty array if none. Do not include LinkedIn here.
The 10-field cap matches the easybits free plan, so anyone can run this workflow as-is.
-
Connect Google Sheets Open each of the four append nodes (Master CV, Education, Skills, Summary) and connect your Google Sheets credential. Replace the placeholder document ID with your Master CV sheet's ID.
-
Activate & Upload Set the workflow to active, copy the form URL, and upload your CV. Review the four tabs after – minor cleanup is normal, especially for two-column or designer CV layouts.
🔧 Note on the Fan-out Code Node The easybits Extractor wraps its response in a data object, so the Fan-out node reads from $input.first().json.data. The toArray() helper inside the node also handles cases where array fields come back as JSON-encoded strings – making the workflow robust across different Extractor response shapes.
Related Templates
Extract Title tag and Meta description from url for SEO analysis with Airtable
Extract Title tag and meta description from url for SEO analysis. How it works The workflows takes records from Airtabl...
Restore your workflows from GitHub
This workflow restores all n8n instance workflows from GitHub backups using the n8n API node. It complements the Backup ...
Extract Named Entities from Web Pages with Google Natural Language API
Who is this for? Content strategists analyzing web page semantic content SEO professionals conducting entity-based anal...
🔒 Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments