n8n Automated AI Code Review: Lint + Gemini Scoring + Google Sheets Logging + Slack Alerts
Google Sheets code input → n8n triggers dual-layer lint and AI review → outputs red-marked corrections with scores to spreadsheet and notifies Slack
Read the case’s method and prerequisites
Prerequisites: n8n instance; Google Sheets OAuth2 credentials (googleSheetsOAuth2Api); Slack OAuth2 credentials; write access to target Google Sheet. Costs: n8n self-hosted or cloud fees; Gemini API calls per Google pricing. Input: Add or edit a row with a code field in the designated Google Sheet worksheet (「対象コード」). Output: Append review record to 「レビュー結果」 worksheet; Slack channel receives summary. Limitations: Lint rules in template are examples only (var, console.log, brace balance) and need project-specific expansion; AI prompt is mixed Japanese-English; not tested by this site.
n8n · Google Sheets · Slack
Associated by case tags. Verify costs, permissions and actual results in the case.