If you run a consulting practice, an agency, or a sales team, your calendar fills up fast, and so does your inbox. Every booking tool sends a confirmation email: Google Calendar invites, Calendly bookings, Zoom meeting links, client reply-to-confirm threads. Keeping a master record of who booked what and when usually means manually retyping details into a spreadsheet, which is slow and easy to forget.
In this guide, we'll show you how to automatically capture every calendar event confirmation email and turn it into a clean row in Google Sheets, no calendar API integration or custom script required.
Why Rely on Email Instead of the Calendar API
It's tempting to think you need to connect directly to the Google Calendar API to build a meetings tracker. In reality, that approach requires developer time, OAuth scopes, and ongoing maintenance. It also misses meetings booked through third-party tools like Calendly or scheduling links embedded in a website, which don't always sync cleanly to your primary calendar.
The simpler path is to work with what already lands in your inbox. Every calendar invite, booking confirmation, and reschedule notice arrives as an email. If you can reliably capture and parse those emails, you get a complete meetings log without touching a single API.
Step-by-Step: Building Your Meetings Tracker
1. Create a Gmail Filter and Label for Calendar Emails
Open Gmail settings and create a filter that catches meeting-related emails. A good starting rule matches subjects containing "invitation:", "Confirmed:", "New Event:", or the sender addresses used by your booking tools (for example calendar-notification@google.com or your Calendly notification address). Apply a label such as "Meeting Confirmations" to anything that matches.
2. Set Up Your Meetings Tracker Sheet
Create a new Google Sheet named "Meetings Tracker" and add column headers in Row 1: Date Received, Attendee Name, Attendee Email, Meeting Title, Meeting Date & Time, and Meeting Link.
3. Connect Mail Sheet to the Label
Open the sheet, go to Extensions > Mail Sheet > Open, and select the "Meeting Confirmations" label as your source. Mail Sheet is a Google Sheets add-on that reads matching emails and writes the extracted details straight into your rows, no copy-pasting required.
4. Configure AI Mode to Handle Different Booking Tools
Calendar confirmations come in wildly different formats depending on the tool that sent them. Rather than writing separate rules for each one, switch Mail Sheet to AI Mode and use a prompt like:
"Extract the Attendee Name, Attendee Email, Meeting Title or Subject, the scheduled Meeting Date and Time, and any video call or meeting link mentioned in the email. Format the date and time as YYYY-MM-DD HH:MM."
Because the AI reads the context of the message instead of matching a rigid template, it handles Google Calendar's structured invite format, Calendly's booking summary, and a plain-text client reply equally well.
5. Schedule Automatic Runs
Set Mail Sheet to check the labeled folder on a recurring schedule, for example every few hours. New confirmations that arrive throughout the day get appended to your tracker automatically, so your team always has an up-to-date view of upcoming appointments without opening Gmail.
Use Cases Beyond a Simple Meetings Log
Once calendar confirmations are flowing into Sheets automatically, you can build on top of that data. Agencies use it to track client onboarding call volume by month. Sales teams pair it with a CRM export to measure how many booked demos actually show up. Consultants use it to calculate billable hours by summing meeting durations per client, right inside the same spreadsheet.
Frequently Asked Questions
Can Mail Sheet read Google Calendar directly instead of email confirmations?
Mail Sheet works by reading your Gmail inbox, not the Google Calendar API directly. In practice this works well because every calendar invite, Calendly booking, and meeting confirmation also lands in your inbox as an email. By labeling those confirmation emails and pointing Mail Sheet at that label, you get the same result, a structured log of every meeting, without needing separate calendar API access or scripting.
What if a meeting gets rescheduled or cancelled after it's already logged?
Calendar tools like Google Calendar and Calendly send a new confirmation email whenever a meeting time changes, and a separate cancellation notice if it's called off. Set up a second Gmail filter and label for cancellation and reschedule emails, then add a Status column to your sheet. Mail Sheet can log these as new rows or update the Status field, so your tracker reflects the latest state of each appointment instead of stale data.
Can I track meetings from multiple booking tools like Calendly and Google Calendar in one sheet?
Yes. Because Mail Sheet's AI Mode reads the content of each email rather than relying on a fixed template, it can extract the same fields, attendee name, meeting time, and topic, from Calendly confirmations, Google Calendar invites, and Zoom meeting emails alike. Route all of these sources into one Gmail label and Mail Sheet will normalize them into consistent rows in a single Meetings Tracker sheet.