Automated YouTube Video URL Sync with Google Sheets

somdn_product_page

This n8n workflow automates the process of fetching YouTube video URLs from multiple channels and syncing them into a Google Sheet. It begins with a manual trigger, allowing users to initiate the process manually. The workflow then reads a list of YouTube channel IDs from a Google Sheet, and for each channel, it makes API requests to YouTube to retrieve the latest videos sorted by date. The video details, including titles, URLs, and publication dates, are formatted appropriately and then inserted or updated in another Google Sheet.

The workflow involves the following key steps:

1. Manual trigger for manual initiation.

2. Fetching channel IDs from a Google Sheet.

3. For each channel ID, making an API request to YouTube to get recent videos.

4. Formatting the video information to match Google Sheets’ schema.

5. Inserting or updating the video data into a Google Sheet.

This automation is particularly useful for content creators, social media managers, or teams managing multiple YouTube channels, enabling them to maintain an up-to-date repository of latest videos without manual effort. It streamlines the process of tracking and managing YouTube content via Google Sheets, enabling further analysis or sharing.

Node Count

6 – 10 Nodes

Nodes Used

googleSheets, httpRequest, manualTrigger, set, splitOut, stickyNote

Reviews

There are no reviews yet.

Be the first to review “Automated YouTube Video URL Sync with Google Sheets”

Your email address will not be published. Required fields are marked *