spark-recipe-calendar-audit

To calculate total meeting hours and busiest days, you count meetings over a specified date window, sum the hours, and summarize per-day meeting volume to highlight the most and least burdened days.

Use Spark to pull your calendar events and availability, then compute aggregate metrics and per-day meeting volume to generate an audit-ready report aligned with your working hours rules.

To find your longest available free block, compute contiguous free time between scheduled events over your specified date window while applying your defined working hours rules to exclude non-working periods.

To audit your calendar for back-to-back meetings and free blocks, you analyze meeting load over a date range by pulling events, detecting consecutive meeting chains, and surfacing the longest contiguous time available for focused work.

You can compare meeting load across multiple accounts by pulling events and availability from different calendars, then computing per-day and aggregate metrics to present an audit-ready report for each account.

The best way to analyze schedule planning for a custom date range is to specify your desired dates, count meetings, sum hours, and detect back-to-back chains to fit weekly planning and schedule review scenarios.