Data & Analytics Automation Workflows — Page 4 | Neura Market

Neura Market/Categories

Home/Categories/Data & Analytics

Data & Analytics Workflows

Data processing and analytics

Automate MySQL to Google Sheets Data Sync with Duplicate Prevention
This n8n workflow automates the synchronization of new records from a MySQL database to a Google Sheet every 15 minutes, ensuring no duplicates are transferred.
n8nFree
Automate Facebook Group Post Extraction to Airtop
Efficiently extract and analyze non-sponsored posts from Facebook Groups using Airtop, providing valuable insights for community managers and marketers.
n8nFree
Automate Trustpilot Review Scraping and Sentiment Analysis with DeepSeek and OpenAI
This workflow automates the extraction of Trustpilot reviews, performs sentiment analysis using OpenAI, and saves the results to Google Sheets. It leverages DeepSeek for detailed review data extraction.
n8n

Marketplace

Prompts
Workflows
Agents Store
Workflow Packs
Categories
Marketplace

Directories

AI Tools Directory
ChatGPT
Claude
Gemini
Cursor
Grok
DeepSeek
Perplexity
CoPilot
Midjourney
Stable Diffusion
MCP Servers
.md Directory
All Directories

Free Tools

AI Text Humanizer
AI Content Detector
Workflow Generator
Model Comparison
AI Pricing Calculator
AI Benchmarks
ROI Calculator
All Free Tools

Resources

AI News
Blog
AI Models
Integrations
Alternatives
n8n vs Zapier
Make vs Zapier
n8n vs Make
Resource Library
Documentation

Community

AI Jobs
AI Events
AI Companies
Start Selling
Sell n8n Workflows
Sell AI Agents
Sell Prompts
Creator Guide
Advertise
Affiliates

Company

About
Contact
Help
Careers
Pricing
Terms
Privacy
License
DMCA

Stay Updated

Get the latest AI tools and insights delivered to your inbox.

© 2026 Neura Market. All rights reserved.

Free

YouTube Comment Scraper & Analyzer with GPT-4 + Email Summary Report

## How it Works This workflow automates the collection and analysis of **YouTube comments** from a video and sends a **summary report via email**, using **Google Sheets**, the **YouTube API**, **OpenAI (GPT-4)**, and **Gmail**. Whether you're a content creator, brand manager, or social media analyst, this workflow helps you **automate sentiment analysis** and **receive insights** directly in your inbox - all triggered from a simple spreadsheet. ## Use Case Ideal for: - **YouTubers** monitoring audience sentiment - **Marketing teams** analyzing campaign feedback - **Community managers** summarizing engagement ## Setup Instructions ### 1. Upload the Spreadsheet - File name: `Youtube_Video` - Sheet structure: | ID | Video Title | YouTube Video ID | Status | - Add video IDs and set their `Status` as `Pending` ### 2. Configure Google Sheets Nodes Connect your **Google account** to: - `Pick Video IDs from Google Sheet` - `Update Status on Google Sheet` ### 3. Add API Credentials - **YouTube API Key** – for comment + video scraping nodes - **OpenAI API Key** – for analyzing comments - **Gmail Account** – for sending the summary email ### 4. Activate the Workflow Once live, the workflow will: 1. Watch for new or updated rows in the spreadsheet 2. Scrape comments using the YouTube API 3. Analyze sentiment and key themes via GPT-4 4. Send a formatted HTML email with the summary 5. Update the spreadsheet status to `Mail sent` ## Workflow Logic 1. **Trigger**: New/updated row in Google Sheet 2. **Retrieve**: YouTube video metadata + comments 3. **Analyze**: Comments using GPT-4 4. **Email**: Summary report via Gmail 5. **Update**: Spreadsheet status to `Mail sent` ## Node Descriptions | Node Name | Description | |-----------|-------------| | Pick Video IDs from Google Sheet | Watches the spreadsheet and retrieves pending video IDs | | If | Checks whether status is Pending | | Limit | Restricts the number of processed rows | | Set Video Details | Prepares video info (e.g., title, channel) | | Get YouTube Video Details | Fetches metadata (title, channel, etc.) | | Get YouTube Video Comments | Pulls top-level comments using YouTube API | | Prepare Comments Data | Formats comment text for OpenAI | | AI Agent | Summarizes comments using OpenAI's GPT-4 | | Prepare HTML for Email | Converts summary into HTML for email body | | Gmail Account Configuration | Sends the email report via Gmail | | Update Status on Google Sheet | Marks the row as Mail sent | ## Customization Tips - Change the AI prompt for tone, length, or custom metrics - Send results to Slack or Telegram instead of Gmail - Export summaries to Notion, Airtable, or PDF - Schedule it daily/weekly for recurring analysis ## Suggested Sticky Notes for Workflow | Node/Section | Sticky Note Content | |--------------|---------------------| | Pick Video IDs from Google Sheet | Triggers on new YouTube videos in your spreadsheet | | AI Agent | Uses OpenAI to generate an analysis summary - customize prompt as needed | | Gmail | Sends summary report - you can update subject, recipients, or style | | Update Status | Marks video as processed to avoid duplicate runs | ## Required Files | File Name | Purpose | |-----------|---------| | Youtube_Video | Google Sheet to hold YouTube video IDs and status | | Youtube_Comment_Scraper.json | Main n8n workflow export for this automation | ## Testing Tips - Add one test video with a valid YouTube video ID and status = `Pending` - Monitor the workflow logs to confirm API responses - Confirm summary delivery in your inbox - Verify that status updates in the sheet ## Suggested Tags & Categories - #YouTube - #OpenAI - #Automation - #Marketing - #Email - #Analytics

Automate Daily Postgres Table Backups to GitHub as CSV Files

This workflow automates the daily backup of all public Postgres tables to a GitHub repository in CSV format, ensuring your data is consistently up-to-date and version-controlled.

Automate Job Listing Analysis from Indeed with Bright Data and LLMs

This workflow automates the process of scraping job listings from Indeed using Bright Data and analyzes them with LLMs to determine suitability based on your criteria.

Automate GitHub Trending Data Collection to Supabase

Streamline the process of collecting and storing GitHub trending repository data in Supabase for easy access and analysis.

Automate YouTube Channel Video Extraction to Google Sheets

This n8n workflow automates the extraction of video metadata from YouTube channels and saves it to Google Sheets. Ideal for content strategists, marketers, and researchers who need structured video data.

Automate Y Combinator Startup Data Collection with Apify and Google Sheets

Streamline the process of collecting and organizing startup data from Y Combinator into Google Sheets using Apify. Ideal for sales teams, investors, and researchers.

Enrich LinkedIn Profiles from Google Sheets via RapidAPI

### LinkedIn Profile Enrichment Workflow #### Who is this for? This workflow is ideal for recruiters, sales professionals, and marketing teams who need to enrich LinkedIn profiles with additional data for lead generation, talent sourcing, or market research. #### What problem is this workflow solving? Manually gathering detailed LinkedIn profile information can be time-consuming and prone to errors. This workflow automates the process of enriching profile data from LinkedIn, saving time and ensuring accuracy. #### What this workflow does 1. **Input**: Reads LinkedIn profile URLs from a Google Sheet. 2. **Validation**: Filters out already enriched profiles to avoid redundant processing. 3. **Data Enrichment**: Uses RapidAPI's Fresh LinkedIn Profile Data API to retrieve detailed profile information. 4. **Output**: Updates the Google Sheet with enriched profile data, appending new information efficiently. #### Setup 1. **Google Sheet**: Create a sheet with a column named `linkedin_url` and populate it with the profile URLs to enrich. 2. **RapidAPI Account**: Sign up at [RapidAPI](https://rapidapi.com) and subscribe to the Fresh LinkedIn Profile Data API. 3. **API Integration**: Replace the `x-rapidapi-key` and `x-rapidapi-host` values with your credentials from RapidAPI. 4. **Run the Workflow**: Trigger the workflow and monitor the updates to your Google Sheet. #### How to customize this workflow * **Filter Criteria**: Modify the filter step to include additional conditions for processing profiles. * **API Configuration**: Adjust API parameters to retrieve specific fields or extend usage. * **Output Format**: Customize how the enriched data is appended to the Google Sheet (e.g., format, column mappings). * **Error Handling**: Add steps to handle API rate limits or missing data for smoother automation. This workflow streamlines LinkedIn profile enrichment, making it faster and more effective for data-driven decision-making.

Automate Comprehensive Google Analytics Reports with n8n

This n8n workflow automates the collection, processing, and formatting of Google Analytics data into a detailed HTML report. It segments data into Engagement Stats, Search Results, and Country Views, offering insights for better decision-making.

Automate Gmail Metadata Extraction to Google Sheets

Automatically extract and store metadata from new Gmail emails into Google Sheets for efficient record-keeping and workflow automation.

Automate n8n Creators Leaderboard Analysis and Reporting

This workflow automates the retrieval, processing, and reporting of n8n community statistics, highlighting popular workflows and top contributors.

Automate Zillow Property Data Collection with Bright Data and Google Sheets

This workflow automates the extraction of Zillow property listings based on location and category using the Bright Data API, and stores the data in Google Sheets for easy access and analysis.

Multi-Platform Source Discovery with SerpAPI, DuckDuckGo, GitHub, Reddit, & Bluesky

# Source Discovery - Automatically Search More Up-to-Date Information Sources ## Overview **Version**: 1.0 This workflow utilizes various nodes to discover and analyze potential sources of information from platforms like Google, Reddit, GitHub, Bluesky, and others. It is designed to streamline the process of finding relevant sources based on specified search themes. ## Features - Automated source discovery from multiple platforms. - Filtering of existing and undesired sources. - Error handling for API requests. - User-friendly configuration options. ## Who is this for? This workflow is ideal for researchers, content marketers, journalists, and anyone looking to efficiently gather and analyze information from various online sources. ## What problem does this solve? This workflow addresses the challenge of manually searching for relevant information sources, saving time and effort while ensuring that users have access to the most pertinent content. Ideal use-cases include: - Resource Compilation for Academic and Educational Purposes - Journalism and Research - Content Marketing - Competitor Analysis ## What this workflow does The workflow gathers data from selected platforms through search terms. It filters out known and undesired sources, analyzes the content, and provides insights into potential sources relevant to the user's needs. ## Workflow Steps ### 1. Search Queries - Fetch sources using SerpAPI search, DuckDuckGo, and Bluesky. - Utilizes GitHub repositories to find relevant links. - Leverages RSS feeds from subreddits to identify potential sources. ### 2. Filtering Step - Removes existing and undesired sources from the results. ### 3. Source Selection - Analyzes the content of the identified sources for relevance. ## Expected Input / Configuration The workflow is primarily configured via the **Configure Workflow Args (Manual)** node or the **Global Variables** custom node. - Search themes: Keywords or phrases relevant to the desired content. - Lists of known sources and undesired sources for filtering. ## Expected Output A curated list of potential sources relevant to the specified search themes, along with insights into their content. ## Example ![printscreen1.png](fileId:1965) ![printscreen2.png](fileId:1964) ![printscreen3.png](fileId:1961) ![printscreen4.png](fileId:1962) ![printscreen5.png](fileId:1963) ![printscreen6.png](fileId:1966) ## n8n Setup Used - **n8n version:** 1.105.3 - **n8n-nodes-serpapi:** 0.1.6 - **n8n-nodes-globals:** 1.1.0 - **n8n-nodes-bluesky-enhanced**: 1.6.0 - **n8n-nodes-duckduckgo-search**: 30.0.4 - **LLM Model:** mistral-small-latest (API) - **Platform:** Podman 4.3.1 on Linux - **Date:** 2025-08-06 ## Requirements to Use / Setup - Self-hosted or cloud n8n instance. - Install the following custom nodes: SerpAPI, Bluesky, and DuckDuckGo Search. - [n8n-nodes-serpapi](https://github.com/serpapi/n8n-nodes-serpapi) - [n8n-nodes-duckduckgo-search](https://github.com/samnodehi/n8n-nodes-duckduckgo) - [n8n-nodes-bluesky-enhanced](https://github.com/brianmoney/n8n-nodes-bluesky) - Install the Global Variables Node for enhanced configuration: - [n8n-nodes-globals](https://github.com/umanamente/n8n-nodes-globals) (or use Edit Field (Set) node instead) - Provide valid credentials to nodes for your preferred LLM model, SerpAPI, and Bluesky. Credentials for GitHub recommended. ## Notes, Assumptions & Warnings - Ensure compliance with the terms of service of any platforms accessed or discovered in this workflow, particularly concerning data usage and attribution. - Monitor API usage to avoid hitting rate limits. - The workflow may encounter errors such as 403 responses; in such cases, it will continue by ignoring the affected substep. - Duplicate removal is applied, but occasional overlaps might still appear depending on the sources. - This workflow assumes familiarity with n8n, APIs, and search engines. - Using AI agents (Mistral or substitute LLMs) requires access to their API services and keys. - This is not a Curator of News. It is designed to find websites that are relevant and useful to your searches. If you are looking for a relevant news selector, please check this [workflow](https://n8n.io/workflows/6157-multi-source-news-curator-with-mistral-ai-analysis-summaries-and-custom-channels/). ## About Us This workflow was developed by the Hybroht team. Our goal is to create tools that harness the possibilities of technology and more. We aim to continuously improve and expand functionalities based on community feedback and evolving use cases. For questions, reach out via [contact@hybroht.com](mailto:contact@hybroht.com). ### Warranty & Legal Notice This free workflow is provided as-is without any warranties of any kind, either express or implied, including but not limited to the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. By using

Automate Twitter Profile Data Scraping and Google Sheets Integration

This n8n workflow automates the process of scraping Twitter profile data using the Bright Data API and stores the results in Google Sheets. Ideal for social media analytics, brand monitoring, and competitor research.

Automate YouTube Transcript Extraction and Cleaning with RapidAPI

This n8n workflow automates the extraction and cleaning of YouTube video transcripts using the YouTube Transcript API on RapidAPI, providing structured and readable transcript data for further use.

Validate CAD and BIM Files Against Excel Standards (Revit, IFC, AutoCAD, DGN)

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. ## CAD-BIM Multi-Format Validation Pipeline This workflow enables automated validation of CAD and BIM files in multiple formats (Revit, IFC, DWG, DGN) for compliance with project standards and requirements. ### Key Features - Converts Revit, IFC, DWG, and DGN models into open data tables - Runs automated validation checks on model naming, structure, attributes, and completeness - Generates error reports and QTO (Quantity Take-Off) tables for all processed files ### How it works 1. Upload one or more project files in Revit (.rvt), IFC (.ifc), DWG, or DGN formats 2. The pipeline automatically processes each file and validates against configurable rules in Excel format 3. Error summaries and QTO tables are generated 4. All outputs are available for download as Excel - **Converter Path:** Make sure the converter executable (e.g., `RvtExporter.exe`) is placed in `DDC Exporter\datadrivenlibs\`. Specify the full path in the workflow settings if required. - **Troubleshooting:** - If conversion fails, double-check the path to the executable. - Only supported formats can be processed (see GitHub Readme). - Review logs in `/output` for error details. - **Docs & Issues:** [Full Readme on GitHub](https://github.com/datadrivenconstruction/cad2data-Revit-IFC-DWG-DGN-pipeline-with-conversion-validation-qto) ## Consulting and Training We work with leading construction, engineering, consulting agencies, and technology firms around the world to help them implement open data principles, automate CAD/BIM processing, and build robust ETL pipelines. If you would like to test this solution with your own data, or are interested in adapting the workflow to real project tasks, feel free to contact us. ## Author [DataDrivenConstruction.io](https://DataDrivenConstruction.io) [info@datadrivenconstruction.io](mailto:info@datadrivenconstruction.io) **Docs & Issues:** [Full Readme on GitHub](https://github.com/datadrivenconstruction/cad2data-Revit-IFC-DWG-DGN-pipeline-with-conversion-validation-qto)

Automate NocoDB Record Linking via API

This workflow automates the process of linking records in NocoDB using API requests, streamlining data management across tables.

Automate LinkedIn Profile Analysis with AI and Supabase

Streamline LinkedIn data extraction and enrichment using Bright Data, Google Gemini, and Supabase to generate actionable insights for recruiters and analysts.

Flight Data Visualization with Chart.js, QuickChart API & Telegram Bot

# Real-time Flight Data Analytics Bot with Dynamic Chart Generation via Telegram ## Template Overview This advanced n8n workflow creates an intelligent Telegram bot that transforms raw CSV flight data into stunning, interactive visualizations. Users can generate professional charts on-demand through a conversational interface, making data analytics accessible to anyone via messaging. **Key Innovation**: Combines real-time data processing, Chart.js visualization engine, and Telegram's messaging platform to deliver instant business intelligence insights. ## What This Template Does Transform your flight booking data into actionable insights with four powerful visualization types: - **Bar Charts**: Top 10 busiest airlines by flight volume - **Pie Charts**: Flight duration distribution (Short/Medium/Long-haul) - **Doughnut Charts**: Price range segmentation with average pricing - **Line Charts**: Price trend analysis across flight durations Each chart includes auto-generated insights, percentages, and key business metrics delivered instantly to users' phones. ## Technical Architecture ### Core Components 1. **Telegram Webhook Trigger**: Captures user interactions and button clicks 2. **Smart Routing Engine**: Conditional logic for command detection and chart selection 3. **CSV Data Pipeline**: File reading → parsing → JSON transformation 4. **Chart Generation Engine**: JavaScript-powered data processing with Chart.js 5. **Image Rendering Service**: QuickChart API for high-quality PNG generation 6. **Response Delivery**: Binary image transmission back to Telegram ### Data Flow Architecture ``` User Input → Command Detection → CSV Processing → Data Aggregation → Chart Configuration → Image Generation → Telegram Delivery ``` ## Setup Requirements ### Prerequisites - **n8n instance** (self-hosted or cloud) - **Telegram Bot Token** from @BotFather - **CSV dataset** with flight information - **Internet connectivity** for QuickChart API ### Dataset Source This template uses the **Airlines Flights Data** dataset from GitHub: **Dataset**: [Airlines Flights Data by Rohit Grewal](https://github.com/dataminexcode/n8n-workflow/blob/main/Real-time%20Flight%20Data%20Analytics%20Bot%20with%20Dynamic%20Chart%20Generation%20via%20Telegram/data) ### Required Data Schema Your CSV file should contain these columns: ```csv airline,flight,source_city,departure_time,arrival_time,duration,price,class,destination_city,stops ``` ### File Structure ``` /data/ → flights.csv (download from GitHub dataset above) ``` ## Configuration Steps ### 1. Telegram Bot Setup 1. Create a new bot via @BotFather on Telegram 2. Copy your bot token 3. Configure the Telegram Trigger node with your token 4. Set webhook URL in your n8n instance ### 2. Data Preparation 1. Download the dataset from [Airlines Flights Data](https://github.com/dataminexcode/n8n-workflow/blob/main/Real-time%20Flight%20Data%20Analytics%20Bot%20with%20Dynamic%20Chart%20Generation%20via%20Telegram/data) 2. Upload the CSV file to `/data/flights.csv` in your n8n instance 3. Ensure UTF-8 encoding 4. Verify column headers match the dataset schema 5. Test file accessibility from n8n ### 3. Workflow Activation 1. Import the workflow JSON 2. Configure all Telegram nodes with your bot token 3. Test the `/start` command 4. Activate the workflow ## Technical Implementation Details ### Chart Generation Process **Bar Chart Logic**: ```javascript // Aggregate airline counts const airlineCounts = {}; flights.forEach(flight => { const airline = flight.airline || "Unknown"; airlineCounts[airline] = (airlineCounts[airline] || 0) + 1; }); // Generate Chart.js configuration const chartConfig = { type: 'bar', data: { labels, datasets }, options: { responsive: true, plugins: {...} } }; ``` **Dynamic Color Schemes**: - Bar Charts: Professional blue gradient palette - Pie Charts: Duration-based color coding (light to dark blue) - Doughnut Charts: Price-tier specific colors (green to purple) - Line Charts: Trend-focused red gradient with smooth curves ### Performance Optimizations 1. **Efficient Data Processing**: Single-pass aggregations with O(n) complexity 2. **Smart Caching**: QuickChart handles image caching automatically 3. **Minimal Memory Usage**: Stream processing for large datasets 4. **Error Handling**: Graceful fallbacks for missing data fields ### Advanced Features **Auto-Generated Insights**: - Statistical calculations (percentages, averages, totals) - Trend analysis and pattern detection - Business intelligence summaries - Contextual recommendations **User Experience Enhancements**: - Reply keyboards for easy navigation - Visual progress indicators - Error recovery mechanisms - Mobile-optimized chart dimensions (800x600px) ## Use Cases & Business Applications ### Airlines & Travel Companies - **Fleet Analysis**: Monitor airline performance and market share - **Pricing Strategy**: Analyze competitor pricing across

Automate Company Data Enrichment from ZoomInfo to Google Sheets

This workflow enriches company domain lists with detailed business information from ZoomInfo, organizing the data in Google Sheets for sales and research purposes.

Automate Daily Web Data Extraction and Telegram Alerts

Automatically extract structured data from websites daily using Firecrawl and receive alerts via Telegram. Ideal for compliance monitoring and market intelligence.

Automate YouTube Trend Analysis and Data Collection in Google Sheets

Effortlessly track trending YouTube videos in your niche and compile essential data into Google Sheets for comprehensive analysis. Perfect for content creators and marketers.

← PreviousPage 4 of 42Next →

Related categories

Communication (2,463)AI (1,929)Business Operations & ERPs (1,540)Other (1,425)Productivity (1,202)Marketing (1,145)File & Document Management (802)CRM - Sales (604)Notifications (580)Social Media (562)

Need a custom data & analytics workflow?

Our automation experts build tailored workflows for your exact stack and process.

Request a Custom Workflow