Send Weekly GitHub Report
Generate a weekly development report summarizing closed GitHub pull requests and post it directly to your team's Slack channel using an AI assistant.
Overview
This workflow generates a weekly development report from GitHub activity across multiple repositories and sends it to a specified Slack channel. It runs every Friday afternoon, summarizing pull requests that were closed during the week and presenting the information in an easy-to-read format.
It performs five main tasks:
- Calculates the date range of the current week starting from Monday.
- Retrieves all pull requests closed since Monday for each repository.
- Uses an AI assistant to create a formatted weekly development report based on the pull requests.
- Prepares the message payload targeting a Slack channel.
- Sends the generated report message to Slack.
What You Need
- A GitHub account with access to the repositories you want to report on.
- The names of the GitHub repositories and the GitHub owner name.
- A Slack workspace with a channel where the report will be posted.
- API connectors configured for GitHub and Slack in Needle.
- Appropriate permissions to read GitHub data and send messages to Slack.
How the Flow Works
| Step | Node | Description |
|---|---|---|
| 1 | Scheduled Trigger | Starts the flow every Friday afternoon, marking the end of the workweek. |
| 2 | Date Calculator Code | Calculates the starting Monday of the current week and the current date/time. It splits the repository list into individual entries with these timestamps. |
| 3 | GitHub Pull Requests Request | Fetches all closed pull requests since Monday for each repository, filtering GitHub data to this week's activity. |
| 4 | AI Report Generator | Feeds the collected pull request data into an AI assistant prompt that summarizes completed work, bug fixes, ongoing tasks, and overall stats into a neatly formatted report designed specifically for Slack. |
| 5 | Slack Message Formatter | Builds the Slack message object containing the target channel and the AI-generated report text. |
| 6 | Send Message to Slack | Publishes the weekly development report to the specified Slack channel so your team gets a clear update without manual effort. |
Output
At the end of the run, you receive a nicely formatted weekly development report posted to your chosen Slack channel. The report includes completed pull requests, bug fixes, pull requests still in progress, and key statistics about repository activity and contributors.
Notes
- Ensure your GitHub repository names and owner are set correctly in the environment variables.
- The Slack channel must allow the bot to post messages.
- The AI summary prompt is designed to keep formatting compatible with Slack's markdown style.
- You can customize the scheduled trigger time to match your team's timezone or preferred report delivery time.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
