Reddit Sentiment Analysis for Apple WWDC25 with Gemini AI & Sheets

This n8n workflow performs automated sentiment analysis on Reddit discussions about Apple's WWDC25 event. It uses Bright Data to scrape relevant posts and comments based on customizable search terms, dates, and sorting. A polling mechanism checks scraping status before proceeding to process each comment individually with Google Gemini AI for accurate sentiment categorization (positive, negative, neutral).

Results are compiled and appended to a Google Sheet, providing a structured dashboard for tracking public opinion trends. Benefits include time-saving automation of manual monitoring, scalable analysis for large comment volumes, and actionable insights for marketing or PR teams. No coding required post-setup, with easy parameter tweaks for other events or topics.

Ideal use cases: Event monitoring (e.g., product launches), brand reputation tracking, competitive analysis on social media, or market research. Prerequisites include Bright Data for scraping, Gemini API key, and Google Sheets OAuth credentials. High-value for businesses needing real-time social sentiment data.