Candidate Lead Management Automation

An end-to-end recruitment automation workflow built with n8n that validates candidate applications, prevents duplicates, stores records in PostgreSQL, and automatically routes applications into role-specific Google Sheets.

Overview

Designed and implemented an automated candidate intake system using n8n to streamline recruitment workflows. The system validates applicant submissions, enforces database integrity through PostgreSQL, categorizes applications based on the selected role, and automatically synchronizes recruiter-friendly records into separate Google Sheets.

Key Contributions

• Designed the complete workflow architecture using n8n.
• Built a custom JavaScript parser for form validation and data transformation.
• Implemented email, phone number, and experience validation.
• Prevented duplicate applications using a composite UNIQUE(email, position) database constraint.
• Integrated Supabase PostgreSQL as the primary source of truth.
• Implemented conditional routing using Switch nodes based on the candidate's selected position.
• Automatically synchronized candidate records into recruiter-specific Google Sheets.
• Designed error handling for invalid submissions, duplicate entries, and database failures.

Challenges

The primary challenge was designing a workflow that could reliably validate candidate data, prevent duplicate submissions, maintain PostgreSQL as the single source of truth, and provide recruiters with organized application sheets without manual intervention. Careful routing logic and database constraints were implemented to ensure consistency across every step of the automation.

Outcome

Successfully built a fully automated recruitment pipeline that validates applications, prevents duplicate submissions, stores candidate information securely in PostgreSQL, and automatically organizes applicants into role-specific Google Sheets. The solution significantly reduces manual recruitment tasks while improving data integrity and application management.