Developer & DevOps
Automate GitHub events analysis and Google Sheets logging
14 nodes
315
153
Automatic trigger
Workflow Description
A workflow that triggers automatically on GitHub events, analyzes pull requests and issues using OpenAI, and logs structured data into Google Sheets for centralized tracking and reporting without manual intervention.
How it works
- 1.Trigger automation on GitHub repository events
- 2.Analyze pull request or issue content using OpenAI API
- 3.Extract and process relevant metadata and summaries
- 4.Log results and insights into Google Sheets
- 5.Send notifications or alerts based on defined conditions
Use cases
- Automatically document and track all pull requests in a centralized spreadsheet
- Intelligently categorize and summarize GitHub issues for team review
- Generate analytics reports from GitHub activity data
Requirements
- GitHub account with API access to target repositories
- OpenAI API key with sufficient quota
- Google account with permission to edit Google Sheets
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
OpenAI
GitHub
Google Sheets
AI Agent
Details
Trigger
Automatic trigger
Nodes
14
Apps
4
Views
315
Downloads
153
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (14)
/
OpenAI Chat Model
OpenAI
PR Trigger
Github Trigger
Get file's Diffs from PR
HTTP Request
Create target Prompt from PR Diffs
Code
GitHub Robot
Github
Add Label to PR
Github
Code Best Practices
Google Sheets Tool
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Code Review Agent
Agent
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note