Once a candidate moves past the initial application, the real coordination work begins. Confirmation emails, scheduling links, candidate replies proposing new times, and interviewer availability all pile up in the inbox of whoever is running the hiring process. Without a shared view, it's easy to lose track of which candidate is at which stage, or to double-book an interviewer by accident.
In this guide, we'll show you how to automatically capture every interview scheduling email and turn it into an up-to-date candidate pipeline in Google Sheets, so your hiring team always knows who's scheduled, who's pending, and who's ready for the next round.
Why Interview Scheduling Needs Its Own Tracker
Many teams already log candidates when they first apply, but scheduling is a different problem. A single candidate can generate several emails: an initial "let's schedule a call" outreach, a confirmation once a time is picked, a reschedule request, and eventually a "moving to final round" note. Trying to track all of that inside an applicant's original application row gets messy fast, especially when multiple people on your team are sending and receiving these emails.
A dedicated interview pipeline sheet solves this by treating scheduling as its own workflow: every relevant email updates a candidate's row with their current stage, next interview date, and who they're meeting with, giving your whole hiring team one place to check status without digging through email threads.
Step-by-Step: Building a Candidate Pipeline Sheet
1. Create a Gmail Filter and Label for Scheduling Emails
Set up a Gmail filter that catches interview-related emails: subjects containing "Interview Confirmed", "Scheduling", "Availability", or replies from your scheduling tool (such as Calendly or a scheduling link service). Apply a label like "Interview Pipeline" so every scheduling-related email, whether it's outbound from your team or a reply from a candidate, lands in one place.
2. Set Up Your Interview Pipeline Sheet
Create a new Google Sheet named "Interview Pipeline" and add column headers in Row 1: Date Received, Candidate Name, Candidate Email, Role, Pipeline Stage, Interview Date & Time, and Interviewer. The Pipeline Stage column is what turns this into a real tracker rather than just a log.
3. Connect Mail Sheet to the Label
Open the sheet, go to Extensions > Mail Sheet > Open, and select the "Interview Pipeline" label as your source. Mail Sheet reads every matching email and writes the extracted details into new rows automatically, so no one has to manually update a spreadsheet after every scheduling call.
4. Use AI Mode to Extract Pipeline Stage and Scheduling Details
Interview emails vary a lot: some are structured calendar confirmations, others are informal replies like "Does Thursday at 2pm work?" Rather than writing rigid rules for each format, switch Mail Sheet to AI Mode and use a prompt like:
"Extract the Candidate's Name, Email Address, the Role they're interviewing for, the current Pipeline Stage (such as Scheduling, Confirmed, Rescheduled, or Final Round) based on the email content, the Interview Date and Time if mentioned, and the Interviewer's name. Format the date and time as YYYY-MM-DD HH:MM."
Because AI Mode interprets the meaning of each message instead of matching a fixed template, it can tell a first scheduling outreach apart from a confirmed booking or a candidate's reschedule request, and update the Pipeline Stage column accordingly.
5. Schedule Automatic Runs
Set Mail Sheet to check the "Interview Pipeline" label a few times a day, for example every 2-3 hours. As candidates reply and interviews get confirmed throughout the day, your sheet stays current, giving recruiters and hiring managers a live view of the pipeline without pinging each other for status updates.
Use Cases Beyond a Simple Schedule Log
Once interview scheduling data is flowing into Sheets automatically, it becomes a useful reporting tool as well as a tracker. Recruiters use the Pipeline Stage column to calculate how many candidates make it from first interview to final round each month. Hiring managers filter by Interviewer to balance interview load across the team. Startups without a full ATS use this sheet as their entire hiring pipeline, adding a Notes or Decision column as candidates move through the process.
Frequently Asked Questions
How is this different from tracking job applications in Google Sheets?
Tracking applications focuses on capturing candidates as they apply, name, email, and the role they're interested in, right when their application email arrives. Interview scheduling tracking picks up after that: it follows a candidate through confirmation emails, scheduling replies, and interview stage changes, so you can see where each person sits in your pipeline, not just that they applied. Many teams run both trackers side by side, feeding into the same candidate list with a shared email address as the key.
Can Mail Sheet tell the difference between a first-round and final-round interview email?
Yes, if the email itself mentions it. Most scheduling and confirmation emails reference the interview stage in the subject or body, for example "Second Interview Confirmed" or "Final Round with the Engineering Team". Because AI Mode reads the full context of the message, you can instruct it to extract the interview stage whenever it's mentioned, and it will populate your Pipeline Stage column accordingly instead of only logging that an interview happened.
What happens if a candidate replies to reschedule instead of confirming a time?
Reschedule replies usually land in the same labeled thread as the original scheduling email, so they'll be picked up by the same Gmail filter. Add a Status column to your sheet and instruct the AI Mode prompt to set it to "Reschedule Requested" when the email content indicates the candidate can't make the proposed time. This keeps your pipeline sheet accurate without needing a separate label just for reschedules.