📊 Social media sentiment analysis dashboard with custom AI for Twitter, Reddit & LinkedIn

⚡ 1,711 views · 📊 Market Research & Insights

💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.

Description

🎯 Target Audience

Social media managers and community managers
Marketing teams monitoring brand reputation
PR professionals tracking public sentiment
Customer service teams identifying trending issues
Business analysts measuring social media ROI
Brand managers protecting brand reputation
Product managers gathering user feedback

🚀 Problem Statement

Manual social media monitoring is overwhelming and often misses critical sentiment shifts or trending topics. This template solves the challenge of automatically collecting, analyzing, and visualizing social media sentiment data across multiple platforms to provide actionable insights for brand management and customer engagement.

🔧 How it Works

This workflow automatically monitors social media platforms using AI-powered sentiment analysis, processes mentions and conversations, and provides real-time insights through a comprehensive dashboard.

Key Components

Scheduled Trigger - Runs the workflow at specified intervals to maintain real-time monitoring
AI-Powered Sentiment Analysis - Uses advanced NLP to analyze sentiment, emotions, and topics
Multi-Platform Integration - Monitors Twitter, Reddit, and other social platforms
Real-time Alerting - Sends notifications for critical sentiment changes or viral content
Dashboard Integration - Stores all data in Google Sheets for comprehensive analysis and reporting

📊 Google Sheets Column Specifications

The template creates the following columns in your Google Sheets:

Column	Data Type	Description	Example
timestamp	DateTime	When the mention was recorded	”2024-01-15T10:30:00Z”
platform	String	Social media platform	”Twitter”
username	String	User who posted the content	”@john_doe”
content	String	Full text of the post/comment	”Love the new product features!“
sentiment_score	Number	Sentiment score (-1 to 1)	0.85
sentiment_label	String	Sentiment classification	”Positive”
emotion	String	Primary emotion detected	”Joy”
topics	Array	Key topics identified	[“product”, “features”]
engagement	Number	Likes, shares, comments	1250
reach_estimate	Number	Estimated reach	50000
influence_score	Number	User influence metric	0.75
alert_priority	String	Alert priority level	”High”

🛠️ Setup Instructions

Estimated setup time: 20-25 minutes

Prerequisites

n8n instance with community nodes enabled
ScrapeGraphAI API account and credentials
Google Sheets account with API access
Slack workspace for notifications (optional)
Social media API access (Twitter, Reddit, etc.)

Step-by-Step Configuration

1. Install Community Nodes

# Install required community nodes
npm install n8n-nodes-scrapegraphai
npm install n8n-nodes-slack

2. Configure ScrapeGraphAI Credentials

Navigate to Credentials in your n8n instance
Add new ScrapeGraphAI API credentials
Enter your API key from ScrapeGraphAI dashboard
Test the connection to ensure it’s working

3. Set up Google Sheets Connection

Add Google Sheets OAuth2 credentials
Grant necessary permissions for spreadsheet access
Create a new spreadsheet for sentiment analysis data
Configure the sheet name (default: “Sentiment Analysis”)

Update the websiteUrl parameters in ScrapeGraphAI nodes
Add URLs for social media platforms you want to monitor
Customize the user prompt to extract specific sentiment data
Set up keywords, hashtags, and brand mentions to track

5. Set up Notification Channels

Configure Slack webhook or API credentials
Set up email service credentials for alerts
Define sentiment thresholds for different alert levels
Test notification delivery

6. Configure Schedule Trigger

Set monitoring frequency (every 15 minutes, hourly, etc.)
Choose appropriate time zones for your business hours
Consider social media platform rate limits

7. Test and Validate

Run the workflow manually to verify all connections
Check Google Sheets for proper data formatting
Test sentiment analysis with sample content

🔄 Workflow Customization Options

Modify Monitoring Targets

Add or remove social media platforms
Change keywords, hashtags, or brand mentions
Adjust monitoring frequency based on platform activity

Extend Sentiment Analysis

Add more sophisticated emotion detection
Implement topic clustering and trend analysis
Include influencer identification and scoring

Customize Alert System

Set different thresholds for different sentiment levels
Create tiered alert systems (info, warning, critical)
Add sentiment trend analysis and predictions

Output Customization

Add data visualization and reporting features
Implement sentiment trend charts and graphs
Create executive dashboards with key metrics
Add competitor sentiment comparison

📈 Use Cases

Brand Reputation Management: Monitor and respond to brand mentions
Crisis Management: Detect and respond to negative sentiment quickly
Customer Feedback Analysis: Understand customer satisfaction and pain points
Product Launch Monitoring: Track sentiment around new product releases
Competitor Analysis: Monitor competitor sentiment and engagement
Influencer Identification: Find and engage with influential users

🚨 Important Notes

Respect social media platforms’ terms of service and rate limits
Implement appropriate delays between requests to avoid rate limiting
Regularly review and update your monitoring keywords and parameters
Monitor API usage to manage costs effectively
Keep your credentials secure and rotate them regularly
Consider privacy implications and data protection regulations

🔧 Troubleshooting

Common Issues:

ScrapeGraphAI connection errors: Verify API key and account status
Google Sheets permission errors: Check OAuth2 scope and permissions
Sentiment analysis errors: Review the Code node’s JavaScript logic
Rate limiting: Adjust monitoring frequency and implement delays
Alert delivery failures: Check notification service credentials

Support Resources:

ScrapeGraphAI documentation and API reference
n8n community forums for workflow assistance
Google Sheets API documentation for advanced configurations
Social media platform API documentation
Sentiment analysis best practices and guidelines

🔗 Nodes Used

Google Sheets, Slack, Webhook, Schedule Trigger

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup