See llms.txt for all machine-readable content.

Back to Templates

Rotate YouTube channel banners on a schedule with Google Sheets and Drive

Created by

Created by: Kevin Yu || exekyute
Kevin Yu

Last update

Last update 6 hours ago

Categories

Share

Quick Overview

This workflow runs daily at 8am to rotate a YouTube channel banner based on a schedule stored in Google Sheets, downloading the banner image from Google Drive, applying it via the YouTube API, and updating the sheet to mark the banner as applied.

How it works

  1. Runs every day at 8am on a schedule trigger.
  2. Reads the banner rotation plan from Google Sheets, including swap date, Google Drive file ID, label, and status.
  3. Filters the sheet rows to keep banners due today or overdue that are not yet marked as Applied, and sorts them oldest-first.
  4. Downloads the selected banner image from Google Drive and uploads it as a YouTube channel banner.
  5. Fetches the current YouTube channel branding settings and updates the channel to activate the new banner while preserving existing branding fields.
  6. Updates the matching Google Sheets row to set Status to Applied and outputs a log record with the swap timestamp, channel ID, and banner details.

Setup

  1. Add Google OAuth credentials for YouTube Data API and connect them to the YouTube nodes.
  2. Add Google Sheets and Google Drive credentials and connect them to the respective nodes.
  3. Set your YouTube channel ID in the banner configuration step.
  4. Update the Google Sheets document ID and sheet/tab name in both Google Sheets steps, and ensure the sheet contains columns named Swap Date, Banner Drive File ID, Label, and Status.