Create Viral YouTube Content from Reddit Posts with GPT-4o & Sheets

This n8n workflow is Phase 1 of a powerful automation pipeline that transforms viral Reddit posts into YouTube content. It starts by pulling the latest hot posts from targeted subreddits like r/AskReddit or r/confession via Reddit API. Posts are then processed to remove duplicates, followed by a custom virality scoring mechanism that weighs factors like upvotes, comments, and engagement metrics—potentially enhanced by GPT-4o for deeper sentiment or trend analysis. Finally, the highest-scoring candidates are cleanly formatted and written to a Google Sheet, ready for human review or the next phases (scripting, video gen, publishing).

Key benefits include massive time savings for content creators, who no longer need to manually scour Reddit for ideas. The intelligent scoring prioritizes truly viral material, boosting YouTube Shorts performance with proven hooks. It's scalable, customizable (tweak scores for niches), and integrates Reddit, OpenAI, and Google Sheets seamlessly, reducing grunt work to zero.

Use cases: YouTubers making reaction/storytelling Shorts, marketers testing viral narratives, or agencies automating social content pipelines. Schedule daily via Cron for a constant idea flow. Setup is straightforward: add Reddit creds, link Google account, point to your Sheet, and run.

Perfect for solo creators or teams scaling faceless YouTube channels with AI-driven efficiency.