{"product_id":"reactivate-candidates-workflow-ollama-qdrant-postgres-n8n","title":"Reactivate Candidates Workflow: Ollama + Qdrant + Postgres (n8n)","description":"\u003ch3\u003eReactivate Candidates with AI: Ollama + Qdrant + Postgres in n8n\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n automation workflow\u003c\/strong\u003e takes a recruitment brief from an n8n form, expands it with \u003cstrong\u003eOllama\u003c\/strong\u003e, searches your historical candidate vectors in \u003cstrong\u003eQdrant\u003c\/strong\u003e, applies a code-based \u003cstrong\u003eretention\/consent compliance gate\u003c\/strong\u003e, then uses \u003cstrong\u003eOllama\u003c\/strong\u003e to rank matches and draft re-approach outreach—while logging every run to \u003cstrong\u003ePostgres\u003c\/strong\u003e and returning an HTML shortlist.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a role brief\u003c\/strong\u003e via an n8n \u003cem\u003eform trigger\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a run ID\u003c\/strong\u003e, formats the brief, and computes \u003cstrong\u003eretention cutoff dates\u003c\/strong\u003e based on your policy configuration.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExpands the brief\u003c\/strong\u003e using \u003cstrong\u003eOllama\u003c\/strong\u003e into \u003cstrong\u003ethree descriptive search queries\u003c\/strong\u003e to improve recall across alternative titles and transferable backgrounds.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns parallel semantic searches\u003c\/strong\u003e against a \u003cstrong\u003eQdrant\u003c\/strong\u003e collection (excluding candidates marked as consent withdrawn) and merges the results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates candidates\u003c\/strong\u003e and enforces a \u003cstrong\u003ecompliance gate\u003c\/strong\u003e in code by calculating each candidate’s retention status from their last activity date—excluding ineligible records before the model sees them.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRanks and drafts outreach\u003c\/strong\u003e with Ollama, verifies returned IDs against the allowed set, and creates messages only for candidates marked contactable.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAudits the run\u003c\/strong\u003e by writing records to \u003cstrong\u003ePostgres\u003c\/strong\u003e and renders a consultant-facing \u003cstrong\u003eHTML report\u003c\/strong\u003e with statuses and draft messages as the webhook response.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRe-activating candidates for a new role while respecting retention and consent rules.\u003c\/li\u003e\n  \u003cli\u003eReducing recruiter workload by generating ranked shortlists and outreach drafts from a brief.\u003c\/li\u003e\n  \u003cli\u003eReviewing an auditable AI candidate selection process via HTML output backed by Postgres logs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOllama\u003c\/strong\u003e: qwen2.5:7b (chat) and nomic-embed-text (embeddings).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQdrant\u003c\/strong\u003e: semantic search across a candidate vector collection.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePostgres\u003c\/strong\u003e: stores an audit record per run.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003emerge\u003c\/em\u003e, \u003cem\u003epostgres\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, \u003cem\u003eform trigger\u003c\/em\u003e, \u003cem\u003erespond to webhook\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45822097588403,"sku":"N8N-18063","price":73.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/DJbN4QzjB0KgjCpWemRh8_2OwlP1TO.png?v=1786526170","url":"https:\/\/buyflowscripts.com\/products\/reactivate-candidates-workflow-ollama-qdrant-postgres-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}