Sync YouTube Videos with Google Sheets

This workflow is the first part of a multi-part automation system designed to perform large-scale YouTube comment sentiment analysis along with a 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.

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.

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 organizing video data.