See llms.txt for all machine-readable content.

Back to Templates

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

Created by

Created by: Fahmi Fahreza || fahmiiireza
Fahmi Fahreza

Last update

Last update a day ago

Categories

Share

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 [FOLDER_ID] 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.