Sync Youtube Video Urls with Google Sheets

Syncs YouTube video URLs with Google Sheets, automating the retrieval of video links from specified channels and updating them in a designated spreadsheet. This workflow enhances efficiency by eliminating manual data entry, ensuring your video database is always current and accessible.

7/4/2025
8 nodes
Medium
manualmediumsplitoutgooglesheetssticky noteapiintegration
Categories:
Data Processing & AnalysisManual TriggeredMedium Workflow
Integrations:
SplitOutGoogleSheetsSticky Note

Target Audience

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.

Problem Solved

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.

Workflow Steps

  • 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).

    • Customization Guide

    Users can customize this workflow by:
    - Modifying the Google Sheets: Change the sheet names or document IDs in the workflow to point to different Google Sheets as needed.
    - Adjusting YouTube API Parameters: Customize the API request parameters (like maxResults or order) to alter the data fetched from YouTube according to specific requirements.
    - Editing Formatting Steps: Adjust the fields being formatted in the 'Format fields as required to save in google sheet' step to include additional data or change the structure of the output.
    - Adding More Nodes: Users can extend the workflow by adding more nodes for additional processing or integration with other applications.