Data & Analytics Workflows
Data processing and analytics
Enhance SQL Queries with AI-Driven Visualization Using OpenAI and Quickchart.io
This workflow enhances SQL queries by integrating AI-driven visualization capabilities. It uses OpenAI to interpret SQL queries and Quickchart.io to generate dynamic charts, facilitating better data analysis and visualization.
n8n$14.99Automate 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.
n8n$4.99Automate 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.
n8n$9.99Automate 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.
n8n$19.99Export PostgreSQL Table Data to CSV Format
Effortlessly convert data from a PostgreSQL table into a CSV file for easy data sharing and analysis.
n8n$4.99Automate 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.
n8n$14.99Automate n8n Creators Leaderboard Analysis and Reporting
This workflow automates the retrieval, processing, and reporting of n8n community statistics, highlighting popular workflows and top contributors.
n8n$19.99YouTube 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
n8n$14.99Convert JSON Data to Google Sheets Entries
This workflow reads JSON data from a file and appends it to a Google Sheets document, enabling seamless data transfer and storage.
n8n$3.99Validate 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)
n8n$14.99Automate Trending Video Detection on YouTube Using Competitor Analysis
This n8n workflow identifies trending YouTube videos by analyzing competitor channels for outliers that significantly outperform average views. It streamlines content research by automating data collection and analysis.
n8n$14.99Automate NocoDB Record Linking via API
This workflow automates the process of linking records in NocoDB using API requests, streamlining data management across tables.
n8n$9.99Automate 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.
n8n$14.99Automate 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.
n8n$4.99Create a Google Analytics Data Report with AI and Send It to Email and Telegram
## What this workflow does This workflow retrieves Google Analytics data from the last 7 days and the same period in the previous year. The data is then prepared by AI as a table, analyzed, and provided with a small summary. The summary is then sent by email to a desired address and, shortened and summarized again, sent to a Telegram account. This workflow has the following sequence: 1. Time trigger (e.g., every Monday at 7 a.m.) 2. Retrieval of Google Analytics data from the last 7 days 3. Assignment and summary of the data 4. Retrieval of Google Analytics data from the last 7 days of the previous year 5. Allocation and summary of the data 6. Preparation in tabular form and brief analysis by AI. 7. Sending the report as an email 8. Preparation in short form by AI for Telegram (optional) 9. Sending as a Telegram message. ## Requirements The following accesses are required for the workflow: - Google Analytics (via Google Analytics API): [Documentation](https://docs.n8n.io/integrations/builtin/credentials/google/) - AI API access (e.g., via OpenAI, Anthropic, Google, or Ollama) - SMTP access data (for sending the mail) - Telegram access data (optional for sending as a Telegram message): [Documentation](https://docs.n8n.io/integrations/builtin/credentials/telegram/) Feel free to [contact me via LinkedIn](https://www.linkedin.com/in/friedemann-schuetz), if you have any questions!
n8n$9.99Automate Domain Traffic Enrichment with SimilarWeb and Google Sheets
Automatically enhance your domain list in Google Sheets with traffic analytics from SimilarWeb, and optionally export the enriched data to Airtable for further analysis.
n8n$9.99Automate LinkedIn Data Extraction and Personalized Messaging with PhantomBuster and GPT-4
This n8n workflow automates LinkedIn profile data extraction and transforms it into structured outputs using PhantomBuster and GPT-4, ideal for lead generation, recruiting, and marketing.
n8n$14.99Extract Business Email Addresses Using SerpApi and ScrapingBee from Google Sheets
# Lead Enrichment & Email Discovery from Google Sheets ## What this workflow does This template automates the enrichment of business leads from a Google Sheet by: * Triggering when a row is activated * Searching for company information with Serper.dev * Generating and validating potential contact pages * Scraping company pages with ScrapingBee * Extracting emails and updating the sheet * Marking rows as finished --- ## Prerequisites * Google Sheet with columns: `business type`, `city`, `state`, `activate` * **Copy the ready-to-use template:** [Sheet Template](https://docs.google.com/spreadsheets/d/1222vBxE2UBb1MK2xDMoQSd5WHQ7mA5Ew-W6vBgfCJs/edit?usp=sharing) * Google Sheets API credentials (from Google Cloud) * Serper.dev API key (free tier available) * ScrapingBee API key (free tier available) --- ## Inputs * **Google Sheet row:** Must include `business type`, `city`, `state`, `activate` * **Set Information Node:** `country`, `country_code`, `language`, `result_count` (can also be provided via columns in the sheet) --- ## Outputs * **Google Sheet update:** Company names, URLs, found email addresses (comma-separated if multiple), and status updates (`Running`, `Missing information`, `Finished`) --- ## Configuration Required * Connect Google Sheets node with your Google Cloud credentials * Add your Serper.dev API key to the HTTP Request node * Add your ScrapingBee API key to the scraping node * Adjust search and filtering options as needed --- ## How to customize the workflow * **Send `country`, `country_code`, and `result_count` from the sheet:** Add these as columns in your sheet and update the workflow to read their values dynamically, making your search fully configurable per row. * **Add more blacklist terms:** Update the code node with additional company names or keywords you want to exclude from the search results. * **Extract more contact details:** Modify the email extraction code to find other contact info (like phone numbers or social profiles) if needed.
n8n$14.99Automate Monthly Trend Tracking with Bright Data and n8n
This workflow automates the tracking of viral trends on Quora by scraping data with Bright Data and storing insights in Google Sheets. Ideal for content creators and marketers to stay updated with emerging trends.
n8n$9.99Automate GitHub Trending Data Collection to Supabase
Streamline the process of collecting and storing GitHub trending repository data in Supabase for easy access and analysis.
n8n$9.99Automate 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.
n8n$9.99Multi-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       ## 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
n8n$24.99Integrate Any API with n8n Using HTTP Requests
Leverage n8n's HTTP Request node to connect with APIs not natively supported, enabling data retrieval and processing from various services.
n8n$9.99Automate 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.
n8n$14.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