AutomationMart
Home/Browse/Extract and analyze 🔬 ALL Facebook post comments with sentiment AI using Gemini
n8n

Extract and analyze 🔬 ALL Facebook post comments with sentiment AI using Gemini

n8nn8n14 modulesv1.0
Google SheetsLinkedInFacebookGemini

This workflow automates the process of collecting, analyzing, and storing Facebook post comments with AI-powered sentiment analysis about YOUR Facebook Page. Typical Use Cases: Social media sentiment monitoring Brand reputation analysis Campaign performance evaluation Community management and moderation insights Reporting and analytics for marketing teams --- Key Advantages ✅ 1. Full Automation Eliminates manual work by automatically collecting and analyzing Facebook comments end-to-end. ✅

At a glance

Extract and analyze 🔬 ALL Facebook post comments with sentiment AI using Gemini is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, LinkedIn, Facebook, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, LinkedIn, Facebook, Gemini
Modules
14
Price
Free
Version
v1.0
Extract and analyze 🔬 ALL Facebook post comments with sentiment AI using Gemini workflow diagram

About this workflow

This workflow automates the process of collecting, analyzing, and storing Facebook post comments with AI-powered sentiment analysis about YOUR Facebook Page. Typical Use Cases: Social media sentiment monitoring Brand reputation analysis Campaign performance evaluation Community management and moderation insights Reporting and analytics for marketing teams --- Key Advantages ✅ 1. Full Automation Eliminates manual work by automatically collecting and analyzing Facebook comments end-to-end. ✅ 2. AI-Powered Sentiment Analysis Uses Google Gemini to accurately classify user sentiment, enabling deeper insights into audience perception and engagement. ✅ 3. Structured Data Storage Saves results directly into Google Sheets, making the data easy to analyze, share, and visualize with dashboards or reports. ✅ 4. Duplicate-Safe Updates The “append or update” logic ensures comments are not duplicated and can be refreshed if sentiment analysis changes. ✅ 5. Scalable and Robust Pagination handling, batch processing, and wait nodes allow the workflow to scale to large volumes of comments without hitting API limits. ✅ 6. Modular Architecture The use of sub-workflows makes the solution reusable and easy to integrate into larger automation pipelines (e.g. monitoring multiple posts or pages). ✅ 7. Flexible Triggering Can be run manually for testing or automatically as part of a broader workflow ecosystem. --- How it works This workflow automates the process of fetching Facebook post comments, performing sentiment analysis on each comment, and storing the results in a Google Sheet. It operates in two modes: 1. Manual execution mode: - Starts with a Manual Trigger, where the user enters a Facebook Post ID. - The workflow fetches the post details, then retrieves all comments (including pagination). - It calls a separate "Facebook" workflow (via the Call 'Facebook' node) to process each comment batch through sentiment analysis and save results to Google Sheets. 2. Triggered execution mode: - Activated via the "When Executed by Another Workflow" trigger, receiving comment data directly. - It splits and batches the incoming comments, processes each through the sentiment analysis model (Google Gemini), and appends/updates records in Google Sheets. --- Set up steps 1. Configure Facebook Graph API credentials: - Add your Facebook Graph API credentials to both "Get Fb Post" and "Get Fb comments" nodes. 2. Set up Google Gemini API credentials: - Configure the "Google Gemini Chat Model" node with valid Google PaLM/Gemini API credentials. 3. Prepare Google Sheet: - Ensure the Google Sheet exists and is accessible via the Google Sheets OAuth2 credentials. - The sheet should have (or will automatically create) columns: POST ID, COMMENT ID, COMMENT, SENTIMENT. 4. Configure the sub-workflow call: - Ensure the "Call 'Facebook'" node points to a valid, existing workflow that can process comment data. 5. Optional: Adjust batch and wait settings: - Modify the "Loop Over Items" node if different batch sizes are needed. - Adjust the "Wait" node delay if required to avoid rate limits. 6. Activate the workflow: - Toggle the workflow to active if scheduled or webhook execution is desired. - Test using the Manual Trigger with a sample Facebook Post ID. --- 👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. []( --- Need help customizing? Contact me for consulting and support or add me on Linkedin.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Analyze brand competitors using Decodo, Gemini, Telegram and Google Sheets

Analyze brand competitors using Decodo, Gemini, Telegram, and Google Sheets Sign up for Decodo — get better pricing here Who’s it for This workflow is built for content researchers, SEO teams, marketers, educators, and analysts who want to discover and analyze Brand competitor content at scale. It’s especially useful if you need structured insights from pages based on a search query, without manually opening or reviewing each result. How it works / What it does This workflow turns a simple keywo

Free

Auto create & publish X-threads (Twitter) with GPT via Telegram & approval loop

AI X (twitter) Threads Bot with Approval Loop This n8n workflow transforms your Telegram messenger into a personal assistant for creating and publishing X-Threads. You can simply send an idea as a text or voice message, collaboratively edit the AI’s suggestion in a chat, and then publish the finished thread directly to X just by saying “Okay.” What You’ll Need to Get Started Before you can use this workflow, you’ll need a few prerequisites set up. This workflow connects three different services,

Free

Amplify social media presence with O3 and GPT-4 multi-agent team

Amplify Social Media Presence with O3 and GPT-4 Multi-Agent Team 🌍 Overview This n8n workflow acts like a virtual social media department. A Social Media Director Agent coordinates multiple specialized AI agents (Instagram, Twitter/X, Facebook, TikTok, YouTube, and Analytics). Each agent creates or analyzes content for its platform, powered by OpenAI models. The result? A fully automated, cross-platform social media strategy—from content creation to performance tracking. --- 🟢 Section 1: Trigger

Free

Compare GPT-4, Claude & Gemini Responses with Contextual AI's LMUnit Evaluation

PROBLEM Evaluating and comparing responses from multiple LLMs (OpenAI, Claude, Gemini) can be challenging when done manually. - Each model produces outputs that differ in clarity, tone, and reasoning structure. - Traditional evaluation metrics like ROUGE or BLEU fail to capture nuanced quality differences. - Human evaluations are inconsistent, slow, and difficult to scale. This workflow automates LLM response quality evaluation using Contextual AI’s LMUnit, a natural la

Free

Create Facebook ads copy with Google Sheets and ChatGPT: PAS formula

Master Facebook Ads copy creation using Google Sheets and ChatGPT by applying the effective Pain, Agitate, Solution (PAS) copywriting formula. Optimize your ad results while simplifying your social media marketing approach.

Free

Convert YouTube videos into SEO blog posts with GPT-4o, Dumpling AI, and Flux

Workflow Description This workflow helps content creators automatically repurpose YouTube videos into SEO-friendly blog posts. It extracts the video transcript, uses AI to generate a full blog post with a relevant image, and sends the complete package via email, ready for publication. Prerequisites/Requirements This workflow relies on external AI services. You will need: 1. OpenAI Account: Used for generating the blog post text (specifically mentioned using GPT-4o in the workflow notes). Creden

Free

Automated SEO watchlist: continuous audits with Decodo, Gemini & Google Sheets

Automated SEO Watchlist: Continuous Audits Powered by Decodo, Gemini and Google Sheets Automate continuous SEO audits with Decodo and Gemini AI — live data, smart insights, and Google Sheets tracking with team alerts. Who’s it for This workflow is designed for SEO specialists, marketing teams, agencies, and website owners who want an effortless, automated way to monitor SEO health. It’s perfect for ongoing audits, content monitoring, and proactive SEO management — without the manual work

Free

Clone LinkedIn writing styles with AI analysis & prompt generation to Airtable

Boost Your Content Speed & Grow Authority in Your LinkedIn Space Are you tired of spending HOURS crafting the perfect LinkedIn posts? This revolutionary n8n workflow is changing the game for content creators, marketing agencies, and business leaders worldwide. WHAT MAKES THIS TOOL A GAME-CHANGER The LinkedIn Style Extractor & Prompt Generator uses cutting-edge AI technology to analyze ANY LinkedIn profile, extract their unique writing fingerprint, and create custom AI prompts that perfectly re

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free