Automate End-of-Day Recruitment Rejection Emails Using Google Sheets and Gmail - n8n Workflow | Neura Market
Automate End-of-Day Recruitment Rejection Emails Using Google Sheets and Gmail
Streamline your recruitment process by automatically sending personalized rejection emails to candidates at the end of each day using Google Sheets and Gmail. This workflow ensures timely communication while preventing duplicate sends.
This workflow is designed for recruiters and HR teams who manage candidate data in Google Sheets. It automates the process of sending rejection emails to candidates whose status is marked as 'Rejected' in the spreadsheet. The workflow runs daily at 18:00 IST, checks if emails have already been sent, and ensures that no duplicates are sent by updating the 'rejection_sent_at' timestamp. It includes a dry run mode for safe previews and rate limits the email sends to comply with SMTP policies.
Platform
n8n
Category
Communication
Price
Free
Creator
Felix Mueller
if
set
code
wait
gmail
googleSheets
scheduleTrigger
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.