Automate Your YouTube Video Updates with Google Sheets
detail.loadingPreview
Seamlessly sync your YouTube video URLs and related metadata directly into your Google Sheets. This workflow automates the process, saving you valuable time and ensuring your video data is always up-to-date.
About This Workflow
This n8n workflow provides a robust solution for synchronizing your YouTube video information with Google Sheets. It begins by retrieving channel IDs from a designated Google Sheet. For each channel, it then fetches the latest video URLs and their associated details, such as title and publication date, directly from YouTube's API. The retrieved data is meticulously formatted to match your Google Sheet's schema, and then efficiently appended or updated in your spreadsheet. This ensures you have a centralized, real-time repository of your YouTube content, making it easier to track, analyze, and manage your video assets.
Key Features
- Automated Data Retrieval: Pulls YouTube video URLs and metadata directly from your specified channels.
- Google Sheets Integration: Seamlessly reads channel IDs from and writes video data to your Google Sheets.
- Smart Data Syncing: Appends new videos and updates existing entries in your Google Sheet based on video URL matching.
- Customizable Data Fields: Easily formats and maps essential video details like title and publication date.
- API Driven: Leverages the power of the YouTube Data API for accurate and up-to-date information.
How To Use
- Set up your Google Sheets: Ensure you have a Google Sheet with a tab containing your YouTube channel IDs. You'll also need a separate tab where the workflow will write the video URLs and their details.
- Configure Google Sheets Credentials: In n8n, set up your Google Sheets credentials (service account recommended) for authentication.
- Connect to YouTube: Obtain an API key for the YouTube Data API. You can usually do this through the Google Cloud Console.
- Customize Workflow Nodes:
- Get Youtube Channel Ids from Google Sheet: Update
documentIdandsheetNameto point to your Google Sheet containing channel IDs. - Get Youtube Video Urls form specific channel: Ensure your YouTube API key is configured in the
Query Auth account 3credentials. ThechannelIdparameter will be dynamically pulled from the previous Google Sheets node. - Format fields as required to save in google sheet: Verify the mapping of JSON fields to your desired output fields (Title, video_urls, published_at).
- Insert & Update Youtube Urls in Google Sheet: Update
documentIdandsheetNameto point to the Google Sheet where you want to store the video data. Ensure thematchingColumnsis set tovideo_urlsfor proper updating.
- Get Youtube Channel Ids from Google Sheet: Update
- Test and Activate: Run the workflow manually to test its functionality. Once satisfied, set up a trigger (e.g., a schedule) to run it automatically.
Apps Used
Workflow JSON
{
"id": "6491d3ae-4054-4e92-91bf-335fdeec2bf0",
"name": "Automate Your YouTube Video Updates with Google Sheets",
"nodes": 23,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 6491d3ae-4054...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.