Skip to content

Calendar Time Audit Digest

Example prompt: "Every Friday at 5pm, look at all my Google Calendar events from this week, categorise them as meetings, focus time, or one-on-ones, total the hours in each category, compare to last week, and email me a summary."

How to automate calendar time audits with GloriaMundo

The Problem

You finish the week feeling busy but unsure where the time actually went. Were you in meetings all day Tuesday, or does it just feel that way? How much focus time did you actually protect? Most people have no idea how their calendar hours break down week over week, because checking requires scrolling through five days of events and tallying them by hand. Without data, you cannot make informed decisions about how to structure your weeks — you just react to whatever gets scheduled.

How GloriaMundo Solves It

We build a workflow that runs at the end of each week. An integration step fetches all your Google Calendar events for the past seven days — titles, durations, and attendee counts. A code step categorises each event based on rules you define: meetings with 3+ attendees are "group meetings", events with one other person are "one-on-ones", blocks you have marked are "focus time", and so on. An LLM step compares this week's breakdown to the previous week (stored via a state step) and writes a short narrative: where time increased or decreased, whether you hit your focus-time target, and a suggestion for the coming week. The digest is emailed to you as a clean summary you can review in under a minute.

Example Workflow Steps

  1. Trigger (scheduled): Runs every Friday at 5:00 PM.
  2. Step 1 (integration): Fetch all Google Calendar events from the past 7 days — title, duration, and attendee count.
  3. Step 2 (code): Categorise each event (group meeting, one-on-one, focus time, personal) and calculate total hours per category.
  4. Step 3 (state): Retrieve last week's category totals for comparison, then store this week's totals.
  5. Step 4 (LLM): Generate a narrative summary comparing this week to last week, noting trends and suggesting adjustments.
  6. Step 5 (integration): Email the time audit digest via Gmail.

Integrations Used

  • Google Calendar — source of all calendar events and their metadata
  • Gmail — delivers the weekly digest

Who This Is For

Managers, individual contributors protecting their focus time, and founders who suspect they are spending too much of the week in meetings but have no data to confirm it. Useful for anyone who has set a personal goal like "no more than 15 hours of meetings per week" and wants to track whether they are hitting it.

Time & Cost Saved

Manually auditing your calendar takes 20-30 minutes if done thoroughly, which is why most people never do it. This workflow does it automatically every week and provides trend data you could not easily calculate by hand. The real value is not the 30 minutes saved but the decisions it enables — over a quarter, people who track their time typically reclaim 2-3 hours per week by identifying and eliminating low-value recurring meetings. The workflow uses integration, code, state, and LLM steps, costing a few credits per weekly run.