Automated Facebook Page Comment Management with OpenAI & Google Sheets
Who Is This For?
Facebook Page admins, social media managers, and community moderators who want to automate comment monitoring, respond to positive/supportive comments, and manage negative content efficiently.
What This Workflow Does
This n8n workflow monitors Facebook Page comments, classifies them using OpenAI, replies to positive/supportive comments, deletes negative comments, tracks repeat offenders, and logs all interactions in Google Sheets.
Key Features
- Automated comment monitoring from Facebook Pages
- AI-powered classification into positive, supportive, or negative comments
- Human-like response generation in the comment's language (English/Bangla)
- Negative comment deletion and tracking in Google Sheets
- Automatic banning of repeat negative commenters
- Only processes comments without admin replies
- Comprehensive logging for analysis
Requirements
- Facebook Page access with Graph API credentials
- OpenAI API credentials for comment classification
- Google Sheets account for logging
- n8n instance (self-hosted or cloud)
- Configured Facebook Page ID
Google Sheet Column Structure
A sample sheet ➤ Google Sheet Example
Workflow Components
1. Post Retrieval
- Start: Manual trigger
- Get 0-100 Posts from Page
- Split All Posts & Loop Over Posts
2. Comment Processing
- Get Individual Post Comments
- Check Comment Presence
- Split All Comments & Loop Over Comments
- Get Any Reply in Comment & Check Reply
3. Admin Reply Detection
- Edit Fields: Extract comment data
- Filter comments without admin replies
- Prepare comments for AI classification
4. Comment Classification
- Loop Over Comments Without Admin Reply
- Use OpenAI to classify comments
5. Response Generation
- Switch node routes comments based on classification
- Positive Reply: Human-like friendly response
- Support Reply: Warm, appreciative response
- Reply to Comment: Posts response on Facebook
6. Negative Comment Handling
- Delete negative comments
- Log in Google Sheets
- Count repeat negative comments per user
- Ban user if repeat offender
- Update Google Sheet status to
banned
7. Optional Features
- Send warning messages via Facebook Graph API
Support & Help