Automated End-of-Day Recruitment Rejection Emails (Sheets & Gmail)

This n8n workflow automates sending respectful, personalized rejection emails to candidates at the end of each workday (18:00 IST). It pulls data from a 'Candidate Status' tab in Google Sheets, filters rows with specific rejection statuses (e.g., 'Rejected'), valid emails, and no prior send timestamp. A dry-run mode allows previewing emails without sending, ensuring safe testing.

Key features include rate limiting (default 10s between sends) to comply with email provider limits, customizable templates based on candidate details like name, role, feedback, and recruiter info, and automatic timestamping in the sheet to avoid resends. Integrations use Google Sheets OAuth for read/write and SMTP for Gmail (App Password recommended for 2FA).

Ideal for HR teams, recruiters, and ATS users managing hiring in spreadsheets. Benefits: Saves hours on manual emails, ensures consistent communication, reduces errors, and provides audit trails. Use cases include small-to-medium teams scaling recruitment without dedicated ATS software, maintaining professionalism in high-volume hiring, or integrating with existing sheet-based tracking.