📈 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!