AI Candidate Scoring n8n Workflow: Webhook to Gmail & Sheets

Instant AI Candidate Scoring from Webhook to Gmail & Google Sheets

This AI Candidate Scoring n8n workflow automatically receives job applications via a Webhook, stores resumes in Google Drive, logs all details in Google Sheets, and uses OpenAI to score questionnaire answers and summarize the CV—then emails either an interview invite or an HR review request based on the score.

What this workflow does

• Receives candidate submissions via a POST webhook with candidate details, questionnaire answers (question_1–question_10), a submissionId, and a base64-encoded resume.
• Processes the resume by cleaning the base64 payload, converting it into a file, uploading it to Google Drive, and capturing the Drive sharing link.
• Logs to Google Sheets by appending a new row (including SubmissionID, contact details, resume link, and consolidated question/answer text).
• Scores with OpenAI by sending the questionnaire answers and resume content to OpenAI, then parsing the response into structured fields such as score, CV summary, strengths, and weaknesses.
• Updates the same Sheets row matched by SubmissionID with the AI score and assessment fields.
• Triggers email decisions: if score > 7, sends the candidate an interview scheduling email via Gmail and notifies HR; otherwise, emails HR to manually review the candidate in Google Sheets and submit a decision.

Use cases

• Automating intake and screening for high-volume hiring using AI candidate scoring.
• SaaS recruiting teams that want one-click routing to interviews vs. HR review.
• Operators deploying an n8n workflow for secure resume storage (Drive) and audit-friendly tracking (Sheets).

Technical details

• Webhook for POST submissions (candidate_name, email, question_1–question_10, submissionId, resume in base64).
• Google Drive for resume upload and sharing link capture.
• Google Sheets for append + row update by SubmissionID.
• OpenAI for questionnaire scoring and CV summarization with structured parsing.
• Gmail for conditional candidate/HR email notifications.
• Workflow logic uses nodes such as if, set, code, and supporting notes (sticky note).