I need an automation to sort CVs, send the same emails to the selected candidates, then create the same interview summaries, and send a report with the best profiles to the CEO.
Hi
Can suggest ideas based on exactly what you are trying to achieve:
- where is your CV data? Google drive or some file storage?
- Whats the criteria for you to sort CVs? Based on file metadata- date etc or content- example: performance.
- where are the candidate emails, within the CV?
- where are intervew summaries and how are they linked to CVs?
- How do you define a ‘best’ profile?
A good way to split this is into 4 small workflows instead of one big one:
- Intake: watch the folder/form where CVs arrive and save each candidate as one item with the original file, email, and source.
- Screening: extract the CV text, then score it against your criteria. I would keep the criteria in a Google Sheet or Airtable table so the CEO can change it without editing the workflow.
- Candidate email: only send emails after a manual review step, at least at the beginning. That avoids sending the wrong template to the wrong person while you tune the sorting.
- Summary/report: create one short structured summary per candidate, then aggregate the top profiles into a single report for the CEO.
The main details to define first are: where the CV files arrive, what the selection criteria are, where candidate email addresses should be read from, and what format the CEO report should have. Once those are clear, the n8n workflow becomes much easier to build.