AI-Powered Code Review with Linting, Red-Marked Corrections in Google Sheets & Slack

Description

Advanced Code Review Automation (AI + Lint + Slack)

Who’s it for
For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting — all managed in Google Sheets with instant Slack summaries.

How it works
This workflow performs a two-layer review system:
Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces).
AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags).
Formatter: Combines lint and AI results, calculating an overall score (0–10).
Aggregator: Summarizes results for quick comparison.
Google Sheets Writer: Appends results to your review log.
Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel.

How to set up
Connect Google Sheets and Slack credentials in n8n.
Replace placeholders (<YOUR_SPREADSHEET_ID>, <YOUR_SHEET_GID_OR_NAME>, <YOUR_SLACK_CHANNEL_ID>).
Adjust the AI review prompt or lint rules as needed.
Activate the workflow — reviews will start automatically whenever new code is added to the sheet.

Requirements
Google Sheets and Slack integrations enabled
A configured AI node (Gemini, OpenAI, or compatible)
Proper permissions to write to your target Google Sheet

How to customize
Add more linting rules (naming conventions, spacing, forbidden APIs)
Extend the AI prompt for project-specific guidelines
Customize the Slack message formatting
Export analytics to a dashboard (e.g., Notion or Data Studio)

Why it’s valuable
This workflow brings realistic, team-oriented AI-assisted code review to n8n — combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your team’s review history transparent and centralized.