Weekly Cal.com bookings report to Slack and email

Every Monday at 8am in my local timezone, run an agent that generates a written weekly Cal.com bookings report and delivers it to my team in Slack and over email.

Trigger: cron, weekly on Mondays at 8am in the user's timezone.

Step 1. Use Cal.com Get All Bookings to fetch all bookings from the prior 7 days. Then call Get All Bookings again for the 7 days before that so we have a week-over-week comparison window.

Step 2. Group the current week's bookings by event type, by host, and by status (completed, cancelled, no-show). Compute simple metrics: total bookings, cancellation rate, no-show rate, top event types by volume, busiest day of the week, and the biggest week-over-week changes (volume delta, cancellation rate delta, no-show rate delta). Skip any metric or section that has no signal so the recap stays tight.

Step 3. Write a short narrative report under 400 words with three parts: a one-paragraph executive summary, a small metrics table comparing this week to last week, and 2 to 3 plain-language insights. Insights should call out actionable changes, for example: "No-show rate on discovery calls jumped from 8% to 19%, consider adding a reminder workflow." Keep the tone direct and operator-friendly, no jargon.

Step 4. Post the report to the configured Slack channel using Slack Send a Message. Format it cleanly for Slack (bold headers, simple bullets, no raw markdown tables that render badly).

Step 5. Send the same report by email using Gmail Send a Message to the operations distribution list configured at setup. Use a clear subject line like "Cal.com weekly bookings recap, week of <date range>" and include the full report in the body.

Configuration to ask for at setup: the Slack channel id, the email recipient list (one or more addresses), and the user's timezone. Optional: a list of event types or hosts to filter to if the user only cares about a subset.