Weekly "who's out this week" Slack digest from Deel

Every Monday at 8am (in the workspace's time zone unless the user overrides it), post a 'who's out this week' digest to Slack summarizing everyone on approved Deel time-off that overlaps the current Monday-through-Sunday window.

Trigger: cron, every Monday at 8am. The weekday, time of day, and time zone should all be user-parameterized.

Step 1 — Pull time-off from Deel. Use Deel's List Time-Off Requests for Organization action to fetch every time-off request whose date range overlaps this week (start_date <= end of Sunday AND end_date >= start of Monday). Filter to approved requests only; skip pending, denied, and cancelled. Page through all results — do not stop at the first page.

Step 2 — Summarize. For each person on approved leave overlapping this week, capture: full name, the dates within this week they will be out (clip any dates that fall outside Mon–Sun of the current week), the time-off type (vacation, sick, parental, personal, etc.), and any handoff notes or reason the requester included. Group by person so someone taking two policies in one week appears once. Also compute a separate 'on leave today' subset — anyone whose approved leave covers today's date — so the reader can see coverage at a glance.

Step 3 — Post one well-formatted Slack message. Use Slack Bot's Send a Message action to post a single message to the target channel (default: #team-updates; make the channel a user-configurable parameter). Format it as one message, not several. Suggested structure:

• Header line with the date range covered, e.g. 'Who's out this week (Mon Jul 13 – Sun Jul 19)'.

• A short 'On leave today' section listing anyone whose approved leave covers today's date, so coverage gaps jump out. Skip the section entirely if nobody is out today.

• A 'Out this week' section with one line per person: name, dates within this week, time-off type, and handoff notes if any.

• Use Slack mrkdwn (single asterisks for bold, hyphen bullets). Keep it skimmable — no essay, no walls of text.

Edge cases:

• If nobody is on approved leave that overlaps this week, still post a short message like 'Everyone is in this week — no approved Deel time-off overlaps Mon–Sun.' so the team knows the digest ran.

• Sort the 'Out this week' list by start date (earliest first), then by name.

• If a request has no handoff note, just omit the notes line — do not print 'no notes'.

User-configurable parameters: Slack channel, weekday, time of day, time zone, and (optionally) a team or department filter if the user only wants their own group's coverage rather than the whole company.