CNexa Solutions
← All selected work

CASE STUDY 03 / RECRUITMENT OPERATIONS

HR recruitmentAutomation.

Structure application evidence and coordinate interview scheduling, with explicit review criteria, audit records, and human hiring decisions.

Portfolio demonstrationIndependent portfolio project · John Rey Cretesio

System overview

Inspect the workflows

Applications move through structured evidence collection, human review, and coordinated scheduling, with explicit criteria and a traceable record.

  1. Application received

    Collect application attachments and job definitions, with intake state recorded for subsequent processing.

  2. Evidence structured

    Extract candidate evidence with AI assistance and score it against versioned, approved job criteria.

  3. Human shortlists

    People decide who advances. Structured evidence supports review, with hiring decisions retained by staff.

  4. Interview booked

    Validate the selected slot, reserve it atomically, and coordinate calendar creation with recovery paths.

Deterministic scoring · audit history

Explicit criteria
Versioned job definitions and deterministic scoring keep the screening rules inspectable.
Booking consistency
Atomic reservations and compensation paths handle partial calendar or booking failures.
Audit & operations
Scheduling audit records, reporting verification, and health checks support operational review.

THE CHALLENGE

The operational challenge.

Recruitment spans attachments, job criteria, reviewer decisions, and calendar availability. Those steps need consistent state and a record of who decided what.

THE SOLUTION

The system design.

This demonstration uses AI to extract candidate evidence, deterministic rules to score it against approved job definitions, and human review to decide who advances. Scheduling includes explicit reservation and recovery logic.

DESIGNING THE SYSTEM

Key engineering decisions.

01

Separate evidence from judgment.

AI assists with evidence extraction. Versioned job definitions and weighted scoring keep criteria explicit, while people retain shortlist and rejection decisions.

02

Treat booking as a transaction.

Confirmation pages use GET; booking actions use POST. Atomic reservations, deterministic calendar identifiers, and compensation paths handle partial failures.

03

Leave a traceable record.

An append-only audit records scheduling actions. Protected schedule management uses basic authentication and an allowlist, with reporting verification.

SYSTEM ARCHITECTURE

Integrations and recovery paths.

The overview above shows the main path. Explore the architecture for the integrations, decision points, and recovery paths behind it.

Project architecture. Expand to inspect details; on small screens, scroll across the full-size diagram.
Database setupOpen original ↗

Manual setup canvas for the HR tables, scheduling records, constraints, audit history, and supporting database functions.

Manual setup · Original size · scroll horizontally and vertically to inspect
Full-size n8n canvas: Database setup
Job-description ingestionOpen original ↗

Loads job-definition inputs, checks ingestion state, and records structured criteria for subsequent screening.

Original size · scroll horizontally and vertically to inspect
Full-size n8n canvas: Job-description ingestion
Resume intake & screeningOpen original ↗

Connects application intake, attachment handling, evidence extraction, structured screening, and reviewer communication.

Original size · scroll horizontally and vertically to inspect
Full-size n8n canvas: Resume intake & screening
Interview schedulingOpen original ↗

Shows booking validation, atomic slot reservation, calendar creation, and compensation paths for incomplete bookings.

Original size · scroll horizontally and vertically to inspect
Full-size n8n canvas: Interview scheduling
Interview schedule managementOpen original ↗

Coordinates schedule-management requests, availability, reservations, cancellation, and calendar state.

Original size · scroll horizontally and vertically to inspect
Full-size n8n canvas: Interview schedule management
Reporting dashboard synchronizationOpen original ↗

Synchronizes application and interview-slot records to Google Sheets and verifies the resulting dashboard state.

Original size · scroll horizontally and vertically to inspect
Full-size n8n canvas: Reporting dashboard synchronization
Monitoring & operationsOpen original ↗

Connects failure handling and scheduled health checks to operational alerts and notification-state updates.

Original size · scroll horizontally and vertically to inspect
Full-size n8n canvas: Monitoring & operations
Candidate assessment summary · Sample outputOpen original ↗

The sample report summarizes résumé evidence and presents an advisory score and shortlist recommendation for a reviewer.

Sample candidate report with an advisory score, evidence confidence, shortlist recommendation, and résumé summary.
Weighted criteria and evidence · Sample outputOpen original ↗

The breakdown connects weighted criteria and ratings to supporting résumé statements, so the reviewer can inspect the basis of the recommendation.

Sample assessment breakdown showing weights, ratings, and résumé evidence for workflow development and API integration.
Human decision controls · Sample outputOpen original ↗

The review interface keeps the final decision with HR and provides Reject and Shortlist actions. The screenshot does not show a completed decision.

Final HR review notice stating that the recommendation is advisory, with Reject and Shortlist buttons.
Interview scheduling invitation · Sample outputOpen original ↗

The invitation offers three interview slots in Philippine Time, with a selection action for each option.

Interview invitation for an n8n Automation Developer role offering three thirty-minute time slots in Philippine Time.
Calendar interview confirmation · Sample outputOpen original ↗

The calendar invitation presents the confirmed interview time, Google Meet access, and RSVP controls. This is a confirmation example rather than the available-slot invitation above.

Redacted Google Calendar invitation with confirmed interview time, Google Meet access, and RSVP controls.

EVIDENCE & OUTCOMES

What the evidence shows.

The PDF reports controlled tests rejecting unauthorized requests and retaining create/cancel audit records. Reporting tests synchronized 17 application rows and 16 slot rows; four issues exercised alert cooldown.

Design principleHuman-led hiring decisions

Seven documented workflows and 195 nodes in an independent portfolio demonstration, including one manual database setup workflow.

Limitations and next steps.

This is not a production HR platform. Production identity controls, retention rules, invitation tokens, a delivery outbox, and load/security testing remain on the roadmap.

Technology stack.

  • n8n
  • PostgreSQL
  • Google Drive
  • Gmail
  • Google Calendar
  • AI extraction
Download case study

Source: owner-supplied case study and diagrams. Scope and test results are reported in the document, not independently audited.

Architecture · scroll to exploreOpen image ↗
HR recruitment automation full architecture diagram