Digest New YouTube Videos to Slack with AI & Sheets

This workflow monitors specified YouTube channels by pulling RSS feeds from a Google Sheet every 10 minutes. It fetches and parses feeds using HTTP and XML nodes, filtering only brand-new videos. For each new video, it retrieves title and description via YouTube API, then grabs English subtitles using RapidAPI.

Next, code nodes prepare an AI prompt payload, and OpenAI's GPT-4o-mini generates a concise JSON summary and key takeaways formatted as an article. A formatter converts this into Slack Block Kit for a polished message, which is posted directly to your chosen Slack channel. Processed video links are appended to the Google Sheet to avoid reprocessing duplicates.

Benefits include massive time savings for marketing and content teams—no more manual video checks or note-taking. It delivers human-readable, actionable insights instantly in Slack, improving team collaboration on trending content. The workflow scales easily for multiple channels and handles errors gracefully.

Ideal for content curation, competitive analysis, enablement, or staying updated on industry influencers. Customize by adding RSS URLs to the sheet, tweaking AI prompts for specific summary styles, or adjusting post formats.

Setup requires Google Sheets OAuth, Slack bot token, RapidAPI key for subtitles, and OpenAI credential. Make a copy of the provided template sheet and execute.