This n8n workflow automates the process of retrieving detailed information from YouTube channels and storing it in Google Sheets. It starts with manually triggering the process or integrating with a scheduled trigger. The workflow reads a list of YouTube channel URLs or custom handles from a Google Sheet, then loop through each entry. For every URL marked as ‘Ready’, it detects whether the URL is a full channel link or a custom handle.
Using conditional logic, it routes the request to the appropriate YouTube API call via HTTP requests, fetching channel data such as title, description, statistics (view count, subscriber count, videos), creation date, country, keywords, thumbnails, and unique channel ID. After receiving the data, it updates the corresponding row in Google Sheets. Success updates the status to ‘Finished’, while failures mark the row as ‘Error’.
This workflow is ideal for digital marketers, content creators, influencer analysts, or agencies wanting to automate and streamline gathering and updating YouTube channel metrics for competitive analysis, reporting, or growth strategy planning.
Reviews
There are no reviews yet.