Contra - A professional network for the jobs and skills of the futureAutomate HR Document Management: Efficient Onboarding Workflow
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Heber's avatar
Heber Conrado
• Apr 26
N8N HR Document Automation Flow — Portfolio Explanation
Overview
This workflow automates the process of onboarding new employee files into an organized Google Drive structure. Whenever a new file is uploaded to Drive, the system automatically identifies the employee, validates them against a roster, notifies them by email, and logs everything — all without any manual intervention.
Integrations Used
IntegrationPurposeGoogle DriveDetects new files and moves them to the correct folderGoogle SheetsStores the employee registry for lookupGmailSends notifications and admin alertsN8N Code NodeExtracts and parses data from the file
Flow Breakdown
1. Trigger — New File on Drive
Novo Arquivo no Drive
The flow is triggered automatically whenever a new file is created in a monitored Google Drive folder. This is the entry point — no manual action needed.
2. Extract Name & Data from File
Extrair Nome e Dados do Arquivo
A Code node parses the uploaded file to extract key information — primarily the employee's name and any relevant metadata embedded in the file name or content.
3. Search Employee in Spreadsheet
Buscar Funcionário na Planilha
Using the extracted name, the flow queries a Google Sheets spreadsheet (the employee registry) to check whether this person exists in the system.
4. Employee Found? (Conditional Branch)
Funcionário Encontrado?
A Switch/Router node evaluates the lookup result and splits the flow into two paths:
✅ Path A — Employee Found (True)
StepActionMove to Employee FolderThe file is moved to that employee's dedicated Google Drive folderNotify Employee by EmailA Gmail message is sent to the employee confirming the file was receivedSuccess LogA record is written to a Google Sheets log (append/update)
❌ Path B — Employee Not Found (False)
StepActionError LogThe failed attempt is recorded in a separate Google Sheets error logAlert Admin by EmailGmail sends an alert to the administrator reporting the unrecognized file
Key Features
✅ Fully automated — triggered by file upload, zero manual steps
✅ Smart file routing — files land in the right employee folder automatically
✅ Validation layer — cross-references a live employee spreadsheet before acting
✅ Dual-path error handling — failures are logged and the admin is immediately notified
✅ Audit trail — both successes and errors are recorded in Google Sheets
✅ Email notifications — employees and admins are kept in the loop automatically
Software DevelopmentN8NGoogle DriveGmailAI Engineer AI Agent Designer
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started