Automated YouTube Video Data Fetcher for Google Sheets

This n8n workflow automates the process of collecting key statistics from YouTube videos and updating a Google Sheet with the fetched data. It begins when manually triggered or scheduled, reading a list of YouTube URLs from a designated Google Sheet tab. The workflow then extracts the video ID from each URL and sends a request to the YouTube Data API to retrieve metrics such as view count, like count, comment count, title, description, and more. Based on the API response, the workflow updates the respective row in Google Sheets—marking success as ‘Finished’ with populated data or errors accordingly. This setup is highly valuable for content creators, digital marketers, or data analysts who need to monitor multiple YouTube videos’ performance efficiently without manual data collection.