Analyze Facebook comment sentiment with GPT-4, Slack, Sheets & Outlook reports
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 15 nodes and runs on a schedule (every day at 10:00) (plus 1 other trigger). Along the way it connects Slack, Facebook Graph API, OpenAI Chat Model and Google Sheets and 1 more.
How it runs
Trigger: On a schedule (every day at 10:00) (plus 1 other trigger).
- Fetch Recent Facebook Posts (Facebook Graph API): uses Facebook Graph API
- Slack: uses Slack
- Format Facebook Data (Code Node) (Code): runs custom JavaScript code
- 💬 Agent - Sentiment & Tone Evaluator (AI Agent): runs an AI agent, with model: LLM - OpenAI GPT-4 Model; memory: Memory Buffer - Session Context; output parser: Structured JSON Parser
- Route Based on Sentiment Score (Switch): routes items into 2 branches
- Slack: uses Slack
- Prepare Data for Google Sheets (Code): runs custom JavaScript code
- Format HTML Email Report (Code Node) (Code): runs custom JavaScript code
- Update Google Sheet - Sentiment Log (Google Sheets): append or update
- Send Sentiment Report (Outlook) (Microsoft Outlook): uses Microsoft Outlook
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (12)
- Error Trigger
n8n-nodes-base.errorTrigger - Slack
n8n-nodes-base.slack - Facebook Graph API
n8n-nodes-base.facebookGraphApi - AI Agent
@n8n/n8n-nodes-langchain.agent - Switch
n8n-nodes-base.switch - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Code
n8n-nodes-base.code - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Microsoft Outlook
n8n-nodes-base.microsoftOutlook
From the author
📊 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…