Daily who's out digest in Slack from CharlieHR
Post a richer morning summary than CharlieHR's built-in digest, grouped by team with coverage callouts, every weekday at 8:30am.
Build me an agent-based workflow that posts a daily who's out today digest into a Slack channel for my team. Trigger: cron, every weekday (Monday through Friday) at 8:30am local time. Make the time zone and the channel ID configurable inputs.
On each run, pull today's approved absences from CharlieHR using List Leave Requests, filtering by start_date and end_date so the window covers today. Then peek at the next five working days as well so you can name people who are off later this week, anyone returning later this week, and anyone with notable upcoming time off. Use List Teams and Get Team Member as needed to attribute each absentee to their team.
Post one Slack message into the configured channel using the Slack Bot Send a Message operation. Group absentees by team in the message. Name returners later this week. Flag coverage gaps the agent should reason about, for example 'Support team has 3 of 5 out today' or 'no one from the On-call rotation is in today.' Keep the tone warm and concise.
The agent's judgement is the value here. CharlieHR's stock digest is a flat list. Yours should turn that list into something a manager can scan in five seconds: who is missing, which teams are stretched, what is coming up. If nobody is out today and nothing is coming up in the next five working days, skip the post for that day rather than sending an empty digest.
Configurable inputs to expose: Slack channel ID, time zone, lookahead window in working days (default 5), and an optional list of teams to watch closely for coverage gaps.
Additional information
What does this prompt do?
- Posts a single morning Slack message with everyone who is out today, grouped by team.
- Previews the next five working days so the team knows about upcoming time off and who is back later this week.
- Calls out coverage gaps a manager actually cares about, like a small team with most of it on leave.
- Runs Monday through Friday only and skips the post when nobody is out and nothing is coming up.
What do I need to use this?
- A CharlieHR Super Admin login so we can read approved time off and team membership.
- A Slack workspace where you can add a bot and pick the channel that should receive the digest.
How can I customize it?
- Change the post time, the time zone, or which Slack channel receives the digest.
- Adjust how far ahead the upcoming time off preview reaches (default is the next five working days).
- Tell the agent which teams to watch for coverage gaps and what counts as stretched, for example on call rotations or a small support team.
Frequently asked questions
Doesn't CharlieHR already send a who's out digest?
Will it post on weekends or company shutdown days?
How far ahead does the upcoming time off preview look?
What does a coverage gap callout actually look like?
Can I send the digest to more than one Slack channel?
Related templates
Turn 'who's out' into something a manager can actually scan.
Connect CharlieHR and Slack once, and we post a team-aware absence digest every weekday at 8:30am.