AutomationMart
Home/Browse/Collect YouTube channel stats & contact info with Google Sheets and SerpAPI
n8n

Collect YouTube channel stats & contact info with Google Sheets and SerpAPI

n8nn8n9 modulesv1.0
Google SheetsLinkedIn

Workflow Overview This advanced n8n automation is a powerful channel research and intelligence gathering tool designed to transform raw YouTube channel data into actionable insights. By intelligently connecting multiple APIs and data sources, this workflow: 1. Discovers Channel Metrics: - Automatically retrieves channel statistics - Captures detailed performance indicators - Provides comprehensive channel intelligence 2. Performs Deep Analysis: - Extracts recent video performance data - Ca

At a glance

Collect YouTube channel stats & contact info with Google Sheets and SerpAPI is a ready-made n8n workflow you import as a workflow JSON file β€” no build required. It connects Google Sheets, LinkedIn. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, LinkedIn
Modules
9
Price
Free
Version
v1.0
Collect YouTube channel stats & contact info with Google Sheets and SerpAPI workflow diagram

About this workflow

Workflow Overview This advanced n8n automation is a powerful channel research and intelligence gathering tool designed to transform raw YouTube channel data into actionable insights. By intelligently connecting multiple APIs and data sources, this workflow: 1. Discovers Channel Metrics: - Automatically retrieves channel statistics - Captures detailed performance indicators - Provides comprehensive channel intelligence 2. Performs Deep Analysis: - Extracts recent video performance data - Calculates engagement metrics - Aggregates view count insights 3. Uncovers Contact Information: - Attempts to retrieve public email addresses - Provides direct outreach opportunities - Enhances lead generation capabilities 4. Seamless Data Logging: - Automatically updates Google Sheets - Maintains a live intelligence dashboard - Preserves historical channel data Key Benefits - πŸ€– Full Automation: Continuous channel intelligence gathering - πŸ’‘ Smart Analysis: Comprehensive performance insights - πŸ“Š Real-Time Tracking: Always-updated channel metrics - πŸ” Lead Generation: Direct contact information extraction Workflow Architecture πŸ”Ή Stage 1: Channel Identification - Google Sheets Trigger: Detects new channel additions - YouTube Data API: Fetches channel statistics - Comprehensive Metric Collection: - Subscriber count - Total view metrics - Channel overview πŸ”Ή Stage 2: Video Performance Analysis - Recent Video Retrieval: Fetches 5 latest uploads - View Count Aggregation: - Calculates total recent views - Provides engagement snapshot - Performance Insights: Measures content effectiveness πŸ”Ή Stage 3: Contact Discovery - SerpAPI Integration: Attempts email extraction - Public Contact Information: - Retrieves available email addresses - Supports outreach and networking πŸ”Ή Stage 4: Data Compilation - Intelligent Data Formatting - Google Sheets Update - Live Intelligence Dashboard Potential Use Cases - Marketing Teams: Influencer research - Sales Professionals: Lead qualification - Content Strategists: Competitive analysis - Recruitment Specialists: Talent scouting - Business Development: Partnership identification Setup Requirements 1. YouTube Data API - Google Cloud API credentials - Configured API access 2. SerpAPI Account - API key for email extraction - Web scraping permissions 3. Google Sheets - Connected Google account - Prepared tracking spreadsheet - Appropriate sharing settings 4. n8n Installation - Cloud or self-hosted instance - Workflow configuration - API credential management Future Enhancement Suggestions - πŸ€– AI-powered channel scoring - πŸ“Š Advanced trend analysis - πŸ”” Automated alert system - 🌐 Multi-platform channel tracking - 🧠 Machine learning insights generation Technical Considerations - Implement robust error handling - Use exponential backoff for API calls - Maintain flexible data extraction strategies - Ensure compliance with platform terms of service Ethical Guidelines - Respect content creator privacy - Use data for legitimate research - Maintain transparent data collection practices - Provide opt-out mechanisms Connect With Me Ready to unlock YouTube channel insights? πŸ“§ Email: Yaron@nofluff.online πŸŽ₯ YouTube: @YaronBeen πŸ’Ό LinkedIn: Yaron Been Transform your channel research with intelligent, automated workflows!

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n β†’ click the menu β†’ Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Update Google Sheets rows based on ChatGPT Assistant responses

Automatically update Google Sheets rows with AI-generated insights. Triggered by new data, ChatGPT Assistant processes messages and your spreadsheet updates efficiently.

Free

WooCommerce AI post-sales chatbot with GPT-4o, RAG, Google Drive and Telegram

This WooCommerce-integrated chatbot is designed to transform post-sales customer support by combining automation and artificial intelligence to deliver fast, secure, and personalized assistance. The chatbot retrieves real-time order information, including shipping details and tracking numbers, after verifying the customer's identity through a strict email-based authentication system. Beyond order management, the chatbot answers frequently asked questions about return policies, delivery times, a

Free

Add new Google Sheets rows for every LinkedIn lead gen form response

Automatically add new LinkedIn lead gen form responses to Google Sheets. Streamline data collection by syncing LinkedIn leads with Google Sheets rows.

Free

Scan your books with Android barcodes and save them in a Google Sheet spreadsheet

Every time a book's barcode is scanned via the Make Android app, Make will automatically search for the book's metadata and save it to the Google Sheets spreadsheet of your choice. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1UoE4k1jJpqRFNjUVMbwkJBUpsoUkzaaQ4RNMKlOsoac/edit?usp=sharing).

Free

Automated HR screening with VAPI AI calls, Gemini analysis & Google Sheets

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This n8n template automates candidate outreach, call transcription, and structured feedback capture for HR teams and recruiters. It triggers on a new candidate row added in a Google Sheet, initiates a call using Vapi.ai, processes the transcript using Google Gemini, extracts key information like CTC, experience, and notice period, and then updates the same Google Sheet with parsed insights. This

Free

Track marketing channel performance with HighLevel, Google Sheets, and Slack

Description: Discover which marketing channels actually convert with this n8n automation template. The workflow fetches all opportunities from HighLevel (GHL), filters for β€œClosed Won” deals, computes lead-to-sale conversion metrics per source, and sends a summary report to Slack while logging raw data into Google Sheets for ongoing analysis. Perfect for marketing teams, growth analysts, and sales managers who want to reduce wasted ad spend and double down on sources that deliver real ROI.

Free

Build a PDF-based RAG system with OpenAI, Pinecone and Cohere reranking

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow provides a complete, ready-to-use template for a Retrieval-Augmented Generation (RAG) system. It allows you to build a powerful AI chatbot that can answer questions based on the content of PDF documents you provide, using a modern and powerful stack for optimal performance. Good to know Costs: This workflow uses paid services (OpenAI, Pinecone, Cohere). Costs will

Free

Create and publish AI avatar short videos with Gemini, HeyGen and Google Sheets

Automated AI Video Avatar Workflow for Shorts using n8n & HeyGen Automatically generate AI avatar short videos and publish them to social platforms using n8n and HeyGen. This workflow turns viral ideas or prepared scripts into fully rendered AI avatar videos and handles publishing and tracking without manual editing. --- Who is this for? This template is ideal for: - Content creators producing Shorts, Reels, or TikTok videos at scale - Marketers using AI avatars for faceless or branded content

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint β€” instant download
  • Setup guide PDF included
  • 5 downloads Β· valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

β‚Ή2,499/ session
3 hrs Β· video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free