AI Workflows
Artificial Intelligence tools and workflows
YouTube Comment Sentiment Analysis with Google Gemini AI and Google Sheets
This workflow automatically **collects all comments from a specified YouTube video and analyzes the sentiment of each comment using an AI model** (e.g., GPT, Claude, or Gemini). The sentiment (**Positive, Neutral, or Negative**), its strength, and confidence score are extracted and saved into a connected **Google Sheet** for easy access, reporting, and visualization. --- ### **Advantages:** **AI-Powered Sentiment Analysis** * Uses modern language models (LLMs) to categorize comments with high accuracy. **Ideal for YouTube Creators & Marketers** * Provides insights into audience perception of videos, campaigns, or products. **Real-Time Feedback Monitoring** * Quickly identify trends in viewer sentiment across large comment volumes. **Automatic Reporting** * Saves results in Google Sheets for easy sharing or dashboard integration. **Handles Pagination** * Automatically fetches all comments, even from multi-page videos. **No-Code Customization** * Easily adaptable to other platforms (e.g., TikTok, Instagram) or data sources. **Simple Setup** * Requires just a YouTube video ID and API key - no coding needed. **Loop and Update Logic** * Continuously updates sheet with new results, avoiding duplicate processing. **Modular Design** * Easy to expand (e.g., reply classification, toxic comment detection, translation). **Multi-Language Compatibility** * AI can be configured to analyze comments in different languages with minimal setup.  --- ### **How It Works** 1. **Trigger**: The workflow starts manually (When clicking "Test workflow") or can be scheduled. 2. **Fetch Comments**: The Get API Comments node retrieves comments from a YouTube video using the YouTube API. 3. **Process Comments**: - Extracts comments and replies via the Comments node. - Splits them into individual entries (Split comments). - Saves raw comments to Google Sheets (Save comments). 4. **Sentiment Analysis**: - Uses **Google Gemini AI** (or another model) to classify each comment as **Positive, Neutral, or Negative**. - Captures **strength** and **confidence** metrics for deeper insights. 5. **Update Results**: The Update sentiment node writes the analysis back to Google Sheets, marking processed rows. 6. **Pagination Handling**: Checks for multiple pages of comments (Multipage?) and loops until all are processed. --- ### **Set Up Steps** 1. **Prepare Google Sheet**: - Clone the template: [YouTube Comments Sheet](https://docs.google.com/spreadsheets/d/14lAY5CjoYHqqFODiLGg636Gqw4JwWqb2CX10E8ZS6Uo/edit). - Ensure columns exist: `VIDEO_ID`, `COMMENTS`, `SENTIMENT`, `STRENGTH`, `CONFIDENCE`, and `DONE` (tracking column). 2. **Configure YouTube API**: - Obtain a **YouTube API key** from [Google Developers Console](https://developers.google.com/youtube/registering_an_application). - Add it to the Get API Comments node under **Youtube Query Auth** (parameter: `key`). 3. **Set Video ID**: - Replace the default `xxxxxxxx` in the ID Video node with your target YouTube video ID. 4. **AI Integration**: - Ensure **Google Gemini API** credentials are configured in the Google Gemini node. 5. **Run the Workflow**: - Test manually or automate execution (e.g., hourly/daily) to analyze new comments. **Output**: A Google Sheet with categorized sentiments, enabling **trend analysis and audience engagement tracking**. --- ### **Need help customizing?** [Contact me](mailto:info@n3w.it) for consulting and support or add me on [Linkedin](https://www.linkedin.com/in/davideboizza/).
n8n$9.99AI-Powered Chat Integration for Dynamic Data Retrieval
This workflow harnesses the capabilities of AI to create an interactive chat experience that pulls data from various sources, specifically designed for applications like customer support, data analysis, and information retrieval. By integrating wi...
n8n$14.2Extract Receipt Data with AI Vision and Store in Airtable
Automates pulling key details like amount, merchant, date, and category from uploaded receipts using AI OCR, then stores them in Airtable for seamless expense tracking.
n8n$12.99Wait Code Automation Webhook for Image Generation
The '1400WaitCodeAutomationWebhook' workflow is designed to facilitate the automated generation of images based on specific textual prompts through an HTTP request to an AI image generation API. This workflow is particularly useful for projects th...
n8n$12.99Automate RSS Feed Updates to Slack for Daily News Sharing
This workflow automates the process of fetching RSS feed items and sharing them on Slack every morning.
n8n$9.51Automate Image Generation and Tracking with Perplexity AI, ChatGPT, and Google Sheets
Streamline your creative projects by automating image generation with Perplexity AI and ChatGPT, storing results in Google Drive, and tracking updates in Google Sheets.
Make$4.99Automate Facebook Lead Ads Processing with ChatGPT and API Integration
Streamline your lead management by automatically processing Facebook Lead Ads data with ChatGPT and sending insights to your API. Enhance decision-making with AI-driven insights.
Make$3.99Transform eBay Recommendation API for AI Agent Integration
Convert eBay's Recommendation API into an MCP-compatible server for seamless AI agent interaction, enabling automated listing optimization.
n8n$4.99Automated Website Screenshot Capture and Export Workflow
This workflow automates the process of capturing website screenshots using the Bright Data Web Unlocker. By leveraging this automation, users can quickly obtain high-quality images of web pages without manual intervention. The workflow is designed...
n8n$13.91Automate Company ICP Scoring with Explorium Data and Claude AI Analysis
# ICP Scoring Agent (n8n + Explorium + LLM) This workflow automates Ideal Customer Profile (ICP) scoring for any company using a combination of Explorium data and an LLM-driven evaluation framework. --- ## How It Works 1. **Input**: Company name is submitted via form. 2. **Data Enrichment**: Explorium's MCP Server is used to fetch firmographic, hiring, and tech data about the company. 3. **Scoring Logic**: An AI agent (LLM) applies a 3-pillar framework to assess and score the company. 4. **Output**: A structured JSON or Google Doc summary is generated using the AgentGeeks formatter. --- ## Scoring System (100 points total) | Pillar | Max Points | |-----------------------|------------| | Strategic Fit | 40 | | AI / Tech Readiness | 40 | | Engagement & Reachability | 20 | ### Scoring Criteria - **Strategic Fit**: Industry, size, use case, buyer roles - **Tech Readiness**: AI maturity, hiring trends, stack visibility - **Reachability**: Geography, contactability, data quality --- ## Verdict Scale - **90-100**: Ideal ICP - **70-89**: Good Fit - **40-69**: Medium Fit - **< 40**: Poor Fit --- ## Workflow Components - **Trigger**: Form submission via webhook - **MCP Client**: Pulls enriched company data via Explorium's MCP API - **AI Agent**: Uses Anthropic Claude (or other LLM) to calculate scores - **Output**: Results are posted to a structured endpoint (e.g., Google Doc or JSON API) --- ## Dependencies - [n8n](https://n8n.io/) (self-hosted or cloud) - Explorium MCP credentials and access - LLM API (e.g., Anthropic Claude, OpenAI, etc.) - Optional: AgentGeeks formatter or similar doc generator --- ## Use Case This ICP scoring system is designed for GM and sales teams to: - Automate lead prioritization - Qualify accounts before outbounding - Sync ICP data into CRMs, routing systems, or reporting layers --- ## Example Output in Google Doc ```json { "company": "Acme Inc.", "score": 87, "verdict": "Good Fit", "pillars": { "strategic_fit": 35, "tech_readiness": 37, "reachability": 15 }, "summary": "Acme Inc. is a mid-sized SaaS company with strong AI hiring activity and a buyer profile aligned to enterprise IT. Moderate reachability via firmographic signals." } ```
n8n$4.99Automate Business Idea Generation from Reddit Posts with AI and Google Sheets
Leverage this n8n workflow to extract high-potential business ideas from Reddit discussions using AI analysis and store them in Google Sheets for easy access.
n8n$14.99Instagram Collab Leads: Apify Scraping + GPT-4o Eval
Automates Instagram lead gen by scraping hashtag posts with Apify, extracting profiles, and using GPT-4o to evaluate collab potential based on followers & bio.
n8n$24.99Automate Translation File Uploads from RWS Language Cloud to Monday.com
This workflow automates the process of checking translation statuses in RWS Language Cloud and uploading completed translations to Monday.com items, updating their status to 'Done'.
Make$4.99Extract & Transform HackerNews Data to Google Docs using Gemini
Scrapes latest HackerNews discussions, transforms raw threads into readable insights using Gemini 2.0 Flash, and exports to formatted Google Docs.
n8n$19.99Enable AI Agents to Perform Kitemaker Operations via MCP Server
Set up a complete MCP server to allow AI agents to execute all Kitemaker operations without configuration. This workflow includes pre-built operations for seamless integration.
n8n$9.99Streamline AI Agent Workflows with the New HTTP Tool in n8n
Leverage the new HTTP tool in n8n to simplify AI agent workflows by replacing complex sub-workflows with streamlined HTTP requests.
n8n$9.99Set Up an MCP Server for IP2Proxy Proxy Detection
Transform the IP2Proxy Proxy Detection API into an MCP-compatible server for AI agents, enabling seamless proxy detection by IP address.
n8n$4.99Automate Voice Notifications with Anthropic Claude and Eleven Labs
Generate a message using Anthropic Claude, convert it to speech with Eleven Labs, and send it via HTTP. Ideal for creating automated voice notifications.
Make$3.99AI-Powered Daily Gratitude Reminder Bot for LINE
Sends personalized AI-generated gratitude reminders every evening at 9 PM via LINE using Azure OpenAI to promote mental wellness and reflection.
n8n$12.99Automate Zoom Recording Translation and Sharing via Slack
Automatically translate Zoom recordings to English using OpenAI's Whisper, summarize them, convert to audio with ElevenLabs, and share via Slack to streamline team communication.
Make$4.99Create a WordPress post for every new message from 2 Anthropic Claude prompts based on Google Sheets row updates
Get your WordPress posts generated on auto-pilot from 2 Anthropic Claude prompts (title and content) when a Google Sheets row updates, streamlining content creation.
Make$4.99Automate Structured Data Extraction and Analysis with Bright Data and Google Gemini
This workflow automates the extraction and analysis of structured data from web sources using Bright Data and Google Gemini, ideal for researchers, marketers, and AI developers.
n8n$14.99Automate Google Sheets Updates with AI-Generated Insights
This workflow automates the process of filtering Google Sheets rows, generating AI insights using Perplexity AI and OpenAI GPT-3, and updating the sheets with the generated data. It enhances data management and decision-making efficiency.
Make$4.99Generate 3D Figurine Orthographic Views Using Midjourney and GPT-4o-Image API
This workflow automates the creation of orthographic views for 3D models using the Midjourney and GPT-4o-Image APIs. It is ideal for 3D designers, e-commerce operators, and beginners in 3D modeling to quickly generate standardized multi-angle views.
n8n$9.99
Related categories
Custom AI Systems & Services
Our team of experienced AI builders will help build custom AI systems, workflows, and solutions.
Request Custom Work