Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / AI Agents & Assistants

AI Agents & Assistants

Fix broken YouTube description links and offers with Claude, Google Sheets and Slack

On a schedule, it runs an AI agent with Claude using Google Sheets, Slack, Google APIs.

What it does

## Find broken links and expired offers in YouTube video descriptions with Claude, Google Sheets and Slack ### Who is it for Course creators, brands and agencies with a back catalogue of YouTube videos. Old descriptions keep sending viewers to dead pages and expired discount codes long after anyone remembers they are there. ### How it works 1. Every Monday, the workflow reads the descriptions of your newest videos (200 by default) and tests each web link once. Links to YouTube itself are skipped. 2. Plain code compares every code and offer date with your offers sheet, and lists dead links, codes that ended or are missing from the sheet, and offer dates that have passed. 3. Slack gets a weekly summary. The most viewed videos with problems come first, five a week by default. 4. For each one, Claude rewrites only the broken lines with the live links, codes, discounts and end dates from your sheet. Check Fix Against Sheet is plain code and stops the fix if any link, code, number or date is not in the sheet. 5. Slack shows the old and new lines. Only after you press Approve is the description updated, and the title, tags and privacy stay as they are. 6. Every answer is logged in your sheet, so a fix you declined is not asked about again unless the description changes. ### How to set up - [ ] Make a Google Sheet with an Offers tab (columns Name, Code, Discount, Starts, Ends, Link, one row per live offer or page) and an empty Checks tab. - [ ] In Get My Channel, create a YouTube OAuth2 API credential with the Google account that owns the channel. Pick it in Get Uploaded Videos, Get Video Details and Update Video Description. On self-hosted n8n, turn on the YouTube Data API v3 in your Google Cloud project first. - [ ] Connect Google Sheets, Slack and Anthropic. - [ ] Fill in Config: the sheet link and your Slack channel ID (at the bottom of the channel details), then publish. ### Requirements YouTube, Google Sheets, Slack and an Anthropic API key. Each approved update uses 50 of the 10,000 free YouTube API units you get every day. ### How to customize the workflow In Config, change maxVideos, maxFixesPerRun, maxLinksPerVideo or approvalWaitHours. Change the day and time in Every Monday Morning. Swap the Claude model for any chat model.

The steps

  1. Every Monday Morning
  2. Config
  3. Check Your Settings
  4. Read Offers Sheet
  5. Read Past Checks
  6. Get My Channel
  7. Read Channel
  8. Get Uploaded Videos
  9. Group Video IDs
  10. Get Video Details
  11. Read Descriptions
  12. List Links to Test
  13. Test Each Link
  14. Find Problems

30 steps in total.

Similar automations