Extract YouTube Channel Videos to Google Sheets with Metadata

This n8n workflow extracts a list of public videos from any YouTube channel, capturing key metadata like video URLs, titles, descriptions, thumbnail links, publish dates, and more, then saves it cleanly into a Google Sheets 'Videos' tab. It starts by reading channel URLs, custom URLs, or IDs from the 'Channel URLs' tab in the connected Google Sheet, processing only those marked as 'Ready'. A Switch node routes inputs: raw channel IDs go directly to the YouTube API, while full or custom URLs trigger an HTTP request to fetch the corresponding channel ID first.

Once the channel ID is obtained, the workflow queries the YouTube API (limited to 10 videos per channel by default) and validates the response. Successful data is split into individual entries, cleaned for consistency, and appended to the Google Sheets. This enables scalable data collection without manual effort, ideal for ongoing monitoring.

Benefits include time savings for content strategists tracking competitors, marketing teams building video dashboards, researchers gathering structured data, and automation pros integrating YouTube into larger pipelines. It's enterprise-ready with error handling, status tracking, and easy customization for more videos or additional fields.