Analyze Trending YouTube Videos with Apify, OpenAI, and Google Sheets

Description

⚙️ Trending YouTube Videos Research Workflow:

🧑‍💻 Author: [Leewei]

Automates scraping trending videos based on a keyword, filters high-potential ones, analyzes thumbnails and transcripts with AI, generates optimized titles and outlines, and updates a Google Sheet for content ideas.
🚀 Steps to Connect:

Apify API Token
Sign up for a free account at Apify and generate your API token.
Paste the token into the two HTTP Request nodes (replace <token> in the Authorization header).
💡 This enables scraping YouTube video data and transcripts—setup takes about 5 minutes.

OpenAI API Key
Go to OpenAI and generate your API key.
Add it to the credentials for the YouTube Title Generator, Analyze Thumbnail, and Outline Generator nodes.
💡 Use models like GPT-4o-mini for thumbnail analysis and title/outline generation.

Google Sheets Credentials
Set up OAuth2 credentials in n8n for Google Sheets with access to your Drive.
Update the documentId in the Step 1 Results, Find Duplicate Entries, and Update Rows nodes to your own Google Sheet ID (clone the provided sheet if needed).
💡 This stores filtered video data, AI-generated titles, and outlines—expect 10-15 minutes for auth setup.

(Optional) Customize Form Trigger
If deploying publicly, no changes needed—the form prompts for "Keyword or Topic" to start the search.
Test with a sample keyword like "AI automation" to see results in your sheet.