Generate YouTube clip ideas and Google Docs reports with Apify and OpenRouter

Go to Workflow
0 views
Built by Fahmi Fahreza Fahmi Fahreza
Created on August 18, 2026

Description

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
Receives a YouTube link submission through an n8n form.
Runs an Apify YouTube transcript extractor for the submitted URL and retrieves the resulting dataset.
Reformats the transcript into timestamped lines (MM:SS) to create a single analysis-ready text block.
Sends the formatted transcript to an OpenRouter chat model to produce a structured Markdown report of viral clip recommendations.
Converts the generated Markdown into HTML for document creation.
Uploads a new Google Docs file to Google Drive (in the specified folder) containing the HTML-formatted report.

Setup
Add an Apify OAuth2 credential and ensure you have access to the YouTube transcript extractor actor used in the workflow.
Add an OpenRouter API credential for the chat model used to generate the clip recommendations.
Add a Google Drive OAuth2 credential with permission to create files, and keep the Google Drive upload endpoint accessible from your environment.
Replace the [FOLDER_ID] placeholder with your target Google Drive folder ID in the document metadata step.
Publish the form and share the form URL (or embed it) wherever you want users to submit YouTube links.

Nodes Used (4)

AI Agent
@n8n/n8n-nodes-langchain.agent
Code
n8n-nodes-base.code
HTTP Request
n8n-nodes-base.httpRequest
OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter