Automate YouTube Video Insights with Google Sheets
detail.loadingPreview
Effortlessly capture and store key statistics for your YouTube videos directly into Google Sheets. This workflow automates the process of gathering crucial data, empowering your content strategy.
About This Workflow
This n8n workflow is designed to streamline the collection of vital YouTube video statistics, making them readily available for analysis in Google Sheets. By connecting to your YouTube data, it can extract information such as view counts, like counts, comment counts, duration, publication date, and more. The workflow is triggered manually, allowing you to test its functionality before full deployment. It then intelligently checks for a successful response from the YouTube API before proceeding to update your Google Sheet with the fetched data. This ensures that only accurate and complete information is added, providing a reliable dataset for tracking your video performance and making informed content decisions.
Key Features
- Automated Data Collection: Seamlessly pull video statistics directly from YouTube.
- Google Sheets Integration: Store and organize your video data in a familiar spreadsheet format.
- Comprehensive Statistics: Capture key metrics like views, likes, comments, duration, and more.
- Data Transformation: Automatically format data like video duration for easier readability.
- Error Checking: Ensures that only successful API responses update your sheet.
How To Use
- Trigger the Workflow: Click the 'Test workflow' button on the manual trigger node.
- Configure YouTube Node (Implicit): Ensure your YouTube node is correctly authenticated and configured to fetch data for your desired videos (This snippet assumes a preceding YouTube node is present).
- Set Up Conditional Logic: Adjust the
If - Check Success Responsenode's conditions if your API calls return different success indicators. - Configure Google Sheets Node:
a. Connect your Google Account: Authenticate with your Google account in the Google Sheets node.
b. Select Spreadsheet and Sheet: Specify the target spreadsheet and worksheet.
c. Map Data Fields: Carefully map the output fields from the YouTube API (e.g.,
$json.items[0].statistics.viewCount) to the corresponding columns in your Google Sheet. The provided snippet shows detailed mapping for title, description, tags, duration, counts, and publication dates. d. Define Matching Columns: Set therow_numberas the matching column to ensure updates are applied to the correct rows. - Run and Verify: Execute the workflow and check your Google Sheet to confirm that the video statistics have been successfully updated.
Apps Used
Workflow JSON
{
"id": "a666df74-cb91-4d79-96fb-3a46b08a6cca",
"name": "Automate YouTube Video Insights with Google Sheets",
"nodes": 8,
"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: a666df74-cb91...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
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.