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

This n8n workflow automates the process of reviewing code snippets, applying linting rules, identifying corrections, and highlighting them in a Google Sheet, while also notifying a Slack channel about the review status.

What it Does

This workflow streamlines code review by:

1. Triggering on Google Sheet Updates: It listens for new rows or updates in a specified Google Sheet, acting as the input for code review requests.
2. Preparing Code for AI Review: It extracts the code snippet and relevant context from the Google Sheet entry.
3. Performing AI-Powered Code Review: It sends the code to an AI agent (powered by Google Gemini Chat Model) for linting, identifying potential issues, and suggesting corrections.
4. Formatting Corrections: It processes the AI's output to clearly mark corrections, potentially using a "red-marked" format.
5. Updating Google Sheet: It updates the original Google Sheet with the AI's review, including the linting results and suggested corrections, highlighting them for easy visibility.
6. Notifying Slack Channel: It sends a message to a designated Slack channel, informing the team about the completed code review and its outcome.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance (self-hosted or cloud).
• Google Sheets Account: A Google account with access to Google Sheets.
  • Google Sheets Credential: An n8n credential configured for Google Sheets (OAuth 2.0 recommended).
• Slack Account: A Slack workspace.
  • Slack Credential: An n8n credential configured for Slack.
• Google Gemini API Key: Access to the Google Gemini Chat Model API.
  • Google Gemini Chat Model Credential: An n8n credential configured for Google Gemini.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON or upload the file.
2. Configure Credentials:
   • Locate the "Google Sheets Trigger" node and configure your Google Sheets credential.
   • Locate the "Google Gemini Chat Model" node and configure your Google Gemini credential.
   • Locate the "Slack" node and configure your Slack credential.
3. Configure Google Sheets Trigger:
   • Specify the Google Sheet ID and the sheet name you want to monitor for new code review requests.
   • Choose the "Watch new rows" or "Watch for changes" trigger method as appropriate for your use case.
4. Configure AI Agent (Google Gemini Chat Model):
   • Review the prompt within the "AI Agent" node to ensure it aligns with your desired linting rules and correction style. You might need to refine the prompt to get the desired "red-marked" output.
5. Configure Google Sheets Update:
   • Ensure the "Google Sheets" node is configured to update the correct sheet and cells with the AI's review and corrections. You'll likely map the output from the AI to specific columns for linting status and suggested changes.
6. Configure Slack Notification:
   • Specify the Slack channel where you want to receive notifications.
   • Customize the message content to include relevant details about the code review.
7. Activate the Workflow:
   • Once all credentials and nodes are configured, activate the workflow.

Now, whenever a new code snippet is added or updated in your specified Google Sheet, the workflow will automatically trigger, perform an AI-powered code review, update the sheet with corrections, and notify your team on Slack.