Extract YouTube Video Stats & Save to Google Sheets

This n8n workflow streamlines the process of gathering key statistics from YouTube videos and storing them directly in Google Sheets. It reads a list of video URLs from a designated sheet, processes only those marked as 'Ready', extracts video IDs, queries the YouTube API for data including title, view count, like count, comment count, and more, then updates the corresponding rows with the results—marking them 'Finished' on success or 'Error' on failure.

The workflow features robust error handling and batch processing capabilities, making it ideal for handling multiple videos in one run. Triggered manually via 'Execute Workflow' or 'Test Workflow' in n8n, it loops efficiently through rows without overwhelming API limits.

Perfect for YouTubers, content strategists, growth marketers, and automation engineers, it saves hours of manual data collection. Use cases include competitive analysis, performance tracking, content audits, and integrating video insights into reporting dashboards. Benefits include structured data export, real-time updates, and scalability for large video libraries.

Setup is straightforward: Import the workflow into n8n, duplicate the provided Google Sheet template, configure Google Cloud credentials for Sheets and YouTube API access, and connect nodes to the correct sheet tab. No coding required beyond credential setup.