See llms.txt for all machine-readable content.

Back to Templates

Audit YouTube video metadata changes with Google Sheets and Slack

Created by

Created by: Kevin Yu || exekyute
Kevin Yu

Last update

Last update a day ago

Categories

Share


Quick Overview

This workflow runs daily to fetch all videos from a YouTube channel, compare key metadata fields against a prior snapshot stored in Google Sheets, log any differences, and optionally post a summary to Slack.

How it works

  1. Runs every day at 08:00 on a schedule.
  2. Reads your YouTube channel’s uploads playlist and retrieves each video’s current title, description, tags, privacy status, and category.
  3. Loads the previous snapshot from Google Sheets and compares the tracked fields to detect added, removed/hidden, or changed metadata.
  4. When changes are found, appends each changed field (old value vs new value) to a Google Sheets change log.
  5. Clears and rewrites the snapshot in Google Sheets with the latest metadata so the next run compares against today’s baseline.
  6. Posts a summary to a Slack channel when changes are detected (or when alwaysNotify is enabled).

Setup

  1. Add a YouTube (Google) OAuth2 credential and set your target channel ID in the audit options.
  2. Add a Google Sheets credential, set the spreadsheet ID, and ensure your spreadsheet has a Snapshot tab and a Change Log tab mapped in the Google Sheets steps.
  3. Add a Slack credential and set the target Slack channel ID for the summary message.
  4. (Optional) Enable alwaysNotify to post to Slack even when no changes are detected, and adjust the daily schedule time if needed.