Quick Overview
This workflow checks Google Calendar hourly for the next upcoming meeting, pulls recent GitHub meeting notes, finds related GitHub PRs and issues, and sends each attendee a Slack DM with a pre-meeting briefing five minutes before the event.
How it works
- Runs every hour on a scheduled trigger and fetches events from a selected Google Calendar.
- Selects the next upcoming event, then requests the latest GitHub meeting-notes issue and keeps it only if it was created before the upcoming meeting.
- Calculates a notification time five minutes before the meeting start and waits until that time.
- Extracts keywords from the meeting title and uses them to query GitHub for matching pull requests and open issues.
- Filters PRs created after the previous meeting date, merges the PRs and issues, and formats them into a single “topics” list.
- Builds a Slack Block Kit message with meeting title/time, related GitHub items, and previous meeting notes, then sends it as a DM to each non-declined attendee after looking up their Slack user by email.
Setup
- Connect your Google Calendar OAuth2 credentials and select the calendar to monitor.
- Add GitHub access (OAuth2 or an API token via HTTP header auth) and update the repository owner/name plus the GitHub Search query and “last meeting notes” URL to match your repo.
- Connect Slack OAuth2 credentials and ensure attendee emails in Google Calendar match Slack user emails so users.lookupByEmail can resolve recipients.