🎬 Rotate YouTube channel banners on a schedule with Google Sheets and Drive
⚡ 40 views · 🎬 Content Creation & Video
💡 Pro Tip — YouTube’s API quotas can be a bottleneck when you’re pulling data at scale. ScraperNode is a community node with dedicated scrapers for channels, videos, and comments — no quota limits, just structured data.
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.
🔗 Nodes Used
Google Sheets, Google Drive, YouTube, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File