Who is this for?
Ideal for HR teams and recruiters who receive candidate applications directly via email and want to save time collecting and organizing CV data.
What problem is this workflow solving?
Recruiters often have to open each application email, download the attached CV, read the content, and manually enter candidate details into spreadsheets. This repetitive process takes hours and increases the risk of missing or misrecording information.
What this workflow does
This workflow automatically reads incoming candidate emails and extracts useful data into a structured Excel file:
- Monitors the HR mailbox for new applications.
- Reads email content and downloads attached CV files.
- Uses OCR technology to extract text and candidate details from the files.
- Parses and organizes the extracted data into an Excel sheet automatically.
This allows your HR team to quickly access clean, organized candidate data without manual input.
How to set up this workflow?
Powered by n8n, this workflow integrates:
- Gmail or your HR email inbox
- OCR service (e.g., Gemini, Google Vision, or similar)
- Excel/Google Sheets for structured output
To activate: Connect your HR mailbox and OCR service, set your Excel or Google Sheet destination, and start the workflow. It will begin processing incoming emails automatically.
How to customize this workflow to your needs
- Add specific data fields such as skills, position applied, or contact number.
- Modify file output format (Excel or Google Sheets).
- Filter by sender or subject line (e.g., only process “Job Application” emails).
- Change file naming or folder storage structure in Drive.
- Integrate with your Applicant Tracking System (ATS) to sync candidate status and update the talent pools automatically.
Need help customizing?
Please contact hello@icts.io for any custom request.
