Automated Interview Tracker with Google Calendar, Sheets & Gmail Alerts

Enhance your hiring pipeline by automating interview management post-screening. This workflow runs every 5 minutes to scan upcoming Google Calendar events, filter relevant interviews, send timely email reminders to candidates and internal teams, and handle result submissions via webhook — updating statuses in Google Sheets and notifying via Gmail based on pass/fail outcomes. Ensure no interviews slip through the cracks with proactive reminders and instant feedback loops.

---

What This Template Does

Step 1: Triggers every 5 minutes to proactively check for upcoming interviews. Step 2: Fetches all Google Calendar Events and identifies interview-related ones. Step 3: Filters Upcoming Interviews based on event details (e.g., candidate name, role). Step 4: Sends Reminder Emails to candidates and interviewers via Gmail for preparation. Step 5: Receives Webhook Submission of interview results (pass/fail) post-event. Step 6: Updates Google Sheet with result data, including feedback and updated status. Step 7: Branches on result:   → Passed: Sends congratulatory Email to Candidate and advances status.   → Failed: Sends polite Failure Notification and closes the loop.

---

Key Benefits ✅ Reduces no-shows with automated reminders ✅ Centralizes interview tracking in Google Sheets ✅ Instant Gmail notifications for pass/fail decisions ✅ Minimizes manual status updates ✅ Improves candidate experience with timely communication ✅ Ensures audit-ready logs of all interactions

---

Features - Cron-triggered checks every 5 minutes - Google Calendar integration for event fetching - Smart filtering for interview-specific events - Gmail-powered reminder and notification emails - Webhook for secure result submissions - Conditional branching on pass/fail - Real-time Google Sheets append/update - Comprehensive sheet structure for tracking