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.
Tags
Related workflows
See all Google Drive→Audit Google Drive backup freshness with Google Sheets and Slack
Quick overview This workflow runs nightly to audit a Google Drive backup folder against an SLA table in Google Sheets, logging a per-source scorecard and sending a Slack alert only when backups are missing, stale, or unexpectedly small. How it works Runs on a nightly schedule. Reads an SLA table from Google Sheets that defines expected backup sources, filename patterns, cadence, and freshness/size thresholds. Searches a specified Google Drive folder and retrieves metadata for all non-trashed files. Compares each SLA row to matching Drive files to classify the newest backup as OK, MISSING, STALE, or SHRUNK and builds an alert summary for any failures. Appends one scorecard row per source to a Google Sheets audit tab with the run time, verdict, newest file details, and size comparisons. Posts a single Slack message listing all failing sources when at least one source is not OK. Setup Add Google Sheets OAuth2 credentials, select the spreadsheet and the SLA and scorecard sheet tabs in the Google Sheets nodes. Add Google Drive OAuth2 credentials and replace the placeholder folder ID in the Drive search query to point at your backup folder. Add Slack credentials and choose the channel to
Recognize invoices / receipts from Google Drive and put them into Google Sheets
This workflow allows you to recognize a folder with receipts or invoices (make sure your files are in .pdf, .png, or .jpg format). The workflow can be triggered via the "Test workflow" button, and it also monitors the folder for new files, automatically recognizing them. Video Demo https://youtu.be/mGPt7fqGQD8 1. n8n import glitch After import, the trigger node "When clicking 'Test workflow'" might be disconnected. You need to connect it via 2 arrows to "Google Sheets1" and "Google Drive" nodes. So, the workflow has 2 triggers - via button, and via Google Sheets "new file" event - both of these triggers should be connected to 2 nodes. Here is how it should look like: https://ocr.oakpdf.com/n8n_fix.png 2. Set up RapidAPI HTTP auth key Create new "HTTP header" n8n credential and paste your RapidAPI key from https://rapidapi.com/restyler/api/receipt-and-invoice-ocr-api into it. https://ocr.oakpdf.com/n8n_api_key.png Make sure "HTTP Request" node uses this credential. 3. Set up your Google Auth You need a Google connection to work with your Google Sheets and Google Drive accounts: https://docs.n8n.io/integrations/builtin/credentials/google/oauth-generic/#finish-your-n8n-credential 4. S
Download Videos from Any Platform to Google Drive with RapidAPI Integration
🚀 All-In-One Video Downloader to Google Drive (via RapidAPI best All-In-One Video Downloader) Description: This n8n workflow automates the process of downloading videos from any supported platform (like LinkedIn, Facebook, or Instagram) using the RapidAPI best All-In-One Video Downloader. It then uploads the video to your Google Drive and shares it publicly, while logging any failures in Google Sheets for tracking. 📦 Node-by-Node Breakdown | 🧩 Node Name | 📝 One‑Line Explanation | |-------------------------------|-------------------------------------------------------------------------------| | On form submission | Triggers the workflow when a user submits a video URL through a web form. | | All in one video downloader | Sends a POST request to RapidAPI best All-In-One Video Downloader to fetch downloadable video links. | | If | Checks whether the API response includes an error and routes accordingly. | | Download mp4 | Downloads the video using the direct media URL received from the API. | | Upload To Google Drive | Uploads the MP4 file to a designated folder in your Google Drive. | | Google Drive Set Permission | Makes the uploaded file publicly shareable with a viewable link.