Skip to main content

AI-powered code review with linting, red-marked corrections in Google Sheets & Slack

Workflow preview

Workflow preview
100%
AI-powered code review with linting, red-marked corrections in Google Sheets & Slack preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

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 r...

Best for

  • Engineering automation workflows
  • AI Summarization automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.googlesheetstrigger, n8n-nodes-base.set, n8n-nodes-base.googlesheets, @n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmchatgooglegemini, n8n-nodes-base.googlesheetstool, n8n-nodes-base.stickynote, n8n-nodes-base.function

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by higashiyama .

Original n8n.io source

1.1 Workflow description

Title
AI-powered code review with linting, red-marked corrections in Google Sheets & Slack
Workflow name
AI-powered code review with linting, red-marked corrections in Google Sheets & Slack

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:

  1. Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces).
  2. 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).
  3. Formatter: Combines lint and AI results, calculating an overall score (0–10).
  4. Aggregator: Summarizes results for quick comparison.
  5. Google Sheets Writer: Appends results to your review log.
  6. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel.

How to set up

  1. Connect Google Sheets and Slack credentials in n8n.
  2. Replace placeholders (<YOUR_SPREADSHEET_ID>, <YOUR_SHEET_GID_OR_NAME>, <YOUR_SLACK_CHANNEL_ID>).
  3. Adjust the AI review prompt or lint rules as needed.
  4. 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.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - コード入力シート監視

Type / Role
n8n-nodes-base.googleSheetsTrigger - googleSheetsTrigger
Config choices
Version 1

Block 2 - レビュー結果整形

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 3 - レビュー結果書き込み

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 4 - AI Agent

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 2.2

Block 5 - Google Gemini Chat Model

Type / Role
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - lmChatGoogleGemini
Config choices
Version 1

Block 6 - Get row(s) in sheet in Google Sheets

Type / Role
n8n-nodes-base.googleSheetsTool - googleSheetsTool
Config choices
Version 4.7

Block 7 - Sheet Trigger Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 8 - AI Review Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 9 - Formatting Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 10 - Write Output Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 11 - Lint Check

Type / Role
n8n-nodes-base.function - function
Config choices
Version 1

Block 12 - Format Review Output

Type / Role
n8n-nodes-base.function - function
Config choices
Version 1

Block 13 - Aggregate Review Stats

Type / Role
n8n-nodes-base.function - function
Config choices
Version 1

Block 14 - Post Review Summary

Type / Role
n8n-nodes-base.slack - slack
Config choices
Version 2.3

Block 15 - Template Overview (Advanced)

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 16 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

3. Summary Table

Workflow AI-powered code review with linting, red-marked corrections in Google Sheets & Slack
Complexity advanced
Nodes 16
Categories Engineering, AI Summarization
Author higashiyama
Published 22 Oct 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/10034/10034.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does AI-powered code review with linting, red-marked corrections in Google Sheets & Slack do?

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 r...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Engineering, AI Summarization use case.