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

📝 Description

This workflow automates the collection, filtering, and scoring of trending AskReddit posts for viral potential. It pulls posts from Reddit, removes duplicates, calculates a custom virality score, and writes the final candidates into Google Sheets for later use in content creation.

This is Phase 1 of the AskReddit → YouTube Shorts automation pipeline. It prepares clean, high-quality data that can be used in the next phases (script generation, AI video creation, and publishing).

⚙️ Setup Steps

Import Workflow into your n8n instance.

Reddit API:

Add your Reddit API credentials in the "Get AskReddit Posts" node.

Google Sheets:

Connect your Google account.

Point the "Write Candidates" node to your target Google Sheet.

Virality Scoring:

The "Add Virality Score" node assigns weights (e.g., upvotes, comments).

Adjust the scoring logic as needed for your niche.

Run Workflow:

Execute manually or schedule with Cron.

Verify that trending AskReddit posts appear in your sheet, scored and cleaned.