πŸ“Š Reddit comment sentiment analysis with Bright Data and Gemini AI to Google Sheets

⚑ 674 views Β· πŸ“Š Market Research & Insights

πŸ’‘ Pro Tip β€” HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it β€” it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.

View All Scrapers

Description

This workflow automatically analyzes Reddit comments to understand public sentiment and community reactions. It saves you hours of manual reading by using AI to classify comments as positive, negative, or neutral, providing instant insights into how people feel about any Reddit post.

Overview

This workflow scrapes Reddit post comments using Bright Data’s web scraping capabilities, then uses Google Gemini AI to analyze the sentiment of each comment. The results are automatically saved to Google Sheets with the comment text, sentiment classification, and reasoning behind each classification.

Tools Used

How to Install

  1. Import the Workflow: Download the .json file and import it into your n8n instance
  2. Configure Bright Data: Add your Bright Data credentials to the scraping nodes
  3. Set Up Google Gemini: Configure your Google Gemini API credentials
  4. Configure Google Sheets: Connect your Google Sheets account and copy the template spreadsheet
  5. Customize: Simply paste any Reddit post URL and run the workflow

Use Cases

Connect with Me

#n8n #automation #sentimentanalysis #reddit #brightdata #webscraping #marketresearch #n8nworkflow #workflow #nocode #brandmonitoring #communityanalysis #redditanalytics #customersentiment #sociallistening #aianalysis #publicsentiment #marketintelligence #userresearch #communityinsights #redditmonitoring #sentimenttracking #customervoice #brandreputation #socialmediaanalysis #consumerinsights #feedbackan

πŸ”— Nodes Used

Google Sheets, AI Agent, Auto-fixing Output Parser, Structured Output Parser, Google Gemini Chat Model

πŸ“₯ Import

Download workflow.json and import into n8n: Workflow menu β†’ Import from File

πŸ“– Importing guide Β· πŸ”‘ Credential setup