Track top YouTube videos by view count with Google Sheets

Workflow Setup Guide

This workflow collects the most-viewed videos from specified YouTube channels and saves the data to a Google Sheet. Follow these steps to set it up:

1. Credentials Setup

• Google Sheets: You need to have a Google Sheets credential configured in your n8n instance. If you don't have one, go to the 'Credentials' section in n8n and add a new credential for Google Sheets.
• YouTube API Key: You need a YouTube Data API v3 key.
  1. Go to the Google Cloud Console.
  2. Create a new project or select an existing one.
  3. Go to 'APIs & Services' > 'Library' and enable the YouTube Data API v3.
  4. Go to 'APIs & Services' > 'Credentials', click 'Create Credentials', and choose 'API key'.
  5. Copy the generated API key.

2. Google Sheet Setup

You will need one Google Sheet with two separate sheets (tabs) inside it.

Input Sheet

Use Template This sheet provides the list of YouTube channels to process.

• Required Columns: Create a sheet with the following two columns:
  • ChannelID: The ID of the YouTube channel (e.g., T7M3PpjBZzw).
  • video_num_to_get: The number of top videos to retrieve for that channel (e.g., 5).

Output Sheet

This sheet is where the results will be saved.

• Required Columns: The workflow will automatically append data to the following columns. You can create them beforehand or let the workflow do it.
  • channelName
  • title
  • videoId
  • videoLink

3. Node Configuration

• Read Channel Info from Sheet:
  • Select your Google Sheets credential.
  • Enter your Spreadsheet ID.
  • Enter the name of your Input Sheet.
• Fetch Most-Viewed Videos via YouTube API:
  • Replace YOUR_YOUTUBE_API_KEY with the API key you generated in Step 1.
• Append Video Details to Sheet:
  • Select your Google Sheets credential.
  • Enter your Spreadsheet ID (the same one as before).
  • Enter the name of your Output Sheet.