# AI code review in GitHub with guidelines from Google Sheets
This workflow helps developers and tech leads automate initial code analysis in pull requests. Using code changes and team guidelines from Google Sheets, the AI generates meaningful feedback and posts it directly in the PR, saving time on routine checks.
## Who it´s for
- iOS and other developers using GitHub for code management.
- Tech leads aiming to integrate AI assistants into their code review process.
- Teams storing coding best practices in Google Sheets and seeking consistent code style.
## What the automation does
- Triggers on `pull_request` events in GitHub.
- Fetches file diffs via GitHub API.
- Builds a structured prompt including rules from Google Sheets.
- Generates review comments using GPT-4o-mini via OpenAI API.
- Posts feedback as a comment in the pull request.
- Applies the `ReviewedByAI` label for tracking reviewed PRs.
## What´s included
- Ready-to-use n8n workflow with LangChain agent.
- Trigger logic for `github_pull_request_event`.
- Integrations with GitHub, Google Sheets, and OpenAI API.
- Basic text instructions for launch and adaptation.
## Requirements for setup
- GitHub account with repository access and webhook permissions.
- Google Sheets document containing coding guidelines.
- OpenAI API key with access to GPT-4o-mini.
- Self-hosted or cloud n8n instance.
## Benefits and outcomes
- Reduced developer workload during code reviews.
- Consistent enforcement of internal coding standards.
- Fast feedback for PR authors without waiting for human reviewers.
- Transparency — `ReviewedByAI` label indicates automated review completion.
- Scalability: handles any number of PRs without manual effort.
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet