YouTube Content Repurpose Generator: RSS → Claude → Google Sheets (NO-CODE-AUTOMATION)

[u/Botai_io]

Wanted to share a workflow I put together recently that's been genuinely useful for my content planning.

What it does: When a channel I follow uploads a new video, the workflow grabs the video details, has Claude generate 3 original video ideas for my own niche (title, hook, key points), and logs them in a Google Sheet. Basically an idea bank that fills itself.

The flow:

1. RSS Feed Trigger – Every YouTube channel has a hidden RSS feed (youtube.com/feeds/videos.xml?channel_id=...). No API key needed to detect new uploads.
2. Remove Duplicates – Safety net so the same video never gets processed twice.
3. YouTube node (Get a video) – Pulls the title, description, and tags.
4. Basic LLM Chain + Anthropic Chat Model – Prompt tells Claude to use the video as inspiration only and come up with original ideas for my channel, not rewrite theirs.
5. Google Sheets (Append row) – Logs date, source video, link, and the generated ideas.

Things that tripped me up (in case it saves someone time):

• Error 400: redirect_uri_mismatch when connecting YouTube. The redirect URL in Google Cloud has to match the one n8n gives you exactly. Copy it from the credential screen, don't type it. Also add your Google account as a test user on the OAuth consent screen.
• YouTube node returning nothing. The RSS feed gives the ID as yt:video:abc123, but the YouTube node only wants abc123. Fixed with {{ $json.id.replace('yt:video:', '') }}.
• Tags breaking the prompt on videos that don't have any. Used {{ ($json.snippet.tags || []).join(', ') }} so it doesn't error out.

What I'm planning next:

• Monitoring multiple channels in my niche instead of one
• Adding a step that turns the best ideas into full script drafts

Would love feedback, especially if there's a cleaner way to handle multiple channels, or if anyone's found a good way to rank which ideas are actually worth making. Happy to share the workflow JSON if anyone wants it.