AI-powered Facebook comment management: Auto-reply, delete, ban & notify

Description

Who is this for?
This n8n workflow is designed for Facebook Page administrators, social media managers, and community moderators who want to automate comment management on their Facebook Pages. It's perfect for businesses with high comment volume, content creators, and marketing teams who need to maintain a positive community environment without manually reviewing every comment. The workflow automatically filters and responds to positive/supportive comments while handling negative ones appropriately.

What this Workflow Does
This n8n workflow monitors Facebook Page comments, classifies them using OpenAI, automatically responds to positive and supportive comments, and handles negative comments by deleting them and tracking repeat offenders. It can ban users who repeatedly post negative content and maintains a record of all interactions in Google Sheets.

Key Features
Automated Comment Monitoring**: Fetches posts and comments from a Facebook Page
AI-Powered Classification**: Uses OpenAI to classify comments into positive, supportive, or negative categories
Intelligent Response Generation**: Creates human-like replies in the same language as the original comment (English or Bangla)
Negative Comment Management**: Deletes negative comments and tracks them in Google Sheets
User Banning System**: Automatically bans users who repeatedly post negative content
Admin Reply Detection**: Only processes comments that haven't already received admin replies
Comprehensive Logging**: Records all comment interactions in Google Sheets for analysis

Requirements
Facebook Page access with Graph API credentials
OpenAI API credentials for comment classification
Google Sheets account for logging comment data
n8n instance (self-hosted or cloud)
Facebook Page ID (configured as 47104xxxxx69097 in the workflow)

Google Sheet Column Structure
A Google Sheet formatted like this** ➤ sample

Workflow Components
1. Post Retrieval Section
Start**: Manual trigger to begin the workflow
Get 0-100 Posts from Page**: Fetches up to 100 recent posts
Split All Posts**: Breaks each post into individual items
Loop Over Posts**: Iterates through each post for further processing

2. Comment Processing Section
Get Individual Post Comments**: Retrieves comments for each post
Check Comment**: Verifies the presence of comments
Split All Comments**: Splits retrieved comments into individual items
Loop Over Comments**: Iterates through comments one by one
Get Any Reply in Comment**: Checks if the comment has admin replies
Check Reply**: Confirms presence or absence of replies

3. Admin Reply Detection
Edit Fields**: Extracts relevant data from comments
Separatamento Without Admin Reply**: Filters out comments that haven't received admin replies
Check Comment1**: Validates if such comments exist
Split Out Without Admin Reply Comments**: Prepares these comments for AI classification

4. Comment Classification (via OpenAI)
Loop Over Items2**: Loops through comments without admin replies
Replay Comment Data**: Uses OpenAI to classify comments

5. Response Generation
Switch**: Routes comments based on classification
Positive Replay**: Generates a friendly, human-like reply for positive comments
Support Replay**: Generates a warm, appreciative reply for supportive comments
Reply to Comment**: Posts the AI-generated reply on Facebook

6. Negative Comment Handling
Delete Comment**: Removes negative comments from Facebook
Append Row in Sheet**: Logs comment details in Google Sheets
Get Row in Sheet**: Retrieves user history from the sheet
Code in JavaScript**: Counts how many negative comments the user has posted
If**: Checks if user has more than 1 negative comment
Banned User**: Executes a Facebook ban on repeat offenders
Update Row in Sheet**: Updates the user's status to banned in Google Sheets

7. Optional Features
Facebook Graph API**: Sends warning messages to users with negative comments

Support & Help
WhatsApp**: Chat on WhatsApp
Discord**: SpaGreen Community
Facebook Group**: SpaGreen Support
Website**: https://spagreen.net
Developer Portfolio**: Codecanyon SpaGreen