AlekSystem Workflow Detail

AI Analysis Workflow for Trending YouTube Videos with Apify, OpenAI, and Google Sheets

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

⚙️ Trending YouTube Videos Research Workflow: 🧑‍💻 Author: [Leewei] Automates scraping trending videos based on a keyword, filters high-potential ones, anal...

Rank 57 Verified workflow

Workflow overview

Why this workflow matters

Useful for software delivery and engineering operations. Supports knowledge capture and document intelligence use cases.

⚙️ 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 AlekSystem 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.

Best fit

Categories

AI/MLDevOpsMarketingDocument Ops

Services

Google SheetsOpenAI

Use cases

content automationengineering workflow automationdocument intelligence