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
- Runs every day at 08:00 on a schedule.
- Reads your YouTube channel’s uploads playlist and retrieves each video’s current title, description, tags, privacy status, and category.
- Loads the previous snapshot from Google Sheets and compares the tracked fields to detect added, removed/hidden, or changed metadata.
- When changes are found, appends each changed field (old value vs new value) to a Google Sheets change log.
- Clears and rewrites the snapshot in Google Sheets with the latest metadata so the next run compares against today’s baseline.
- Posts a summary to a Slack channel when changes are detected (or when alwaysNotify is enabled).
Setup
- Add a YouTube (Google) OAuth2 credential and set your target channel ID in the audit options.
- 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.
- Add a Slack credential and set the target Slack channel ID for the summary message.
- (Optional) Enable alwaysNotify to post to Slack even when no changes are detected, and adjust the daily schedule time if needed.