Analyze Facebook Comment Sentiment with OpenAI + Sheets + Gmail

Analyze Facebook Comment Sentiment end-to-end with OpenAI, Google Sheets, and Gmail

This n8n workflow pulls comments from a Facebook Page post, classifies each comment’s sentiment using OpenAI, saves the results to Google Sheets, and emails you an aggregated sentiment breakdown via Gmail—so you can quickly understand how your audience feels.

What this workflow does

• Configures and targets a Facebook post on a manual run, loading required settings to fetch the correct post details.
• Fetches comments through the Facebook Graph API in reverse-chronological order, paginating through comment pages up to your configured maximum.
• Batch-processes each fetched comment page by re-invoking the workflow with the comments passed in as input.
• Classifies sentiment with OpenAI for each individual comment, mapping results into your configured sentiment categories and throttling requests with a short wait.
• Stores results in Google Sheets, using COMMENT ID as the deduplication key to append or update rows containing: POST ID, COMMENT ID, COMMENT, and SENTIMENT.
• Aggregates sentiment counts by reading stored rows for the post and calculating totals per sentiment category.
• Sends a summary email via Gmail to the configured recipient with the sentiment breakdown.

Use cases

• Monitor audience reactions to new Facebook Page posts and get a daily/weekly sentiment snapshot.
• Support customer insights workflows by automatically labeling comments with sentiment categories for later analysis.
• Provide operators and SaaS teams a lightweight reporting pipeline: Facebook → OpenAI → Sheets → email.

Technical details

• Facebook Graph API: fetches post details and comments (paginated).
• OpenAI: sentiment classification per comment into configured categories.
• Google Sheets: OAuth-connected storage with columns for POST ID, COMMENT ID, COMMENT, and SENTIMENT; deduplication by COMMENT ID.
• Gmail: emails the aggregated sentiment summary.
• n8n nodes/logic: if, set, wait, gmail, split out, aggregate.