Collect resumes through a simple form and turn each submission into a structured candidate profile. Files are stored, key details are extracted, and a clear summary and rating are produced. Ideal for HR teams that need fast first pass screening at scale.

When a candidate submits the form, the file is saved to Google Drive. Text is pulled from the resume and two AI extractors capture personal info and qualifications. Their results are merged and summarized. A desired profile is set, then an HR expert model compares the summary to that profile, assigns a score from 1 to 10, and explains why. A structured parser keeps vote and consideration fields clean, and all fields are appended to Google Sheets for tracking. The sheet can hold contact info, city, birthdate, rating, and review notes.

You will need Google accounts for Drive and Sheets plus an OpenAI key. Expect faster screening and a clean database without manual typing. Great for campus recruiting, high volume roles, and distributed teams that want one source of truth with stored files and logged reviews.

• Form submission trigger collects names, email, and the resume file while ignoring bot traffic.
• Uploads each file to Google Drive for safe storage and later access.
• Extracts text from the resume so AI can read and analyze the content.
• Pulls personal info like name, city, email, and phone using a dedicated extractor.
• Captures education and work history with a second extractor focused on qualifications.
• Merges both extraction results into one structured record for clean processing.
• Creates a concise professional summary that highlights key strengths.
• Uses an HR expert model with a structured parser to return a score and hiring notes.
• Appends all fields to Google Sheets with mapped columns for easy reporting.

• Reduce manual resume review from 20 minutes to under 3 minutes per applicant
• Automate up to 80 percent of first pass triage
• Cut data entry errors by 90 percent with structured parsing
• Handle 10 times more applicants with the same team size
• Connect form intake, Google Drive storage, and Google Sheets tracking
• Keep a clear audit trail with files and sheet rows linked

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 a Google Drive credential. Choose OAuth2, sign in with the correct Google account, grant access, and name it clearly, for example HR Google Drive.
4. Create a Google Sheets credential in the credentials manager. Use OAuth2, sign in with the same Google account that owns the sheet, grant access, and name it HR Google Sheets.
5. Create an OpenAI API Key credential. In your OpenAI account, generate an API key on the API page, paste it into n8n, and name it HR OpenAI. Select a chat model in the OpenAI Chat Model node.
6. Open the Form Trigger node. Review the form title and fields for first name, last name, email, and file upload. Keep Ignore bots enabled. Copy the public form URL for testing.
7. Open the Upload to Google Drive node. Pick the target folder for resume storage. Map the incoming file field from the form. Run a test submission and confirm the file appears in the folder.
8. Open the Resume extraction node. Make sure it uses the file from the form step. Execute the node on a sample file to confirm text extraction works.
9. Open the Personal Info and Qualification nodes. In each, select the OpenAI credential. Keep the provided schemas and prompts. Run each node to see clean JSON for personal details and qualifications.
10. Check the Merge node. Mode should be Combine All so both extractor outputs become one record. Test the node to verify fields are combined.
11. Review the Summarizer and the wanted profile Set node. Enter your target role profile. Confirm the HR Expert node uses the same OpenAI credential and is connected to the Structured Output Parser with vote and consideration fields.
12. Open the Google Sheets node. Select the spreadsheet and the correct sheet tab. Map fields like email, city, birthdate, vote, and comments. Append a test row and confirm it appears in the sheet.
13. Activate the workflow. Submit a live form with a real resume, then check Google Drive for the file and Google Sheets for the new row. If rows do not appear, verify sheet permissions for the connected Google account, confirm Drive folder access, and check OpenAI quota and parser output.