Automate PR Notifications to Slack with Organization Lookup

Stay informed! This automation notifies your Slack channel every time a new pull request (PR) is created in your organization's GitHub repository. It also keeps your team updated and maintains a log in Google Sheets for easy tracking.

Trigger Event: New Pull Request in GitHub

When a new pull request is created in an organization's GitHub repository, this workflow is triggered. The workflow starts by detecting essential PR details such as the PR number, author, repository, and title.

Actions

1. Find Organization (GitHub)

Checks if the organization related to the pull request exists, using the information from the PR.

2. PR Organization Exists? (Conditional Check)

Continues the workflow only if the organization is found, ensuring data accuracy and reducing errors.

3. Format PR Message

Creates a clean, readable message with PR details, including the PR number, title, repository name, and author.

4. Lookup Spreadsheet Row (Google Sheets)

Searches Google Sheets for the relevant project row based on the repo name, making sure your tracking sheet is up to date.

5. Format Number Data

Ensures the PR number and issue counts are easy to read for everyone.

6. Update Spreadsheet Row (Google Sheets)

Updates your Google Sheet with the new PR details, keeping a history log for your team's reference.

7. Send Message (Slack)

Notifies a specific Slack channel with the formatted PR message, so your whole team stays in the loop instantly.

Benefits

• Never miss important PRs—get instant Slack alerts.
• Keep organized records automatically in Google Sheets.
• Save time on manual tracking and team notifications.
• Improve workflow transparency and quick team collaboration.

This template helps your team remain aligned, speeds up reviews, and ensures transparency on every code change.