Automated HR Interview Management and Notification System - n8n Workflow

• HR managers and recruiters who need to streamline high-volume interview scheduling.


• Teams looking for robust n8n templates to manage candidate communication.


• Users needing a reliable n8n workflow for integrating Google Calendar, Gmail, and Google Sheets.


• Developers or HR Tech specialists implementing custom n8n automations.

Managing high volumes of candidate interviews manually is time-consuming and prone to human error, especially concerning timely reminders and accurate result logging. This sophisticated n8n workflow solves these problems by creating a dual-branch automation system. The first branch uses a scheduled n8n trigger to constantly check Google Calendar for interviews starting within the next five minutes, automatically logs them into a Google Sheet, and sends a critical reminder via Gmail to ensure candidate punctuality. The second branch utilizes a webhook n8n trigger to instantly process interview outcomes, update the Google Sheet tracking system, and dispatch appropriate 'Pass' or 'Fail' result emails via Gmail, along with a final summary notification to the manager. This consolidated n8n automation ensures seamless tracking, reduces no-shows, and maintains professionalism in candidate communication.

This n8n workflow operates in two distinct phases:

Phase 1: Scheduled Interview Reminder and Logging

1. Scheduled Check: The workflow starts with the 'Check Every 5 Minutes' n8n trigger, initiating the process periodically.


2. Retrieve Events: The 'Get Calendar Events' n8n node fetches all Google Calendar events scheduled for the upcoming hour.


3. Filter: The 'Filter Upcoming Interviews' n8n node is crucial. It filters the events, ensuring only those starting within the next 5 minutes are processed (Time greater than now but less than now + 5 minutes).


4. Data Logging: The filtered data is sent to the 'Add to Google Sheet' n8n node, logging the impending interview details.


5. Candidate Alert: Simultaneously, the 'Send Reminder to Candidate' Gmail n8n node uses the candidate's email address extracted from the calendar event to send an HTML-formatted reminder email, including the Google Meet link, 5 minutes before the start time.

Phase 2: Result Processing and Notification

1. Result Submission: The 'Webhook: Submit Interview Result' n8n trigger waits for a POST request containing the interview outcome (e.g., candidate email, result, feedback). This allows integration with external forms or internal apps.


2. Update Record: The 'Update Sheet with Result' Google Sheets n8n node uses the submitted data to update the relevant row in the tracking spreadsheet, completing the interview record.


3. Decision Branch: The 'Check if Passed' n8n node evaluates the submitted 'result' field. If the value equals 'Pass', execution follows the true branch; otherwise, it follows the false branch.


4. Candidate Notification (Pass): If passed, the 'Email Candidate - Passed' Gmail n8n node sends a congratulatory email.


5. Candidate Notification (Fail): If failed, the 'Email Candidate - Failed' Gmail n8n node sends a polite rejection email.


6. Internal Alert: Regardless of the outcome, the 'Email Manager' Gmail n8n node sends a final summary update to the internal hiring manager, ensuring internal stakeholders are immediately informed of the status.

To deploy this powerful n8n workflow using these n8n templates, follow these steps:

1. Import: Copy the provided JSON and import it directly into your n8n instance.


2. Credentials Setup: You will need three separate credentials set up for this n8n automation:

1. Activate: After setting up the webhooks and credentials, activate the n8n workflow. Note the URL generated by the 'Webhook: Submit Interview Result' n8n trigger for external use.

Check Every 5 Minutes (Schedule Trigger n8n trigger)
Function: Starts the workflow periodically to monitor calendars.
Key Configuration: Runs every 5 minutes.
Get Calendar Events (Google Calendar n8n node)
Function: Retrieves upcoming events from the specified calendar.
Key Configuration: Filters events between {{ $now.toISO() }} and {{ $now.plus({ hours: 1 }).toISO() }}.
Filter Upcoming Interviews (Filter n8n node)
Function: Narrows down the retrieved events to those starting within the 5-minute reminder window.
Key Configuration: Uses two date-time conditions: start.dateTime must be after now and before now + 5 minutes.
Add to Google Sheet (Google Sheets n8n node)
Function: Logs new interview events into the spreadsheet.
Key Configuration: Operation is 'appendOrUpdate', mapping mode is 'autoMapInputData'. Requires YOURSPREADSHEETID.
Send Reminder to Candidate (Gmail n8n node)
Function: Sends a highly visible 5-minute reminder email to the primary candidate attendee.
Key Configuration: Recipient is dynamic: ={{ $json.attendees[0].email }}. Subject specifies 'Starting in 5 Minutes'.
Webhook: Submit Interview Result (Webhook n8n trigger)
Function: Serves as the entry point for submitted interview results via a POST request.
Key Configuration: Path is interview-result, Method is POST.
Check if Passed (If n8n node)
Function: Directs the flow based on the interview outcome.
Key Configuration: Checks if the input value {{ $json.result }} exactly equals 'Pass'.
Email Candidate - Passed / Failed (Gmail n8n nodes)
Function: Sends custom notification emails based on the outcome.
Key Configuration: Utilizes dynamic data fields like {{ $json.candidateEmail }} and {{ $json.feedback }} to personalize the response. This is a crucial element of the overall n8n workflow.