Analyze trending YouTube videos with Apify, OpenAI, and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 11 nodes and runs when someone submits an n8n form (“YouTube Topic Research”). Along the way it connects Google Sheets and OpenAI. It also calls api.apify.com over HTTP.
How it runs
Trigger: When someone submits an n8n form (“YouTube Topic Research”).
- YouTube Video Scrape (HTTP Request): calls api.apify.com (POST)
- If: checks a condition and branches into true / false
- Find Duplicate Entries (Google Sheets): uses Google Sheets
- Merge: merges the data from its input branches
- Step 1 Results (Google Sheets): append
- Analyze Thumbnail (OpenAI): analyze (image)
- HTTP Request: calls api.apify.com (POST)
- YouTube Title Generator (OpenAI): uses OpenAI
- Outline Generator (OpenAI): uses OpenAI
- Update Rows (Google Sheets): update
Services it uses
HTTP calls to: api.apify.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- If
n8n-nodes-base.if - Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets - OpenAI
@n8n/n8n-nodes-langchain.openAi - HTTP Request
n8n-nodes-base.httpRequest - n8n Form Trigger
n8n-nodes-base.formTrigger
From the author
⚙️ 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…