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

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. β
Download the workflow JSON file after purchase.
Open n8n β click the menu β Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
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.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.