🚀 YouTube Comment Sentiment Analyzer with Google Sheets & OpenAI Who Should Use This? Influencers, marketers, and data teams who need instant insights into audience sentiment—without manual exports or scattered tools. The Challenge Manual exports** from YouTube Studio Time-consuming** sentiment tagging Data scattered** across multiple platforms Our workflow automates everything: from fetching comments to logging analysis—so you can focus on insights, not spreadsheets. What You’ll Get Dynamic Input Read a list of YouTube URLs from your Google Sheet. Full Comment Harvest Pull all top-level comments (handles pagination 100/page). Deep Sentiment Scan Classify each comment as Positive, Neutral, or Negative using OpenAI. Smart Formatting Capture metadata (author, likes, timestamp) alongside sentiment. Seamless Storage Append or update rows in your Google Sheet—ready for reporting. Easy Setup Prepare Google Sheet Create a sheet with a video_urls column (full YouTube links). Add and authorize a Google Sheets Oauth or service-account credential in n8n. Enable YouTube API Activate Data API v3 in Google Cloud, grab an API key, and save as an HTTP credential in n8n.
Tags
Google SheetsWHTTP Request
OpenAI Chat Model
Sentiment AnalysisRelated workflows
See all AI Automation→
WScrape and summarize webpages with AI
This workflow integrates both web scraping and NLP functionalities. It uses HTML parsing to extract links, HTTP requests to fetch essay content, and AI-based summarization using GPT-4o. It's an excellent example of an end-to-end automated task that is not only efficient but also provides real value by summarizing valuable content. Note that to use this template, you need to be on n8n version 1.50.0 or later.
Monitor Japanese business partners for registry changes with gBizINFO and Gemini
Quick Overview This workflow runs weekly to check Japanese business partners listed in Google Sheets against the gBizINFO corporate registry API, uses Google Gemini to assess the risk impact of detected changes, updates the stored partner snapshot, and escalates findings to Slack and Gmail based on materiality. How it works Runs every week on a schedule. Reads the partner list (including corporate numbers and last-known name/address) from Google Sheets. Queries the gBizINFO corporate registry API for each partner and posts a Slack message if the lookup fails. Compares the latest registry data to the stored snapshot to detect name, address, or closure/dissolution changes and continues only when changes are found. Sends the detected changes to Google Gemini to classify materiality (high/medium/low) with a short summary and recommended action, and posts a Slack message if the assessment fails. Updates the Google Sheets partner snapshot with the latest registry details so the change is recorded. Routes by materiality to notify Slack (medium/other), and for high materiality also posts a Slack alert and creates a Gmail draft requesting a credit review. Setup Create a Google Sheets spread
Match Japanese jGrants subsidies to your company with Gemini, Slack and Gmail
Quick Overview This workflow runs weekly to search the public jGrants API for open Japanese subsidies, scores each subsidy’s fit for your company using Google Gemini, logs results to Google Sheets, and notifies a Slack channel (and drafts a Gmail kickoff email) for strong matches. How it works Runs weekly on a schedule and loads your company profile details (industry, headcount, prefecture, investment plan, and search keyword). Calls the public jGrants subsidies API to retrieve currently accepting programs sorted by newest first, and posts to Slack if the search fails. Processes each returned subsidy individually and asks Google Gemini to produce a fit score, verdict (strong/possible/no), reasons, next steps, and a short summary. Normalizes the Gemini response into consistent fields, and posts to Slack if scoring fails for a subsidy. Upserts each scored subsidy into a Google Sheets tracker (keyed by subsidy ID) to avoid duplicates across weekly runs. Routes results by verdict: sends a detailed Slack alert and creates a Gmail draft for strong matches, posts a lightweight Slack message for possible matches, and flags unclear verdicts in Slack. Setup Add credentials for Google Gemini