Speed up hiring by collecting job applications in one place. A hosted form captures details, reads the resume, scores the fit, and files everything to a sheet. Ideal for HR teams and recruiters handling many applicants for one role.

The form trigger starts the flow when a candidate submits. The resume PDF is converted to text for analysis. Google Gemini reviews the text with a focused prompt and returns a short summary and a 1 to 10 score in under 75 words. n8n then writes the candidate info, file name, AI score, and notes into Google Sheets for tracking. After the row is saved, Gmail alerts HR and then sends a polite receipt to the applicant. All steps run without manual copy paste.

Setup needs Google Sheets, Gmail, and a Google Gemini key. Align the resume file field with the PDF extractor, and map your sheet columns to the form fields. Expect review time per resume to drop from about 30 minutes to 2 minutes, with cleaner data and faster follow up for roles like interns, junior engineers, or campus hiring. Small teams can handle more candidates without adding headcount. Share the form link on your careers page or social posts to start collecting right away.

• Hosted application form trigger collects contact details and a resume file upload.
• PDF text is extracted from the uploaded resume for fast reading.
• Google Gemini analyzes the text and returns a brief 75 word summary and a 1 to 10 score.
• Candidate details, AI score, summary, and file name are appended to Google Sheets.
• Gmail sends an alert to HR after the sheet is updated, then emails a receipt to the applicant.
• Dynamic expressions map form fields into emails and sheet columns with no manual copy paste.

• Reduce manual review per resume from 30 minutes to 2 minutes
• Automate 100 percent of candidate logging to Google Sheets
• Improve data accuracy by about 90 percent by using form fields
• Handle up to five times more applications without extra staff
• Connect Gmail, Google Sheets, and Google Gemini 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'll need accounts with Google Sheets, Gmail and Google Gemini. See the Tools Required section above for links to create accounts with these services.
3. Open the Gmail nodes in n8n, click Credentials, choose Create new credential, select Gmail OAuth2, and follow the on screen steps to sign in and grant send permissions.
4. Open the Google Sheets node, click Credentials, choose Create new credential, select Google Sheets OAuth2, and connect the account that owns your spreadsheet.
5. Open the Google Gemini model node, click Credentials, choose Create new credential, and paste your API key from the Google AI Studio API page. Name the credential clearly, such as Gemini HR Scoring.
6. Configure the Application Form node: confirm fields for Full Name, E-mail, expected salary, LinkedIn, GitHub, and a file upload for the resume. Copy the exact key used for the resume field.
7. In the Extract From File node, set Operation to PDF and set Binary property name to match the resume field key from the form. If the key uses spaces, match the exact name shown in the incoming data.
8. Open the AI Analysis node and ensure the Text field points to {{$json.text}} from the extractor. In the Language Model input, select the Gemini credential you created.
9. Open the Google Sheets node, choose your spreadsheet and worksheet, and map columns to the form fields and AI outputs. Make sure your sheet has header names that match what you plan to append.
10. In the HR email node, set the recipient to your HR inbox. Use the dynamic fields from the form for candidate name and other details.
11. In the applicant confirmation email node, set the To field to the E-mail value from the form. Keep the subject and message clear and friendly.
12. Test end to end: submit the form with a sample PDF resume. Confirm a new row appears in Google Sheets with the AI score and summary, then check HR and applicant mailboxes for both emails.
13. Troubleshoot common issues: if the summary is empty, ensure the resume is a text based PDF rather than a scanned image. If the sheet does not update, verify column mappings. If emails fail, recheck Gmail credentials and sender permissions.