This n8n workflow automates the process of retrieving and storing video details from multiple YouTube channels into Google Sheets. The main goal is to streamline the collection of video metadata such as titles, URLs, thumbnails, descriptions, and publish dates for analysis or content management.
The workflow triggers manually or via a scheduled trigger, then fetches a list of YouTube channel URLs or IDs from a Google Sheet where only ‘Ready’ statuses are processed. It detects whether each input is a full URL or an ID, extracting or converting as necessary using regular expressions and YouTube API requests. Once the channel ID is obtained, the workflow requests the latest videos—defaulting to 10 per channel—and processes the API response.
If successful, each video’s data is appended to a designated Google Sheet tab for videos, and the processing status in the ‘Channel URLs’ tab is marked as ‘Finished.’ If an error occurs, the status is marked as ‘Error’ for review. Additional notes in the workflow guide users on setup, customization, and use cases, making it suitable for content creators, marketers, and data analysts who wish to automate YouTube data collection.
Reviews
There are no reviews yet.