Collect job applications from a web form, read the CV, and score fit automatically. HR teams get a fast first pass that ranks candidates and saves time.

When a candidate submits the form, the file uploads to Google Drive and the text is extracted from the CV. Two AI extractors pull key details in parallel. One gathers personal data like city and birthdate. The other collects qualifications such as education and skills. The results merge and a short summary is created. A hiring profile is set, and an HR expert prompt compares the summary with the role. The system outputs a clear vote and a short note. All results are written to Google Sheets with name, city, date, vote, and comments.

Set up needs a Google account for Drive and Sheets and an OpenAI key. Choose the Drive folder for CVs and pick the target spreadsheet and sheet. Test with a sample CV and check that a new row appears with the evaluation. Teams can expect faster screening and better data capture. Great for agencies, internal HR, and fast growing teams that need to process more CVs with the same staff.

• Form intake captures name, email, and the CV file in one step
• Automatic upload to Google Drive with a dated file name for easy tracking
• PDF text extraction converts the CV into clean text for analysis
• AI data extraction pulls personal details like city and birthdate
• AI qualifications extractor gathers education, skills, roles, and languages
• Summarization creates a short candidate profile for quick reading
• HR expert scoring returns a vote and a clear written note using structured output
• Google Sheets append logs city, name, date, vote, and comments for reporting

• Reduce manual review from 20 minutes to 2 minutes per CV
• Automate up to 80 percent of first pass screening
• Improve data quality by 90 percent with structured fields
• Handle 5 times more applications with the same team
• Connect Google Drive and Google Sheets in one flow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You will need accounts with Google Drive, Google Sheets and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. Open the Form Trigger node and review the fields for name, email, and file. Confirm the file field will be used to upload the CV.
4. Open the Google Drive upload node and select your Drive and target folder for CV storage. Keep the input field mapped to the CV file.
5. Open the Extract from File node and confirm the binary property name matches the CV field. Set the file type to PDF.
6. Open the Personal Data and Qualifications extractor nodes and keep the schemas as provided. These control what details are captured from the CV.
7. Review the Summarization node prompt and confirm it references the extracted fields like city, birthdate, and qualifications.
8. Open the Set node for the hiring profile and edit the role description to match your open position and skill targets.
9. Open the HR Expert node and confirm the structured output contains vote and consideration. This ensures clean data goes to the sheet.
10. Open the Google Sheets node, choose your spreadsheet and sheet, and confirm each column mapping like city, date, name, vote, and comments.
11. In the n8n credentials manager, connect Google Drive and Google Sheets with OAuth and add your OpenAI API key. If unsure, open each node, choose Create new credential, and follow the on screen steps.
12. Run a test by submitting the form with a sample PDF CV. Check Google Drive for the file and confirm a new row appears in Google Sheets with the vote and note.
13. Troubleshoot by verifying the CV field name is consistent across the Form, Upload, and Extract nodes. If values are missing, adjust the extractor prompts and test again.