Capture job applications through a simple form, read each CV, and score the candidate against your hiring profile. Results go straight into Google Sheets while the CV file is saved to Google Drive. Teams use it to screen faster with clear, consistent scores and notes.

A public form collects name, email, and a CV file. The file uploads to a Drive folder and the text is extracted for analysis. AI pulls personal data like city, phone, and birthdate, and extracts core qualifications. The system then creates a short summary. An HR agent prompt compares the summary to your hiring profile and returns a vote from 1 to 10 plus a short comment. A structured parser forces clean fields. The sheet receives city, name, date, vote, and the comment in one row.

You need a Google account, an OpenAI API key, and a Google Sheet ready to store results. Set your role requirements once in the profile step and select your Drive folder in the upload step. Expect review time per CV to drop from about 10 minutes to around 1 minute, with cleaner data and a steady pipeline for high volume hiring, internship intakes, or agency screening.

• Form intake captures name, email and a CV file for each applicant
• Automatic upload of the CV to a Google Drive folder with a timestamped file name
• PDF text extraction to prepare the CV for AI analysis
• AI extraction of personal data such as city, phone and birthdate
• AI extraction of key qualifications and experience from the CV
• Concise candidate summary generated for quick HR review
• Custom job profile stored in a profile step to guide scoring
• HR agent prompt returns a vote from 1 to 10 and a short consideration using a structured parser
• Merge and mapping steps combine fields cleanly for downstream use
• Append results to Google Sheets with city, name, date, vote and comment

• Reduce manual review from about 10 minutes per CV to around 1 minute
• Automate up to 80 percent of screening steps from file handling to scoring
• Improve data accuracy by roughly 90 percent by removing copy and paste
• Handle up to 5 times more applicants with the same team
• Connect Google Drive, Google Sheets and AI in one unified 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'll need accounts with Google Sheets, Google Drive and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create an OpenAI credential by selecting API Key. Get the key from your OpenAI dashboard, paste it into n8n, name the credential clearly, and save.
4. Double click the Google Drive node, open the Credential to connect with dropdown, click Create new credential, then follow the on screen steps to connect your Google account and grant Drive access.
5. Double click the Google Sheets node, create a new Google Sheets credential, sign in with the same Google account, and allow Sheets access.
6. Open the Form Trigger node and confirm the fields include Name, Email and a file upload named CV. Copy the public form URL for testing.
7. Open the Upload CV node and choose your Drive folder. Keep the dynamic file name so files are easy to trace.
8. In the Extract from File node, set the operation to PDF and the binary property name to CV, matching the form file field.
9. Open the Personal Data and Qualifications nodes and ensure the language model is set to your OpenAI credential. Keep the provided schemas so the output stays consistent.
10. Review the Summarization node and confirm it references city, birthdate and education fields from the extraction steps.
11. Edit the Profile Wanted node text to match the role you are hiring for. Add specific skills and experience so scoring is relevant.
12. In the HR Expert node, keep the structured output parser connected so the vote and consideration come back as clean fields.
13. Configure the Google Sheets node with your spreadsheet and sheet name. Map city, date, name, vote and consideration to the correct columns.
14. Run a test: submit the form with a sample PDF CV. Check Google Drive for the uploaded file, review the n8n execution data for extracted fields, and confirm a new row appears in Google Sheets.
15. Troubleshoot common issues: if text is missing, confirm the CV is a searchable PDF and not a scanned image. If Sheets does not update, verify the document ID and your credential permissions. If AI calls fail, check the OpenAI key and model name.