AI-powered code review with linting, red-marked corrections in Google Sheets & Slack
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Function (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 10 nodes and runs on Google Sheets events. Along the way it connects Google Sheets, Google Gemini Chat Model and Slack.
How it runs
Trigger: On Google Sheets events.
- Lint Check (Function): runs custom JavaScript (legacy Function node)
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model; 1 tool (Get row(s) in sheet in Google Sheets)
- Format Review Output (Function): runs custom JavaScript (legacy Function node)
- Aggregate Review Stats (Function): runs custom JavaScript (legacy Function node)
- レビュー結果整形 (Edit Fields (Set)): sets 3 fields: reviewedCode, originalCode, timestamp
- レビュー結果書き込み (Google Sheets): append or update
- Post Review Summary (Slack): uses Slack
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Function (legacy) in Lint Check, Format Review Output, Aggregate Review Stats: replace with Code node, mode 'Run Once for All Items'.
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Lint Check, Format Review Output, Aggregate Review Stats | Code node, mode 'Run Once for All Items' |
Nodes used (8)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Function
n8n-nodes-base.function - Slack
n8n-nodes-base.slack
From the author
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…