Sends PTO reminders to Slack from shared team Google Calendar.

• Monday: Weekly summary of ALL OOOs overlapping this week
• Tue-Thu: Tomorrow reminders for NEW OOOs starting next day
• Fri-Sun: No notifications

1. Remix this val

2. Go to pipedream.val.run

3. Configure the following for your shared calendar:

   

4. Copy the generated code into googleCalendar.ts

1. Go to api.slack.com/apps
2. Create app → From Scratch → Select workspace
3. Incoming Webhooks → Toggle ON → Add New Webhook
4. Select your #ooo channel → Copy webhook URL
5. Add environment variable: SLACK_WEBHOOK_URL = webhook URL

The code is bulkier than I'd like it to be because there are humans creating these OOO events on the other side, and every event looks a bit different!

I also am purposefully logging as much as possible to help debug.

• All-day vs timed events: All-day events use date format while timed events use dateTime
• Consolidation: Multiple PTO entries for same person are merged into date ranges
• Partial days: Timed events <8 hour are marked as "partial"
• Name extraction: Supports both [name] PTO format and first-word extraction Name OOO from titles