{"product_id":"analyze-facebook-comment-sentiment-with-openai-sheets-gmail","title":"Analyze Facebook Comment Sentiment with OpenAI + Sheets + Gmail","description":"\u003ch3\u003eAnalyze Facebook Comment Sentiment end-to-end with OpenAI, Google Sheets, and Gmail\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfigures and targets a Facebook post\u003c\/strong\u003e on a manual run, loading required settings to fetch the correct post details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches comments through the Facebook Graph API\u003c\/strong\u003e in reverse-chronological order, paginating through comment pages up to your configured maximum.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBatch-processes each fetched comment page\u003c\/strong\u003e by re-invoking the workflow with the comments passed in as input.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies sentiment with OpenAI\u003c\/strong\u003e for each individual comment, mapping results into your configured sentiment categories and throttling requests with a short wait.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStores results in Google Sheets\u003c\/strong\u003e, using \u003cem\u003eCOMMENT ID\u003c\/em\u003e as the deduplication key to append or update rows containing: POST ID, COMMENT ID, COMMENT, and SENTIMENT.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAggregates sentiment counts\u003c\/strong\u003e by reading stored rows for the post and calculating totals per sentiment category.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a summary email via Gmail\u003c\/strong\u003e to the configured recipient with the sentiment breakdown.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor audience reactions to new Facebook Page posts and get a daily\/weekly sentiment snapshot.\u003c\/li\u003e\n  \u003cli\u003eSupport customer insights workflows by automatically labeling comments with sentiment categories for later analysis.\u003c\/li\u003e\n  \u003cli\u003eProvide operators and SaaS teams a lightweight reporting pipeline: Facebook → OpenAI → Sheets → email.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFacebook Graph API\u003c\/strong\u003e: fetches post details and comments (paginated).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e: sentiment classification per comment into configured categories.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth-connected storage with columns for POST ID, COMMENT ID, COMMENT, and SENTIMENT; deduplication by COMMENT ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: emails the aggregated sentiment summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic\u003c\/strong\u003e: if, set, wait, gmail, split out, aggregate.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45761002373299,"sku":"N8N-17839","price":61.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/CnHyUl3xZJAMETN1FcgAP_kre5nXXZ.png?v=1785920719","url":"https:\/\/buyflowscripts.com\/products\/analyze-facebook-comment-sentiment-with-openai-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}