Analyze Facebook comment sentiment with GPT-4, Slack, Sheets & Outlook reports
Description Automatically analyze the sentiment of Facebook posts and their audience comments using GPT-4 to identify trends and potential PR risks. 🧠💬 This workflow fetches recent posts via the Facebook Graph API, performs AI-powered sentiment analysis on both posts and comments, routes negative results to Slack for immediate attention, logs all data into Google Sheets, and sends a beautifully formatted sentiment summary report via Outlook. 📈📧 What This Template Does 1️⃣ Trigger – Runs daily a
At a glance
Analyze Facebook comment sentiment with GPT-4, Slack, Sheets & Outlook reports is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Slack, Google Sheets, OpenAI, Outlook. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Slack, Google Sheets, OpenAI, Outlook, Facebook
- Modules
- 15
- Price
- Free
- Version
- v1.0

About this workflow
Description Automatically analyze the sentiment of Facebook posts and their audience comments using GPT-4 to identify trends and potential PR risks. 🧠💬 This workflow fetches recent posts via the Facebook Graph API, performs AI-powered sentiment analysis on both posts and comments, routes negative results to Slack for immediate attention, logs all data into Google Sheets, and sends a beautifully formatted sentiment summary report via Outlook. 📈📧 What This Template Does 1️⃣ Trigger – Runs daily at 10 AM to fetch the latest Facebook posts. ⏰ 2️⃣ Data Extraction – Pulls post text, reactions, and up to 100 comments per post using Facebook Graph API. 📲 3️⃣ Formatting – Structures and cleans Facebook data for AI analysis. 🧩 4️⃣ AI Sentiment Analysis – GPT-4 evaluates post tone and audience sentiment with confidence scores and explanations. 🤖 5️⃣ Routing – Sends negative sentiment alerts directly to Slack for quick response. ⚠️ 6️⃣ Logging – Records all sentiment metrics in Google Sheets, including positivity ratio and engagement data. 📊 7️⃣ Reporting – Generates a color-coded HTML email report and delivers it via Outlook. 💌 8️⃣ Error Handling – Sends Slack alerts if any node in the workflow fails. 🛡️ Key Benefits ✅ Monitors brand reputation automatically across Facebook comments ✅ Provides structured AI sentiment reports for data-driven decisions ✅ Flags negative audience sentiment for timely intervention ✅ Maintains an always-updated sentiment log in Google Sheets ✅ Delivers professional HTML summary emails to teams Features - Automated daily trigger for post sentiment scanning - Facebook Graph API integration for posts and comments - GPT-4–powered comment tone and sentiment scoring - Slack notifications for negative sentiment alerts - Google Sheets sentiment dashboard logging - Beautiful HTML report delivery through Microsoft Outlook - Built-in error detection with Slack fallback alerts Requirements - Facebook Graph API credentials with pagesreadengagement access - OpenAI API key for GPT-4 or GPT-4o - Slack Bot token with chat:write permission - Google Sheets OAuth2 credentials with edit rights - Microsoft Outlook OAuth2 credentials for email delivery Target Audience - Social media and marketing teams monitoring brand perception 📣 - PR teams managing engagement or audience sentiment 🧾 - Analysts building data dashboards from engagement metrics 📊 - Agencies offering automated reporting for client pages 🧑💼 Step-by-Step Setup Instructions 1️⃣ Connect Facebook Graph API credentials and set your page ID. 2️⃣ Add OpenAI credentials for GPT-4 sentiment analysis. 3️⃣ Configure Slack and provide your channel ID for alerts. 4️⃣ Set Google Sheets credentials and specify sheet ID and name. 5️⃣ Connect Microsoft Outlook for email report delivery. 6️⃣ Adjust the daily schedule (default 10 AM) as needed. 7️⃣ Run once manually to verify setup, then enable automation. ✅
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Transform new orders from WooCommerce to Offline events in Facebook
Generate texts from prompts with Eden AI from new Google Sheet rows
Create a new Pinterest pin for every new row in Google Sheets
Automate AI phone booking & CRM updates with GPT-4, VAPI.ai, and GHL
My solution for the "Agentic Arena Community Contest" (RAG, Qdrant, Mistral OCR)
Automated brand mentions tracker with GPT-4o, Google Sheets, and email
Daily AI news translation & summary with GPT-4 and Telegram delivery
Automated website uptime monitor with email alerts & GitHub status page update
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you