{"product_id":"ai-candidate-scoring-n8n-workflow-webhook-to-gmail-sheets","title":"AI Candidate Scoring n8n Workflow: Webhook to Gmail \u0026 Sheets","description":"\u003ch3\u003eInstant AI Candidate Scoring from Webhook to Gmail \u0026amp; Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eAI Candidate Scoring n8n workflow\u003c\/strong\u003e automatically receives job applications via a \u003cstrong\u003eWebhook\u003c\/strong\u003e, stores resumes in \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, logs all details in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to score questionnaire answers and summarize the CV—then emails either an \u003cstrong\u003einterview invite\u003c\/strong\u003e or an \u003cstrong\u003eHR review request\u003c\/strong\u003e based on the score.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives candidate submissions\u003c\/strong\u003e via a POST webhook with candidate details, questionnaire answers (question_1–question_10), a \u003cstrong\u003esubmissionId\u003c\/strong\u003e, and a \u003cstrong\u003ebase64-encoded resume\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses the resume\u003c\/strong\u003e by cleaning the base64 payload, converting it into a file, uploading it to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and capturing the Drive sharing link.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs to Google Sheets\u003c\/strong\u003e by appending a new row (including SubmissionID, contact details, resume link, and consolidated question\/answer text).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores with OpenAI\u003c\/strong\u003e by sending the questionnaire answers and resume content to OpenAI, then parsing the response into structured fields such as \u003cstrong\u003escore\u003c\/strong\u003e, \u003cstrong\u003eCV summary\u003c\/strong\u003e, \u003cstrong\u003estrengths\u003c\/strong\u003e, and \u003cstrong\u003eweaknesses\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the same Sheets row\u003c\/strong\u003e matched by \u003cstrong\u003eSubmissionID\u003c\/strong\u003e with the AI score and assessment fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers email decisions\u003c\/strong\u003e: if \u003cstrong\u003escore \u0026gt; 7\u003c\/strong\u003e, sends the candidate an \u003cstrong\u003einterview scheduling email\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e and notifies HR; otherwise, emails HR to \u003cstrong\u003emanually review\u003c\/strong\u003e the candidate in Google Sheets and submit a decision.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomating intake and screening for \u003cstrong\u003ehigh-volume hiring\u003c\/strong\u003e using AI candidate scoring.\u003c\/li\u003e\n  \u003cli\u003eSaaS recruiting teams that want one-click routing to \u003cstrong\u003einterviews vs. HR review\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eOperators deploying an n8n workflow for secure resume storage (Drive) and audit-friendly tracking (Sheets).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook\u003c\/strong\u003e for POST submissions (candidate_name, email, question_1–question_10, submissionId, resume in base64).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Drive\u003c\/strong\u003e for resume upload and sharing link capture.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for append + row update by \u003cstrong\u003eSubmissionID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e for questionnaire scoring and CV summarization with structured parsing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e for conditional candidate\/HR email notifications.\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic uses nodes such as \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, and supporting notes (sticky note).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45876853833907,"sku":"N8N-18519","price":23.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/FN9UoLjjtUjc4RX3_i9GT_p6n5Vyx6.png?v=1787303300","url":"https:\/\/buyflowscripts.com\/products\/ai-candidate-scoring-n8n-workflow-webhook-to-gmail-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}