Marketing medium to set up

Facebook Comment Sentiment Analysis

Fetches comments from a Facebook post, analyzes sentiment with Gemini, and updates a Google Sheet without duplicates.

Verified 2026-07-07

Marketer

What it does

You automatically gather comments from your Facebook posts, analyze their sentiment using AI, and save the results to a Google Sheet without duplicates. This workflow handles pagination seamlessly so you can run it manually for testing or trigger it as part of your automation pipeline.

How it works

When it runs: Run manually · Manual · on demand or Scheduled
How hands-off: Assists you, you do the final step
Setup: An afternoon · about an afternoon
Works with: Facebook Graph API, Google Gemini Chat Model, Google Sheets

Tools that fit

api

Facebook Graph API : Fetching post comments

LLM

Google Gemini Chat Model : Sentiment classification

Services

Google Sheets : Storing analysis results

Watch out for

Facebook API rate limits can block large batches, so implement a delay between pagination requests to avoid temporary bans.
Duplicate entries may clutter your sheet if the update logic fails, so verify that the unique ID check runs before every insert operation.
Sentiment models often misinterpret sarcasm or context-heavy comments, so add a low-confidence flag column for manual review later.
API token expiration will halt the workflow indefinitely, so configure automatic token refresh or use a service account with extended validity.

Seen in the wild

n8n: Extract and analyze 🔬 ALL Facebook post comments with sentiment AI using Ge template

Want this running in your business?

This is what I do. I design and build AI agents like this one, and keep them running. If you want it set up for your team instead of doing it yourself, get in touch.

Get in touch

Who it's for

Built for marketers who'd rather brief an agent than start from a blank doc.

Frequently asked questions

Who is this for?

marketers, or anyone doing marketing work who wants this handled automatically rather than manually.

How long does it take to set up?

An afternoon: plan for about an afternoon to get it running end to end.

Related use cases

← Back to directory