Detect duplicate candidates from Gmail to Slack using Google Sheets

Detect duplicate candidates by email/phone from Gmail to Slack using Google Sheets

This workflow automatically detects duplicate job applicants by checking incoming emails from Gmail against existing records in Google Sheets. If a candidate's email is already found in the sheet, it sends an alert to Slack; otherwise, it adds the candidate to the sheet.

Who’s it for

HR and recruitment teams processing candidate emails manually Startups or SMEs handling job applications via Gmail Anyone who wants to automate resume collection and deduplication Teams using Slack and Google Workspace

How it works

1. Triggers every few minutes via the Schedule Trigger node 2. Fetches recent emails labeled "applicant" from Gmail 3. Extracts candidate details from the email body using regex 4. Reads all existing rows from the Google Sheet 5. Compares the candidate’s email with existing entries 6. If duplicate → Sends a Slack alert 7. If new → Appends to the Google Sheet

How to set up

1. Label candidate emails in Gmail with a label like applicant 2. Connect Gmail, Google Sheets, and Slack credentials in n8n 3. Create a Google Sheet with these columns: