Analyze GitHub Issue Sentiment with OpenAI and Automate Airtable Updates
detail.loadingPreview
This workflow automatically analyzes the sentiment of GitHub issue comments using OpenAI's language models. It then updates an Airtable base with the sentiment analysis results, tracking sentiment transitions.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This n8n workflow is designed to automate the process of analyzing the sentiment expressed in GitHub issue comments. It leverages the power of OpenAI's language models to extract sentiment (positive, negative, or neutral) and provide a summary for each issue. The workflow then stores this information in an Airtable base, creating a historical record and allowing for the tracking of sentiment changes over time.
This is particularly useful for project managers, team leads, or developers who want to quickly gauge the general mood around specific issues, identify potential areas of concern or praise, and maintain a structured overview of issue discussions without manually reading every comment.
Key Features
- Fetches issues from a GitHub repository using GraphQL.
- Splits issues into individual items for processing.
- Analyzes the sentiment of comments within each issue using OpenAI.
- Extracts sentiment and a summary of the conversation.
- Retrieves existing sentiment data from an Airtable base.
- Updates or creates records in Airtable with new sentiment analysis, issue details, and previous sentiment.
- Triggers actions based on sentiment transitions (e.g., from non-negative to negative).
How To Use
- Configure GitHub Integration: Ensure you have a GraphQL node set up to connect to your GitHub repository and fetch issues.
- Set up OpenAI Credentials: Add your OpenAI API key as a credential in n8n.
- Configure Airtable Integration: Set up your Airtable credentials and specify the Base ID and Table ID for storing sentiment data.
- Map Fields: In the 'Update Row' node, carefully map the output fields from the OpenAI analysis and issue data to the corresponding columns in your Airtable table.
- Define Sentiment Transition Rules: Configure the 'Sentiment Transition' node to define specific conditions that should trigger alerts or further actions when sentiment changes.
Apps Used
Workflow JSON
{
"id": "218a2e1d-745d-4987-9de5-3734f76495cb",
"name": "Analyze GitHub Issue Sentiment with OpenAI and Automate Airtable Updates",
"nodes": 0,
"category": "AI & Machine Learning",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 218a2e1d-745d...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
Visa Requirement Checker
A workflow to check visa requirements based on user input, leveraging Langchain, Cohere embeddings, Weaviate vector store, and Anthropic LLM.
OpenAI Text-to-Speech Workflow
Generate audio from text using OpenAI's TTS API.
AI Assistant for Structured Metadata Generation
Automates the generation of structured metadata in English and Chinese using AI, leveraging communication platforms and various data sources.