Weekly Cal.com Bookings Report for 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.

Additional information

What does this prompt do?

Pulls last week's Cal.com bookings every Monday morning and groups them by event type, host, and status.
Writes a short narrative report with a one-paragraph summary, a metrics table, and 2 to 3 plain-language insights.
Compares this week to the previous week so you can see cancellation, no-show, and volume trends at a glance.
Posts the recap to your chosen Slack channel and emails the same report to your operations distribution list.

What do I need to use this?

A Cal.com account with bookings to report on.
A Slack workspace and a channel where the recap should land.
A Gmail account that can send to your operations distribution list.

How can I customize it?

Change the day or time the report runs, or switch to a different cadence like every other Monday.
Pick which Slack channel and which email recipients receive the recap.
Adjust the metrics or insights you care about, such as filtering to a specific event type or a single host.

Frequently asked questions

What does the report actually look like?

A short written recap under 400 words, with a one-paragraph executive summary, a small metrics table covering total bookings, cancellation rate, and no-show rate, and 2 to 3 plain-language insights about what changed week over week.

Will it work if my team is on the Cal.com free plan?

Yes. As long as your Cal.com account can list bookings, the workflow can pull and summarize them.

Can I send the recap to more than one Slack channel or email list?

Yes. You can add additional Slack channels or email recipients when you set the workflow up, or update them later.

What happens during a quiet week with no bookings?

The agent skips empty sections and sends a brief note that volume was low, so your team is not flooded with placeholder tables.

Does it run in my timezone?

Yes. The schedule is set to 8am in your local timezone, so Monday morning means Monday morning for your team.