Validate GitHub Configurations with GPT-4o Mini and Log Issues to Sheets and Slack

This n8n workflow automates the process of validating GitHub repository configurations using an AI agent (GPT-4o Mini), logging any identified issues to Google Sheets, and notifying a Slack channel. It's designed to help maintain consistent and secure configurations across your GitHub repositories.

What it does

1. Triggers on GitHub Events: The workflow is triggered by specific events in your GitHub organization or repositories (e.g., new repository, configuration changes).
2. Fetches Repository Information: It retrieves detailed configuration data for the relevant GitHub repository.
3. Prepares Data for AI Analysis: Uses a Code node to format the GitHub repository data into a structured prompt for the AI agent.
4. Analyzes Configurations with AI (GPT-4o Mini): An AI Agent (configured with an OpenAI Chat Model and Simple Memory) evaluates the GitHub configuration against best practices or predefined rules. It uses a Structured Output Parser to extract findings.
5. Filters for Issues: It identifies if the AI agent found any issues or suggestions based on its analysis.
6. Logs Issues to Google Sheets: If issues are found, they are appended as new rows to a specified Google Sheet, including details like the repository name, issue description, and suggested remediation.
7. Notifies Slack Channel: Simultaneously, a message is posted to a designated Slack channel, alerting the team about the identified GitHub configuration issues.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance (cloud or self-hosted).
• GitHub Account & Credential: An n8n credential for GitHub with appropriate permissions to read repository configurations and listen to events.
• OpenAI API Key: An API key for OpenAI (specifically for GPT-4o Mini or a similar chat model) configured as an n8n credential.
• Google Sheets Account & Credential: An n8n credential for Google Sheets with access to the target spreadsheet.
• Slack Account & Credential: An n8n credential for Slack with permissions to post messages to a channel.

Setup/Usage

1. Import the Workflow:

   • Download the provided JSON workflow.
   • 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 GitHub, OpenAI Chat Model, Google Sheets, and Slack nodes.
   • For each, select or create the necessary credentials:
     • GitHub: Authenticate with your GitHub account.
     • OpenAI Chat Model: Provide your OpenAI API Key. Ensure the model is set to gpt-4o-mini or your preferred model.
     • Google Sheets: Authenticate with your Google account. Specify the "Spreadsheet ID" and "Sheet Name" where issues should be logged.
     • Slack: Authenticate with your Slack workspace. Specify the "Channel" where notifications should be sent.

3. Configure GitHub Trigger:

   • Open the "Github Trigger" node.
   • Select the "Resource" (e.g., Repository) and "Events" (e.g., Push, Repository). You might want to focus on events related to repository settings or new repository creation for configuration validation.
   • Specify the "Repository" or "Organization" to monitor.

4. Customize AI Prompt (Code Node):

   • Review the "Code" node. This node constructs the prompt sent to the AI. You may want to adjust the prompt to include specific configuration checks or compliance standards relevant to your organization.

5. Activate the Workflow:

   • Once all credentials and configurations are set, click the "Activate" toggle in the top right corner of the n8n editor to enable the workflow.

Now, whenever a configured GitHub event occurs, the workflow will automatically validate the repository's configuration, log issues to Google Sheets, and send a Slack notification.