Transcript Content Repurposing with AI and Google Sheets - n8n Workflow

• Content marketers and SEO specialists needing high-volume content repurposing.


• Video creators looking to quickly convert video scripts into blog posts.


• Users seeking advanced n8n templates that combine AI, coding, and spreadsheet operations.


• Technical users leveraging the OpenRouter n8n node for diverse LLM access.

This comprehensive n8n workflow is designed to automate the strenuous process of turning raw YouTube video transcripts into polished, structured content assets. It offers exceptional flexibility through two distinct input methods: a Google Sheets n8n trigger, perfect for batch processing URLs, and a Webhook n8n trigger for immediate, real-time requests. The core of this automation relies on the LangChain framework within the n8n node structure, utilizing an OpenRouter Chat Model to apply complex prompts—summarizing, restructuring, and enhancing the dialogue into ready-to-publish material with clear headings. Every step, from extracting the video ID via a Code n8n node to saving the final output using the Google Sheets n8n node, is meticulously handled, providing a robust solution for scalable content generation.

This n8n workflow operates on a dual-path architecture, initiated by one of two n8n trigger events.

Path 1: Google Sheets Trigger

1. The Monitor Google Sheet for URLs n8n trigger watches a specified spreadsheet for new entries (YouTube URLs).


2. The Extract YouTube Video ID (Sheets) Code n8n node parses the URL to isolate the video identifier.


3. The Fetch Video Transcript Data (Sheets) HTTP Request n8n node retrieves the raw transcript data.


4. The Parse Transcript Text (Sheets) Code n8n node cleans and formats the text.


5. The Rewrite The Transcript (sheets) LangChain n8n node passes the transcript to the OpenRouter Chat Model for restructuring and rewriting based on defined prompts.


6. The Parse AI Output Into Headings(sheets) Code n8n node ensures the AI-generated text is correctly segmented.


7. The final output is saved sequentially using the Save New Script to Sheet and Save Transcript to Sheet Google Sheets n8n node steps.

Path 2: Webhook Trigger

1. The Webhook Trigger (Direct Input) n8n trigger receives a URL from an external application.


2. Similar Code and HTTP Request n8n node steps extract the ID and fetch the transcript (Extract YouTube Video ID (Sheets)2, Fetch Video Transcript Data (Webhook)).


3. The text is processed by the AI via Rewrite The Transcript (webhook) and OpenRouter Chat Model1.


4. The results are saved to Google Sheets.


5. The Return Transcript Response n8n node sends a successful confirmation back to the requesting service, completing the n8n workflow execution.

To set up this powerful n8n template, follow these steps:

1. Import: Copy the provided JSON code and paste it into your n8n canvas using the 'New' -> 'Import from JSON' option.


2. Credentials: You must configure credentials for the following services:

1. Configuration:

Monitor Google Sheet for URLs (n8n trigger): This Google Sheets Trigger n8n node initiates Path 1 whenever a new row is added or updated in the specified sheet, containing the YouTube URL.
Webhook Trigger (Direct Input) (n8n trigger): This standard Webhook n8n node initiates Path 2, allowing external systems to push a URL to the n8n workflow for immediate processing.
Extract YouTube Video ID (Sheets/Webhook) (Code n8n node): These nodes contain custom JavaScript logic to parse the full YouTube URL and extract only the essential video ID, necessary for the transcript fetching process.
Fetch Video Transcript Data (Sheets/Webhook) (HTTP Request n8n node): Responsible for calling the external API endpoint used to retrieve the full, raw text transcript for the extracted video ID.
Parse Transcript Text (Sheets/Webhook) (Code n8n node): Cleans the raw JSON response from the transcript API, often concatenating time-stamped segments into a single, clean block of text ready for AI input.
OpenRouter Chat Model / OpenRouter Chat Model1 (AI Language Model n8n node): Connects the LangChain prompt to a powerful large language model hosted via OpenRouter. This n8n node is configured to handle the complex generation task.
Rewrite The Transcript (sheets/webhook) (LangChain Chain LLM n8n node): This crucial n8n node uses specific system and user prompts to instruct the LLM on how to transform the raw transcript (e.g., summarize, add subheadings, optimize for SEO).
Parse AI Output Into Headings (Code n8n node): Analyzes the text outputted by the AI and extracts key elements or reformats it for optimal storage in the spreadsheet columns.

• Save Transcript to Sheet (Google Sheets n8n node): The final action in this n8n workflow, writing the completely processed and restructured content back to a designated Google Sheet row.