📈 Automate GitHub Pull Request Tracking to Google Sheets & Slack

Easily keep your dev team in sync by logging every GitHub pull request into a Google Sheets spreadsheet and sending automatic status change alerts to Slack.

🛎️ Step 1: Trigger from GitHub Pull Request

Whenever a pull request is created or updated in your GitHub repository, this automation kicks off. This ensures no important PR goes untracked.

📊 Step 2: Add New Row to Google Sheets

Automatically create a new entry in your specified Google Sheets spreadsheet whenever a pull request event occurs. The sheet records:

• Pull request ID
• Sender info
• Repository info
• Pull request link
• Repository name

🔄 Step 3: Update Sheet Row Based on PR Status

The workflow checks the pull request action:

➡️ If PR is opened

• Updates the spreadsheet row, marking the status as In Review.

✅ If PR is closed

• Updates the spreadsheet row, marking the status as Closed.

📢 Step 4: Send Slack Notification

Notify your team via Slack! Whenever the spreadsheet is updated, an automatic message is sent to your channel, mentioning changes with the Pull Request ID.

Why Use This Automation?

• Track pull requests automatically in Google Sheets
• Keep your Slack team updated instantly
• No manual data entry needed
• Boost your team's productivity and transparency

Easily sync GitHub pull requests to Google Sheets and send Slack alerts, keeping your workflow smooth and your team informed!