Automate Instagram Engagement & Sentiment Analysis with GPT-4 and Slack Reports

Description

📊 Description
Automatically analyze your Instagram posts’ engagement and audience sentiment using GPT-4 to uncover top-performing content and improvement opportunities. 💬📈
This workflow fetches your latest Instagram posts using the Facebook Graph API, evaluates likes, comments, and tone, then generates structured performance insights. The results are logged into Google Sheets, shared via Slack alerts, and emailed through Outlook — empowering your social media team with daily, AI-powered engagement intelligence. 🚀

What This Template Does
1️⃣ Trigger – Runs daily at 10 AM to fetch the latest Instagram posts. ⏰
2️⃣ Data Fetching – Uses the Facebook Graph API to extract post data, captions, likes, and comments. 📲
3️⃣ Formatting – Cleans and structures post and comment data for analysis. 🧩
4️⃣ AI Evaluation – GPT-4 analyzes engagement metrics and comment sentiment to score post performance. 🤖
5️⃣ Decision Routing – Flags high- and low-performing posts for separate processing. ⚙️
6️⃣ Notifications – Sends positive performance summaries or negative alerts to Slack. 💬
7️⃣ Logging – Records engagement metrics, sentiment labels, and AI recommendations in Google Sheets. 📊
8️⃣ Reporting – Emails detailed performance summaries to the marketing team via Outlook. 💌

Key Benefits
✅ Automates social performance tracking across Instagram posts
✅ Provides AI-driven sentiment and engagement insights
✅ Flags top or underperforming content for immediate action
✅ Delivers Slack and email reports for team visibility
✅ Centralizes analytics in Google Sheets for trend tracking

Features
Facebook Graph API integration for Instagram post and comment retrieval
GPT-4 sentiment and engagement evaluation
Structured JSON insights and recommendations
Slack alerts for both positive and negative performance
Google Sheets data logging with trend metrics
Outlook email reporting for management visibility
Customizable scheduling and thresholds

Requirements
Facebook Graph API credentials connected to your Instagram Business account
OpenAI API key for GPT-4 or GPT-4o-mini
Slack Bot token with chat:write permissions
Google Sheets OAuth2 credentials with edit rights
Microsoft Outlook OAuth2 credentials for email delivery
Optional environment variables for IDs:
SHEET_ID, SLACK_CHANNEL_ID, OUTLOOK_EMAIL

Target Audience
Marketing and social media teams optimizing engagement 📣
Agencies managing multiple Instagram accounts 🧑‍💼
Analysts tracking performance metrics and audience tone 📊
Brands automating daily performance reports 📅

Step-by-Step Setup Instructions
1️⃣ Connect your Facebook Graph API to your Instagram Business Account.
2️⃣ Add OpenAI API credentials (use GPT-4 model for best results).
3️⃣ Configure Slack for team notifications and specify the channel ID.
4️⃣ Link Google Sheets and set your sheet ID for data logging.
5️⃣ Connect Microsoft Outlook for daily performance email reports.
6️⃣ Adjust the schedule (default: 10 AM daily) to suit your workflow.
7️⃣ Run a test once, verify data mapping, and enable automation. ✅