AutomationMart
Home/Browse/Sync Youtube video URLs with Google Sheets
n8n

Sync Youtube video URLs with Google Sheets

n8nn8n6 modulesv1.0
Google SheetsOpenAI

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. Wha

At a glance

Sync Youtube video URLs with Google Sheets is a ready-made n8n workflow you import as a workflow JSON file โ€” no build required. It connects Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, OpenAI
Modules
6
Price
Free
Version
v1.0
Sync Youtube video URLs with Google Sheets workflow diagram

About this workflow

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 1. Reads Channel IDs from Sheet3 of a connected Google Sheet. 2. Fetches the latest videos from each Channel ID using the YouTube Data API. 3. Extracts video URLs and metadata (like title and publish date). 4. 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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n โ†’ click the menu โ†’ Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Generate monthly financial reports with Gemini AI, SQL, and Outlook

AI-Powered Business Performance Reporting Automation Unlock executive-level insights with ZERO manual work! This n8n template empowers you to automate your entire monthly business performance reporting using dynamic SQL queries, AI-driven analysis, and beautiful HTML dashboards โ€” all delivered directly to your inbox. --- ๐ŸŽฏ What This Automation Does - ๐Ÿ“† Triggers automatically every month (5th of each month) - ๐Ÿงฎ Fetches financial data from SQL (ERPNext or any database) - ๐Ÿ”

Free

AI-Powered Email Campaign using a Name-Email Database

This HARPA AI + MAKE.COM scenario enriches your name-email database and creates personalized outreach emails to promote your offerings. You only need a name-email database that works with Google Sheets. Don't have one? You can export contacts from services like Hunter.io, Tomba.io, Dropcontact.io, findymail.com, or Instantly. If Google Sheets isn't your preferred tool, feel free to use Airtable or another CRM solution. Here's how it works: - HARPA scans company websites after receiving an ema

Free

Monitor n8n community and Reddit discussions in Telegram with Gemini and Groq

This n8n template automates the collection, storage, and summarization of technology news and discussions from the n8n Community and Reddit (r/n8n). If you like staying informed but want to reduce daily manual browsing distractions, this workflow is perfect for you. How it works User Intent Detection: The workflow receives your Telegram message and uses an AI Agent (powered by Gemini/Groq) to intelligently classify your intent (

Free

Create Shopify customers from a Google Sheet

Task Read a list of customers from a GoogleSheet and create them in Shopify using Shopify's Admin API (GraphQL). Why ? - Generate test users for development stores. - Migrate customers from other platforms. - Easy intro to Shopify's GraphQL API. Setup Setting up Google Sheets access Follow the instructions in the N8N Docs for granting Oauth2 access to Google services. You'll need to grant API access to Google Sheets and Google Drive (to list available sheets). Setting up Shopify access Shopify

Free

Watch Pipedrive deals and update Google Sheets rows accordingly

Automatically track Pipedrive deals and update corresponding Google Sheets rows. Streamline sales data management by syncing deal changes with your spreadsheets.

Free

Customer support & lead collection chatbot with RAG, GPT-4o, Sheets & Telegram

Whoโ€™s it for This template is designed for small and medium businesses, startups, and agencies that want to automate customer inquiries, provide instant support, and capture leads without losing valuable conversations. Itโ€™s especially useful for teams that get many repetitive questions about products, services, or locations but donโ€™t want to miss out on collecting contact details for follow-up. What it does / How it works The workflow creates a 24/7 AI-powered chatbot that answers company-relate

Free

Create AI YouTube SRT subtitles ๐Ÿ“ข with ElevenLabs ๐ŸŽง and Google Drive

This workflow is a simple yet brilliant automation designed to generate time-coded SRT subtitles starting directly from a video URL using ElevenLabs. With just a single video link, the workflow automatically extracts the audio, transcribes it using AI speech recognition, and converts the transcription into a properly formatted SRT subtitle file with accurate timestamps. This workflow automates the creation of SRT subtitle files for YouTube videos using AI speech recognition, eliminating the need

Free

Automated Sonarr missing episode finder with quality & language filtering

What is this? This is an n8n workflow designed to supercharge your Sonarr setup. Instead of just waiting for releases to appear in your RSS feed, this workflow proactively runs on a schedule, finds what's missing, actively searches for it, and grabs the best result based on your specific criteria. It's a "set it and forget it" solution to ensure your library is always complete. Key Features ๐Ÿš€ Proactive Searching: Doesn't wait for content to come to you. It actively triggers a search for missing

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint โ€” instant download
  • Setup guide PDF included
  • 5 downloads ยท valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

โ‚น2,499/ session
3 hrs ยท video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free