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

Description

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
Runs every day at 8am on a schedule trigger.
Reads the banner rotation plan from Google Sheets, including swap date, Google Drive file ID, label, and status.
Filters the sheet rows to keep banners due today or overdue that are not yet marked as Applied, and sorts them oldest-first.
Downloads the selected banner image from Google Drive and uploads it as a YouTube channel banner.
Fetches the current YouTube channel branding settings and updates the channel to activate the new banner while preserving existing branding fields.
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
Add Google OAuth credentials for YouTube Data API and connect them to the YouTube nodes.
Add Google Sheets and Google Drive credentials and connect them to the respective nodes.
Set your YouTube channel ID in the banner configuration step.
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.