How We Built a Resume Formatter That Saves 20 Hours a Week
A staffing firm came to us with a problem that’s common in the industry but rarely talked about: resume formatting. Every candidate submission had to be reformatted into the firm’s branded template before being sent to clients. One person was spending 25+ hours a week doing nothing but copying, pasting, and reformatting resumes.
The Problem
The manual process looked like this: receive a resume (PDF, DOCX, or even plain text), read through it, extract relevant information, remove personally identifiable information (PII) like Social Security numbers and home addresses, restructure the content into the firm’s branded template, and export as a clean DOCX file.
Each resume took 15-20 minutes. With 80-100 resumes per week, one full-time employee was dedicated entirely to this task. It was tedious, error-prone, and a bottleneck in the candidate submission pipeline.
The Solution
We built an automated pipeline using n8n (self-hosted) and Claude AI that handles the entire process in under 60 seconds per resume.
Step 1: File Upload Trigger. Resumes are uploaded to a watched Google Drive folder. n8n detects the new file and kicks off the workflow.
Step 2: Document Parsing. The resume is parsed — whether it’s a PDF, DOCX, or text file — and the raw content is extracted.
Step 3: AI Processing. Claude AI receives the raw content with specific instructions: extract the candidate’s professional experience, education, skills, and certifications. Identify and remove any PII. Restructure the content according to the firm’s template format.
Step 4: PII Scrubbing. A dedicated validation step scans the AI output for any remaining PII patterns (SSN formats, full addresses, dates of birth) as a safety net.
Step 5: Template Generation. The structured content is injected into a branded DOCX template with the firm’s logo, fonts, and formatting standards.
Step 6: Output. The finished resume is saved to an output folder and the team is notified via email.
The Results
The numbers speak for themselves. Processing time went from 15-20 minutes per resume to under 60 seconds. The employee who was dedicated to formatting was reassigned to candidate sourcing — a revenue-generating activity. PII compliance improved because the scrubbing is consistent and automated, not dependent on a human catching every instance.
Weekly time savings: 20+ hours. Monthly cost savings: approximately $3,000 in labor reallocation. The automation paid for itself in the first week.
Lessons Learned
AI is excellent at content extraction and restructuring, but it needs clear instructions. The quality of the output is directly proportional to the quality of the prompt. We iterated on the prompt engineering for about a week before the output consistently matched the firm’s standards.
The PII scrubbing safety net turned out to be essential. AI catches most PII, but having a regex-based validation layer as a backup provides the compliance confidence the firm needed.
Want to see the full project details? Check out the case study.