Automate YouTube's Top Videos to Your Spreadsheet
detail.loadingPreview
Effortlessly track the most popular videos from any YouTube channel and automatically populate them into your Google Sheet. Stay ahead of trends and understand what resonates with your audience without manual effort.
About This Workflow
This n8n workflow automates the process of identifying and cataloging the most popular videos from a specific YouTube channel. It begins by reading channel details from a Google Sheet, then leverages the YouTube Data API to fetch videos ordered by view count. The retrieved video data is then meticulously processed and appended to another designated Google Sheet, including the video title, ID, direct link, and channel name. This streamlined solution is perfect for content marketers, researchers, and anyone looking to monitor trending content within a niche or from a competitor.
Key Features
- Automated Video Discovery: Automatically pulls the most-viewed videos from any specified YouTube channel.
- Google Sheets Integration: Seamlessly reads input from and writes output to Google Sheets.
- Customizable Data Capture: Captures essential video details like title, ID, link, and channel name.
- Configurable Inputs: Easily define the YouTube channel ID and the number of videos to fetch.
- Scalable Solution: Designed to run on-demand or on a schedule for continuous monitoring.
How To Use
- Configure Google Sheets Nodes:
- In the 'Read Channel Info from Sheet' node, provide your
YOUR_SPREADSHEET_IDandYOUR_INPUT_SHEET_NAME. - In the 'Append Video Details to Sheet' node, provide your
YOUR_SPREADSHEET_IDandYOUR_OUTPUT_SHEET_NAME.
- In the 'Read Channel Info from Sheet' node, provide your
- Set Up YouTube API Credentials:
- In both 'Fetch Most-Viewed Videos via YouTube API' nodes, replace
YOUR_YOUTUBE_API_KEYwith your actual YouTube Data API key.
- In both 'Fetch Most-Viewed Videos via YouTube API' nodes, replace
- Define Workflow Parameters:
- The workflow expects a JSON input with
ChannelIDandvideo_num_to_get. You can manually trigger the workflow by clicking 'Execute workflow' and providing these values. For example:{"ChannelID": "UC-lHJZR3Gqxm24_Vd_AJ5Yw", "video_num_to_get": 10}. - Note: The
UC-lHJZR3Gqxm24_Vd_AJ5Ywis a placeholder for a YouTube channel ID. Replace it with the actual ID of the channel you want to track.
- The workflow expects a JSON input with
Apps Used
Workflow JSON
{
"id": "8dedd919-692e-4e17-9fe4-9710928e4ca9",
"name": "Automate YouTube's Top Videos to Your Spreadsheet",
"nodes": 14,
"category": "Marketing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 8dedd919-692e...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Related Workflows
Discover more workflows you might like
Automated Multi-Platform Social Media Publisher
Streamline your social media content creation and publishing with this n8n workflow. Simply fill out a web form with your caption, media (image or video), and target platforms, and let n8n automate the posting process across multiple social networks.
WhatsApp AI Assistant: LLaMA 4 & Google Search for Real-Time Insights
Instantly deploy a smart AI assistant on WhatsApp, powered by Groq's lightning-fast LLaMA 4 model. This workflow enables real-time conversations, remembers context, and provides up-to-date answers by integrating live Google Search results.
AI-Powered On-Page SEO Audit & Report Automation
Instantly generate comprehensive on-page SEO technical and content audits for any website URL. This AI-powered workflow automates the entire process, from scraping the page to delivering a detailed report directly to your inbox, empowering you to optimize for better search rankings and user engagement.