Automate YouTube Metadata Tracking with Google Sheets & Slack

Automate YouTube Metadata Tracking with Google Sheets & Slack

Streamline your YouTube channel management by automating metadata tracking with our robust n8n workflow. Automatically fetch daily video updates, compare metadata changes, and stay informed with Slack notifications — all without manual effort!

What This Workflow Does

• Daily Schedule: Operates every day at 08:00 to ensure up-to-date information.
• Data Retrieval: Gathers the current title, description, tags, privacy status, and category of each video from your YouTube uploads playlist.
• Comparison & Logging: Compares current data with a previous snapshot in Google Sheets, logging differences in metadata, both added and removed/hidden, into a Change Log.
• Snapshot Update: Refreshes the metadata snapshot in Google Sheets with the latest information for seamless future comparisons.
• Slack Notifications: Provides updates to a designated Slack channel whenever changes are detected, with the option to enable notifications even when no changes occur.

Use Cases

• Content Creators: Keep track of any sudden or unnoticed modifications to video details, enhancing content strategy consistency.
• Channel Managers: Ensure accurate reporting and content auditing by automatically logging metadata changes over time.
• Marketing Teams: Quickly identify how adjustments to video data might align with or impact broader marketing campaigns and strategies.

Technical Details

• Nodes Used: if, set, code, Slack, switch, YouTube
• Integrations: YouTube OAuth2 for channel data access, Google Sheets for data storage, Slack for team notifications.

Leverage this specialized n8n automation workflow to improve efficiency and keep your YouTube channel’s metadata in check, all while integrating seamlessly with your existing Google Sheets and Slack environment.