Generate YouTube clip ideas and Google Docs reports with Apify and OpenRouter
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
Community nodes
These come from third-party npm packages. In n8n 3.0 unverified community packages are off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
@apify/n8n-nodes-apify(Run Youtube Transcript Extractor, Get Recent Transcript Dataset)
Nodes used (8)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Apify
@apify/n8n-nodes-apify.apify - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Markdown
n8n-nodes-base.markdown
What it does
Quick overview This workflow collects a YouTube link via an n8n form, extracts the video transcript with Apify, uses an OpenRouter chat model to generate short-form clip ideas in Markdown, and creates a Google Docs file in a specified Google Drive folder. How it works 1. Receives a YouTube link submission through an n8n form. 2. Runs an Apify YouTube transcript extractor for the submitted URL and retrieves the resulting dataset. 3. Reformats the transcript into timestamped lines (MM:SS) to create a single analysis-ready text block. 4. Sends the formatted transcript to an OpenRouter chat model to produce a structured Markdown report of viral clip recommendations. 5. Converts the generated Markdown into HTML for document creation. 6. Uploads a new Google Docs file to Google Drive (in the specified folder) containing the HTML-formatted report. Setup 1. Add an Apify OAuth2 credential and ensure you have access to the YouTube transcript extractor actor used in the workflow. 2. Add an OpenRouter API credential for the chat model used to generate the clip recommendations. 3. Add a Google Drive OAuth2 credential with permission to create files, and keep the Google Drive upload endpoint accessible from your environment. 4. Replace the FOLDERID placeholder with your target Google Drive folder ID in the document metadata step. 5. Publish the form and share the form URL (or embed it) wherever you want users to submit YouTube links. Additional info Published by Fahmi Fahreza, Indonesia’s first official n8n Brand Ambassador and founder of WithMi Automation, built from real client implementations, not tutorials. → Let us build it for you: withmiautomation.com(withmiautomation.com) → Learn to build it yourself: academy.withmiautomation.com(academy.withmiautomation.com) → Bring Fahmi to your team (training, workshop, talkshow): fahmiiireza.com(fahmiiireza.com)