Sync Youtube Video URLs with Google Sheets

Description

Sync Youtube Videos with Google Sheets
(Part 1 of Youtube comments sentiment analyze automation along with detailed dashboard)

This workflow is the first part of a multi-part automation system designed to perform large-scale YouTube comment sentiment analysis alongwith detailed dashboard. It solves the problem of manually tracking new videos across multiple YouTube channels by automatically fetching and organizing video URLs in a Google Sheet, setting the stage for deeper analysis in Part 2.

What It Does
Reads Channel IDs from Sheet3 of a connected Google Sheet.
Fetches the latest videos from each Channel ID using the YouTube Data API.
Extracts video URLs and metadata (like title and publish date).
Appends the video data to Sheet2 of the same Google Sheet — this sheet is later used by Part 2 for further processing.

Part of a Multi-Step System
This is Part 1 of a 2-workflow system:
Part 1 (this workflow)** populates a sheet with the latest videos from a list of channels.
Part 2* reads the video URLs from Sheet2, fetches comments for each video, analyzes their sentiment using *OpenAI**, and stores structured results in Sheet1.

👉 Continue to Part 2 – YouTube Comment Sentiment Analyzer with Google Sheets & OpenAI

✅ Use Cases
Monitor and organize new videos from a list of YouTube channels
Automate content pipelines for social media teams and analysts
Build scalable datasets for comment and sentiment analysis
Perfect for creators, agencies, or data analysts managing multiple YouTube accounts

🔧 Apps Used
Google Sheets** – To read and write channel/video data
YouTube** – To fetch video data from public channels

💡 Why Use This?
Manually checking YouTube channels for new content is time-consuming and error-prone. This automation ensures your data stays current and structured — enabling consistent tracking and deeper analysis (especially when paired with Part 2). It brings speed, scale, and automation to your YouTube content operations.

How to Customize

1. Modify Trigger Settings
Change the Google Sheet (Sheet 3) channel ID entry to track other channels.
Use a time-based trigger to fetch new videos regularly, ensuring your data stays up to date.

2. Adjust Output Fields
Fetch additional details from YouTube, such as view count, description, or thumbnails.
Add custom columns in Sheet 2 for organizing videos by different criteria, such as:
"Published Date"
"Video Type"
"View Count"
"Video Description"

3. Extend with Integrations
Integrate with other workflows like YouTube Comment Sentiment Analysis (Part 2) for a deeper dive into content analysis.
Use filters to fetch videos by certain tags, keywords, or publish dates.

4. Adjust Sheet Structure
Modify the structure of Sheet 2 to categorize videos based on criteria like:
Channel
Video Status (e.g., "Published," "Scheduled")
Video Type (e.g., "Tutorial," "Review")

5. Schedule Regular Fetching
Set a schedule trigger to fetch videos at regular intervals (e.g., daily or weekly), ensuring new content is automatically added to your sheet.

6. Customize Google Sheet Layout
Change the layout of Sheet 2 to better fit your needs. For example, you can add additional columns for