Sync Youtube Video Urls with Google Sheets

This workflow is ideal for:

• Content Creators: Individuals or teams producing videos on YouTube who want to keep track of their video URLs efficiently.
• Social Media Managers: Professionals managing multiple YouTube channels needing a streamlined way to gather and organize video links.
• Data Analysts: Users requiring access to video data for analysis or reporting purposes, allowing for easier integration with other data sources.
• Marketers: Those looking to analyze video performance and engagement metrics over time using organized data in Google Sheets.

This workflow addresses the challenge of manually tracking and updating YouTube video URLs from various channels. It automates the process of fetching video links, reducing the time and effort required to maintain an up-to-date record in Google Sheets. Users can easily access video data without the hassle of manual entry or searching through multiple sources.

1. Manual Trigger: The workflow begins when the user manually triggers it by clicking 'Test workflow'.
2. Get YouTube Channel IDs: The workflow retrieves channel IDs from a specified Google Sheet (Sheet3).
3. Fetch Video URLs: For each channel ID, the workflow makes an API request to YouTube to fetch video URLs and details, such as the title and publish date.
4. Split Out: The fetched data is split out to handle multiple video entries separately.
5. Format Data: The workflow formats the necessary fields (Title, video URLs, and published date) for easy insertion into Google Sheets.
6. Insert & Update: Finally, the workflow inserts or updates the video URLs and their details in another Google Sheet (Sheet2).