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
- Every Monday Morning
- Config
- Check Your Settings
- Read Offers Sheet
- Read Past Checks
- Get My Channel
- Read Channel
- Get Uploaded Videos
- Group Video IDs
- Get Video Details
- Read Descriptions
- List Links to Test
- Test Each Link
- Find Problems
30 steps in total.
Similar automations
AI Agents & AssistantsCheck scheduled Klaviyo campaign offers and links with Claude, Sheets and Slack23 stepsReports, Analytics & DashboardsFix WordPress SEO titles and meta descriptions with Gemini and Slack approval40 stepsData Sync & ETLScan and fix WordPress noindex pages with Google Sheets and RankMath15 stepsForms & SurveysCheck and fix Japanese PR TIMES press releases with rule tables and OpenAI14 steps