January 22, 2026

Telegram to Google Sheets, YouTube posts ready to go

Q: How do I adapt this Telegram Sheets automation solution to my specific challenges?

You can change the output language by editing the output_lang field in the configuration step, then adjust the OpenAI prompts that generate the script and SEO JSON. Many teams also tweak Google Sheets columns (to match their existing tracker) and change the approval rule from “ready” to whatever status name they already use. If you want to repurpose from a different platform, you can swap the transcript fetch step as long as you still provide clean text to the script generator.

Telegram to Google Sheets, YouTube posts ready to go - n8n workflow automation template

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

You grab a great YouTube link, you know it could become a new post, a new script, even a new upload. Then reality hits. Transcript hunting, messy copy-paste, rewriting, SEO fields, and a “where did we track this?” spreadsheet that’s never up to date.

This is where Telegram Sheets automation helps. Content marketers trying to repurpose at volume feel it first, but agency teams and solo creators get stuck in the same grind. The outcome is simple: you send a link once, and you get structured, ready-to-approve assets back in your sheet.

This workflow turns a Telegram message into a logged request, a cleaned transcript, a rewritten script, and SEO metadata. You’ll see what it does, what you need, and how it fits into a real publishing pipeline.

How This Automation Works

See how this solves the problem:

n8n Workflow Template: Telegram to Google Sheets, YouTube posts ready to go

Click to explore

flowchart LR

    subgraph sg0["Telegram Flow"]
        direction LR
        n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/telegram.svg' width='40' height='40' /></div><br/>Telegram Trigger"]
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Parse Telegram Message"]
        n2@{ icon: "mdi:database", form: "rounded", label: "Append to Google Sheets", pos: "b", h: 48 }
        n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Get Video ID"]
        n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>RapidAPI Summarizer"]
        n5["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Clean Text"]
        n6@{ icon: "mdi:robot", form: "rounded", label: "Generate Script", pos: "b", h: 48 }
        n7@{ icon: "mdi:robot", form: "rounded", label: "Generate SEO", pos: "b", h: 48 }
        n8["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/telegram.svg' width='40' height='40' /></div><br/>Send to Telegram"]
        n9@{ icon: "mdi:swap-vertical", form: "rounded", label: "Workflow Configuration", pos: "b", h: 48 }
        n10@{ icon: "mdi:database", form: "rounded", label: "update Google Sheets", pos: "b", h: 48 }
        n5 --> n6
        n7 --> n10
        n3 --> n4
        n6 --> n7
        n0 --> n1
        n4 --> n5
        n10 --> n8
        n1 --> n9
        n9 --> n2
        n2 --> n3
    end

    subgraph sg1["Flow 2"]
        direction LR
        n11@{ icon: "mdi:cog", form: "rounded", label: "Upload Video to BLOTATO", pos: "b", h: 48 }
        n12@{ icon: "mdi:cog", form: "rounded", label: "Youtube", pos: "b", h: 48 }
        n13@{ icon: "mdi:swap-vertical", form: "rounded", label: "Get Google Drive ID", pos: "b", h: 48 }
        n14@{ icon: "mdi:swap-vertical", form: "rounded", label: "Workflow Configuration II", pos: "b", h: 48 }
        n15@{ icon: "mdi:database", form: "rounded", label: "Check Google Sheets", pos: "b", h: 48 }
        n16@{ icon: "mdi:cog", form: "rounded", label: "Download file", pos: "b", h: 48 }
        n17@{ icon: "mdi:database", form: "rounded", label: "Update Google Sheets II", pos: "b", h: 48 }
        n12 --> n17
        n16 --> n11
        n15 --> n13
        n13 --> n16
        n11 --> n12
        n14 --> n15
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n0 trigger
    class n6,n7 ai
    class n2,n10,n15,n17 database
    class n4 api
    class n1,n3,n5 code
    classDef customIcon fill:none,stroke:none
    class n0,n1,n3,n4,n5,n8 customIcon

The Challenge: Turning YouTube Links Into Publish-Ready Assets

Repurposing a YouTube video sounds easy until you try doing it consistently. First you need a transcript, and half the time it’s incomplete, full of timestamps, or broken into weird lines. Then you rewrite it, but you’re juggling tone, structure, and avoiding sounding like a copy. Add SEO fields and tracking on top, and suddenly “one quick repurpose” becomes a project that drags into tomorrow. The worst part is the mental load: keeping track of what’s requested, what’s drafted, what’s approved, and what’s actually published.

It adds up fast. Here’s where it breaks down in real teams.

You end up copy-pasting transcripts into docs, then into a sheet, then into yet another tool to rewrite them.
Requests arrive in DMs, voice notes, and Slack messages, so tracking becomes a second job.
SEO metadata is created last, which means it’s rushed and inconsistent across uploads.
Publishing waits on approval, but there’s no clean “ready” handoff, so videos sit in limbo.

The Fix: Telegram In, Google Sheets Out (With Script + SEO Done)

This workflow starts where your team already communicates: Telegram. You send a YouTube URL (plus any instructions like “make this shorter” or “aim it at beginners”), and the automation logs the request into Google Sheets so nothing gets lost. It then extracts the video ID, pulls the transcript through RapidAPI, and cleans it into readable text you can actually work with. Next, OpenAI rewrites that transcript into a fresh script, and generates SEO metadata (title, description, tags) in a strict JSON format so it’s consistent. Finally, the sheet is updated with everything and the workflow waits until the status is marked ready, then uploads the finished media to Blotato and publishes it to YouTube.

The workflow starts with a Telegram message and ends with a published video and a “publish” status in your sheet. In the middle, it handles transcript extraction, cleanup, script rewriting, and SEO field generation so approvals are the only human step.

What Changes: Before vs. After

What This Eliminates

Impact You’ll See

Manually hunting for transcripts and cleaning up broken formatting.
Copy-pasting the same video details into multiple tracking places.
Rewriting from scratch every time you want a “new” script.
Hand-publishing steps that depend on someone remembering the checklist.

Most teams get about 1 hour back per video repurposed.
Requests stop getting lost because every Telegram link becomes a row in Google Sheets.
SEO fields look consistent across uploads, even when different people submit requests.
Approvals become a simple status change instead of a long message thread.
Publishing happens the same way every time, which means fewer “we forgot the tags” mistakes.

Real-World Impact

Say you repurpose 5 YouTube videos a week. Manually, it’s usually about 20 minutes to find/export a transcript, about 30 minutes to clean and reshape it, and another 20 minutes to write SEO fields and update tracking, so you’re at roughly 1 hour per video (around 5 hours weekly). With this workflow, the “work” is sending the link in Telegram and later approving the row in Google Sheets, maybe 5 minutes total per video. That’s a few hours back every week, without cutting corners.

Requirements

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Telegram to submit YouTube links and instructions
Google Sheets to track requests, approvals, publishing status
OpenAI API key (get it from your OpenAI dashboard)
RapidAPI key (get it from RapidAPI after subscribing)
Blotato credentials (get them from your Blotato account settings)

Skill level: Intermediate. You’ll connect a few accounts, paste API keys, and map Google Sheets columns once.

Need help implementing this? Talk to an automation expert (free 15-minute consultation).

The Workflow Flow

A Telegram message kicks it off. You send a YouTube URL and optional instructions to your Telegram bot. The workflow extracts the useful bits (the link, the notes) so it can be processed reliably.

Your request becomes a trackable row. n8n appends a new entry in Google Sheets, then derives the YouTube video ID from the URL. That little step matters because it prevents messy “wrong link” errors later.

The transcript is fetched, then cleaned. An HTTP Request calls RapidAPI to retrieve the transcript, and a code step normalizes it into readable text. No timestamps, fewer line breaks, and less junk.

OpenAI generates the new script and SEO fields. The workflow first creates a rewritten script, then generates SEO metadata (title, description, and tags) in strict JSON so it drops cleanly into your sheet.

Approval gates the final publish. It checks Google Sheets for rows marked ready, downloads the media from Google Drive, uploads to Blotato, and publishes to YouTube. Then it marks the sheet as publish so you always know what shipped.

You can easily modify the approval status value to match your process based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Telegram Trigger

Set up the workflow entry point so incoming Telegram messages can supply the YouTube URL and user description.

Add and open Telegram Incoming Trigger.
Select the updates array to include message.
Credential Required: Connect your telegramApi credentials.
Keep the default webhook settings and save.

Tip: Send a test message with two lines: line 1 is the YouTube URL, line 2 is the user description used downstream by Extract Telegram Content.

Step 2: Connect Google Sheets and Store Incoming Requests

Configure the primary sheet settings and append each Telegram request into your tracking sheet.

Open Primary Config Setup and set the fixed values: output_lang to english, sheet_id to <__PLACEHOLDER_VALUE__Google Sheets Document ID__>, sheet_tab to <__PLACEHOLDER_VALUE__Sheet Tab Name__>, and rapidapi_key to <__PLACEHOLDER_VALUE__RapidAPI Key__>.
Open Append Sheet Entry and set Operation to appendOrUpdate.
Map the columns exactly: Url to {{ $('Extract Telegram Content').item.json.yt_url }}, Date to {{ $now.toISO() }}, and Description to {{ $('Extract Telegram Content').item.json.user_desc }}.
Set Sheet Name to {{ $('Primary Config Setup').item.json.sheet_tab }} and Document ID to {{ $('Primary Config Setup').item.json.sheet_id }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Append Sheet Entry.

⚠️ Common Pitfall: If sheet_id or sheet_tab remain as placeholders in Primary Config Setup, Append Sheet Entry will fail to write data.

Step 3: Retrieve and Normalize the Transcript

Extract the YouTube video ID, call the transcript API, and normalize the transcript text for the AI script writer.

In Derive Video Identifier, keep the JavaScript that parses the video ID from the Url field.
Configure Transcript API Request with URL set to https://youtube-video-summarizer-gpt-ai.p.rapidapi.com/api/v1/get-transcript-v2.
Set query parameters in Transcript API Request: video_id to {{ $json.videoId }} and platform to youtube.
Set headers in Transcript API Request: X-RapidAPI-Key to {{ $('Primary Config Setup').item.json.rapidapi_key }} and X-RapidAPI-Host to youtube-video-summarizer-gpt-ai.p.rapidapi.com.
Keep the transcript cleanup logic in Normalize Transcript Text to produce clean_transcript for the AI step.

Tip: If transcripts fail to resolve, confirm the YouTube URL format is supported by Derive Video Identifier (either youtu.be or youtube.com/watch?v=).

Step 4: Set Up AI Script and SEO Generation

Generate the new script and SEO metadata using OpenAI, then update the sheet and notify Telegram.

Open Compose Video Script and keep the model set to gpt-4.1-mini.
Ensure Compose Video Script uses the system instruction with {{ $('Primary Config Setup').item.json.output_lang }} and user content that includes {{ $json.clean_transcript }} and {{ $('Extract Telegram Content').item.json.user_desc }}.
Credential Required: Connect your openAiApi credentials in Compose Video Script.
In Create SEO Metadata, keep the JSON schema output settings and set the content to {{ $json.output[0].content[0].text }}.
Credential Required: Connect your openAiApi credentials in Create SEO Metadata.
Open Update Sheet with SEO and set Operation to update, mapping fields like Tags to {{ $json.output[0].content[0].text.tags }}, Title New to {{ $json.output[0].content[0].text.title }}, Transcript New to {{ $('Compose Video Script').item.json.output[0].content[0].text }}, and Description New to {{ $json.output[0].content[0].text.description }}.
Set Sheet Name to {{ $('Primary Config Setup').item.json.sheet_tab }} and Document ID to {{ $('Primary Config Setup').item.json.sheet_id }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Update Sheet with SEO.
Configure Telegram Status Notice with Text set to Transcript : done and Chat ID set to {{ $('Telegram Incoming Trigger').item.json.message.chat.id }}.
Credential Required: Connect your telegramApi credentials in Telegram Status Notice.

⚠️ Common Pitfall: If Create SEO Metadata returns invalid JSON, Update Sheet with SEO will not parse tags, title, or description correctly.

Step 5: Configure the Publishing Pipeline

Scan for ready rows, resolve the Drive file, upload media, and publish to YouTube via Blotato.

Open Secondary Config Setup and set sheet_id to <__PLACEHOLDER_VALUE__Google Sheets Document ID__> and sheet_tab to <__PLACEHOLDER_VALUE__Sheet Tab Name__>.
Configure Scan Sheet for Ready to filter rows where status equals ready, and set Sheet Name to {{ $json.sheet_tab }} and Document ID to {{ $json.sheet_id }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Scan Sheet for Ready.
In Resolve Drive File ID, keep final_google_drive_url mapped to {{ $json['url Heygen'].match(/https:\/\/drive\.google\.com\/file\/d\/([A-Za-z0-9_-]+)/i)[1] }}.
Configure Download Drive File with Operation set to download and File ID set to {{ $json.final_google_drive_url }}.
Credential Required: Connect your googleDriveOAuth2Api credentials in Download Drive File.
In Upload Media to Blotato, set Resource to media and Media URL to =https://drive.google.com/uc?export=download&id={{ $json.final_google_drive_url }}.
Credential Required: Connect your blotatoApi credentials in Upload Media to Blotato.
Configure Publish to YouTube with Platform set to youtube, Post Content Text to {{ $('Scan Sheet for Ready').item.json['Description New'] }}, Post Content Media URLs to {{ $json.url }}, and Post Create Youtube Option Title to {{ $('Scan Sheet for Ready').item.json['Title New'] }}.
Set Post Create Youtube Option Privacy Status to private and Post Create Youtube Option Should Notify Subscribers to false.
Credential Required: Connect your blotatoApi credentials in Publish to YouTube.
Open Mark Sheet Published and set Operation to update, mapping Url to {{ $('Scan Sheet for Ready').item.json.Url }} and status to publish.
Set Sheet Name to {{ $('Secondary Config Setup').item.json.sheet_tab }} and Document ID to {{ $('Secondary Config Setup').item.json.sheet_id }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Mark Sheet Published.

⚠️ Common Pitfall: If Scan Sheet for Ready doesn’t find rows with status = ready, the publishing chain (including Resolve Drive File ID and Publish to YouTube) won’t run.

Step 6: Test and Activate Your Workflow

Run end-to-end tests to confirm each stage works before turning on production execution.

Manually execute the workflow and send a Telegram message to Telegram Incoming Trigger with the YouTube URL on the first line and a short description on the second line.
Verify a new row is created by Append Sheet Entry, and that Update Sheet with SEO fills in Title New, Description New, Tags, and Transcript New.
Confirm Telegram Status Notice sends Transcript : done to the originating chat.
Set a row’s status to ready in the sheet and rerun the publish chain to verify Publish to YouTube creates a private upload.
Check that Mark Sheet Published updates the row to publish after the upload.
When results are correct, switch the workflow to Active for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Watch Out For

Google Sheets OAuth credentials can expire or need specific permissions. If things break, check the n8n credential status and your Google Cloud OAuth consent setup first.
If you’re using Wait logic via “status = ready” and the sheet polling runs too quickly, processing times vary. Bump up the delay or polling interval if the workflow misses rows or downstream nodes run with empty fields.
OpenAI outputs depend heavily on prompts, and the defaults are honestly bland. Add your brand voice, audience level, and formatting rules early or you will keep rewriting the rewrite.

Common Questions

How quickly can I implement this Telegram Sheets automation?

About 30 minutes if your accounts and APIs are ready.

Can non-technical teams implement this Telegram Sheets automation?

Yes, but someone should be comfortable connecting OAuth and API keys. After that, the day-to-day use is just Telegram messages and Google Sheets approvals.

Is n8n free to use for this Telegram Sheets automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API usage and your RapidAPI subscription for transcript access.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

How do I adapt this Telegram Sheets automation solution to my specific challenges?

You can change the output language by editing the output_lang field in the configuration step, then adjust the OpenAI prompts that generate the script and SEO JSON. Many teams also tweak Google Sheets columns (to match their existing tracker) and change the approval rule from “ready” to whatever status name they already use. If you want to repurpose from a different platform, you can swap the transcript fetch step as long as you still provide clean text to the script generator.

Why is my Google Sheets connection failing in this workflow?

Usually it’s expired OAuth access or the wrong Google account connected. Re-authenticate the Google Sheets credential in n8n, confirm the correct spreadsheet is shared with that account, and double-check the Google Cloud project has the Sheets API enabled. If it fails only sometimes, look for quota limits or sheet edits that changed column names the workflow expects.

What’s the capacity of this Telegram Sheets automation solution?

If you self-host n8n, there’s no fixed execution cap (it mostly depends on your server and how often you poll the sheet). On n8n Cloud, your monthly executions depend on your plan. Practically, this workflow is usually limited by transcript/API response time and how many items you run at once, not by n8n itself.

Is this Telegram Sheets automation better than using Zapier or Make?

Often, yes. This workflow mixes multi-step logic (extract ID, fetch transcript, normalize text, generate two AI outputs, write back to Sheets, then wait for approval) and that tends to get expensive or awkward in simpler tools. n8n also gives you a clean self-host option, which is handy when you’re processing lots of content requests. Zapier or Make can still win for lightweight two-app zaps, especially if you never need approval gating. If you’re on the fence, Talk to an automation expert and describe your volume and publishing process.

Once this is in place, your sheet becomes the calm center of the workflow, not another chore. The automation handles the repetitive parts so you can focus on what actually makes the content good.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"meta": {
"instanceId": "a58b044533bceaaefcee6334204e0b0991f5232d8df179f874d5d88a1f6841e6",
"templateId": null,
"templateCredsSetupCompleted": null
},
"name": "Automated Video Script and Publish Flow",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-12191",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 1310,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "819f532a-b957-4689-9ecd-c6c6388ead1f",
"name": "Telegram Incoming Trigger",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
1160,
120
],
"webhookId": "c5c5a9cb-3f9c-49ea-873b-f93298f3049b",
"parameters": {
"updates": [
"message"
],
"additionalFields": []
},
"credentials": {
"telegramApi": {
"id": "mcE3UMMfqqtVOdLe",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "2b3df5ca-3907-49f5-82da-9f8f89b1843a",
"name": "Extract Telegram Content",
"type": "n8n-nodes-base.code",
"position": [
960,
160
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "// Parse Telegram message\nconst messageText = $input.item.json.message.text;\nconst lines = messageText.split('\\n');\n\n// Extract first line as yt_url and second line as user_desc\nconst yt_url = lines[0] || '';\nconst user_desc = lines[1] || '';\n\n// Return the parsed data\nreturn {\n  json: {\n    yt_url: yt_url.trim(),\n    user_desc: user_desc.trim()\n  }\n};"
},
"typeVersion": 2
},
{
"id": "c5213952-cfff-4eef-9e28-31b7a298f72b",
"name": "Primary Config Setup",
"type": "n8n-nodes-base.set",
"position": [
760,
120
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "id-1",
"name": "output_lang",
"type": "string",
"value": "english"
},
{
"id": "id-2",
"name": "sheet_id",
"type": "string",
"value": "<__PLACEHOLDER_VALUE__Google Sheets Document ID__>"
},
{
"id": "id-3",
"name": "sheet_tab",
"type": "string",
"value": "<__PLACEHOLDER_VALUE__Sheet Tab Name__>"
},
{
"id": "id-4",
"name": "rapidapi_key",
"type": "string",
"value": "<__PLACEHOLDER_VALUE__RapidAPI Key__>"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "b571f99b-01e2-45c7-980b-e262a6f1cabb",
"name": "Append Sheet Entry",
"type": "n8n-nodes-base.googleSheets",
"position": [
560,
165
],
"parameters": {
"columns": {
"value": {
"Url": "={{ $('Extract Telegram Content').item.json.yt_url }}",
"Date": "={{ $now.toISO() }}",
"Description": "={{ $('Extract Telegram Content').item.json.user_desc }}"
},
"schema": [
{
"id": "Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Url",
"type": "string",
"display": true,
"required": false,
"displayName": "Url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Date"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "={{ $('Primary Config Setup').item.json.sheet_tab }}"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Primary Config Setup').item.json.sheet_id }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "YlIXFU6zUDsqwmRG",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "a3e3d97e-1d97-4474-a126-0a5380cfc107",
"name": "Derive Video Identifier",
"type": "n8n-nodes-base.code",
"position": [
350,
130
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "// Extract video ID from YouTube URL\nconst url = $input.item.json.Url;\n\nlet videoId = null;\n\nif (url) {\n  // youtu.be format\n  const youtuBeMatch = url.match(/youtu\\.be\\/([^?&]+)/);\n  if (youtuBeMatch) {\n    videoId = youtuBeMatch[1];\n  } else {\n    // youtube.com/watch?v=\n    const youtubeMatch = url.match(/[?&]v=([^?&]+)/);\n    if (youtubeMatch) {\n      videoId = youtubeMatch[1];\n    }\n  }\n}\n\nreturn {\n  json: {\n    videoId\n  }\n};\n"
},
"typeVersion": 2
},
{
"id": "779f43ba-36ee-4fab-b32e-e22d2f8b4237",
"name": "Transcript API Request",
"type": "n8n-nodes-base.httpRequest",
"position": [
140,
180
],
"parameters": {
"url": "https://youtube-video-summarizer-gpt-ai.p.rapidapi.com/api/v1/get-transcript-v2",
"options": [],
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "video_id",
"value": "={{ $json.videoId }}"
},
{
"name": "platform",
"value": "youtube"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "X-RapidAPI-Key",
"value": "={{ $('Primary Config Setup').item.json.rapidapi_key }}"
},
{
"name": "X-RapidAPI-Host",
"value": "youtube-video-summarizer-gpt-ai.p.rapidapi.com"
}
]
}
},
"typeVersion": 4.3
},
{
"id": "24abb009-5ff1-47b5-bfca-09d0726e8461",
"name": "Normalize Transcript Text",
"type": "n8n-nodes-base.code",
"position": [
340,
330
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "// Input attendu: $input.item.json.data.transcripts...\n\nconst data = $input.item.json.data;\nif (!data) throw new Error(\"Champ 'data' introuvable dans l'input.\");\n\nconst transcripts = data.transcripts;\nif (!transcripts || typeof transcripts !== \"object\") {\n  throw new Error(\"Champ 'data.transcripts' introuvable.\");\n}\n\n// 1) D\u00e9terminer la langue (ex: fr_auto) si fournie\nconst preferredLang =\n  (Array.isArray(data.language_code) && data.language_code[0]?.code) || null;\n\n// 2) Chercher le meilleur objet de transcription\nconst langObj =\n  (preferredLang && transcripts[preferredLang]) ||\n  transcripts.fr_auto ||\n  transcripts.en_auto ||\n  transcripts[Object.keys(transcripts)[0]];\n\nif (!langObj) throw new Error(\"Aucune langue de transcription trouv\u00e9e.\");\n\n// 3) Choisir le meilleur tableau (priorit\u00e9: custom > auto > default)\nconst segs =\n  langObj.custom ||\n  langObj.auto ||\n  langObj.default;\n\nif (!Array.isArray(segs)) {\n  throw new Error(\"Aucun tableau de segments trouv\u00e9 (custom/auto/default).\");\n}\n\n// 4) Joindre tous les segments texte\nlet text = segs\n  .map(s => (s?.text ?? \"\").toString().trim())\n  .filter(Boolean)\n  .join(\" \");\n\n// 5) Nettoyage l\u00e9ger + d\u00e9codage des entit\u00e9s HTML fr\u00e9quentes\ntext = text\n  .replace(/&#39;|'/g, \"'\")\n  .replace(/"|"/g, '\"')\n  .replace(/&/g, \"&\")\n  .replace(/\\s+/g, \" \")\n  .trim();\n\nreturn {\n  json: {\n    videoId: data.videoId,\n    language: preferredLang || null,\n    clean_transcript: text\n  }\n};\n"
},
"typeVersion": 2
},
{
"id": "69de9692-72b4-48bc-bf1d-e4b799308d22",
"name": "Compose Video Script",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
560,
290
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "GPT-4.1-MINI"
},
"options": [],
"responses": {
"values": [
{
"role": "system",
"content": "=You are a professional video script writer. Based on the provided transcript and user requirements, write a NEW original video script in {{ $('Primary Config Setup').item.json.output_lang }} language. Include: compelling hook, clear outline, well-structured sections, and strong call-to-action."
},
{
"content": "={{ $json.clean_transcript }}\n\nUser requirements and Adapt the original transcript to the new topic: {{ $('Extract Telegram Content').item.json.user_desc }}\n\n### CRITICAL REWRITE RULES\n1. Keep the **exact same structure and flow** \u2014 same order of ideas, same pacing, same emotional progression with use differnt\nword choices so it doesn't look like a copy of the original transcript.\n2. Match the **original length within \u00b110%** of word count.\n3. Maintain the **same emotional tone and rhythm** \u2014 if the original sounds reflective, passionate, or urgent, match that.\n4. Preserve **the hook style** in the first 30 seconds \u2014 same energy, different context.\n5. Maintain **pauses, repetitions, or filler words** (\"I... I mean...\", \"you know\") naturally \u2014 not copy-pasted.\n6. Replace **specific details, names, and examples** with context-relevant equivalents from the Q&A.\n7. Keep **CTAs and closing structure** but adapt them to the new niche or audience.\n8. Write in a **natural, conversational style** \u2014 as if it\u2019s spoken narration.\n9. Do **not** make it longer or add explanations. \nNote: I want the script to be no longer than 5 minutes.\n\n### LANGUAGE AND STYLE STANDARDS\n10. Rephrase the **opening line** completely while keeping the same emotional impact.\n11. Do **not reuse more than 3\u20134 consecutive words** from the original (except common filler words).\n12. **Vary sentence structure** \u2014 if the original says \u201cI\u2019m 40 and I wasted my life,\u201d write something like \u201cI\u2019m 40 now, and I feel like I threw my best years away.\u201d\n13. Replace all **nouns, analogies, and examples** with niche-appropriate ones.\n14. Keep the **filler rhythm** (e.g. \u201cI, I, I\u2026\u201d or \u201cand, and, and\u2026\u201d) but write them freshly.\n15. The goal: **same emotion, same journey, same rhythm \u2014 but different story and context.**\n\nOUTPUT:\nReturn **only** the rewritten script.\nNo meta commentary, no explanations \u2014 just the new script, ready to paste into HeyGen.\nNote: I want the script to be no longer than 5 minutes."
}
]
},
"builtInTools": []
},
"credentials": {
"openAiApi": {
"id": "QmtwfFk8iBkuCXOX",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "2bc9719f-a068-4581-99eb-505e73897c17",
"name": "Create SEO Metadata",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
780,
340
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "GPT-4.1-MINI"
},
"options": {
"textFormat": {
"textOptions": {
"type": "json_schema",
"schema": "{\n  \"type\": \"object\",\n  \"properties\": {\n    \"title\": {\n      \"type\": \"string\",\n      \"description\": \"SEO title, maximum 70 characters\"\n    },\n    \"description\": {\n      \"type\": \"string\",\n      \"description\": \"SEO description, compelling and keyword-rich\"\n    },\n    \"tags\": {\n      \"type\": \"array\",\n      \"description\": \"Exactly 15 SEO tags\",\n      \"items\": {\n        \"type\": \"string\"\n      },\n      \"minItems\": 15,\n      \"maxItems\": 15\n    }\n  },\n  \"required\": [\"title\", \"description\", \"tags\"],\n  \"additionalProperties\": false\n}\n"
}
},
"instructions": "=You are an SEO expert.\n\nBased ONLY on the provided video script, generate SEO metadata.\n\nCRITICAL RULES:\n- Output MUST be valid JSON\n- NO text outside JSON\n- NO markdown\n- NO explanations\n\nSchema:\n{\n  \"title\": \"string (max 70 characters)\",\n  \"description\": \"string\",\n  \"tags\": [\"string\", \"...\"] // exactly 15 items\n}\n\nGenerate the JSON now.\n"
},
"responses": {
"values": [
{
"content": "={{ $json.output[0].content[0].text }}"
}
]
},
"builtInTools": []
},
"credentials": {
"openAiApi": {
"id": "QmtwfFk8iBkuCXOX",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "aac04d00-1c36-45bf-9ebb-fc786c5659a1",
"name": "Update Sheet with SEO",
"type": "n8n-nodes-base.googleSheets",
"position": [
1000,
290
],
"parameters": {
"columns": {
"value": {
"Url": "={{ $('Extract Telegram Content').item.json.yt_url }}",
"Date": "={{ $now.toISO() }}",
"Tags": "={{ $json.output[0].content[0].text.tags }}",
"Title New": "={{ $json.output[0].content[0].text.title }}",
"row_number": 0,
"Transcript New": "={{ $('Compose Video Script').item.json.output[0].content[0].text }}",
"Description New": "={{ $json.output[0].content[0].text.description }}"
},
"schema": [
{
"id": "Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title New",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Title New",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Transcript New",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Transcript New",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description New",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Description New",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tags",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Tags",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Url"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "={{ $('Primary Config Setup').item.json.sheet_tab }}"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Primary Config Setup').item.json.sheet_id }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "YlIXFU6zUDsqwmRG",
"name": ""
}
},
"typeVersion": 4.7,
"alwaysOutputData": true
},
{
"id": "e7c32990-dccf-47b4-9810-68be4a9a68ad",
"name": "Telegram Status Notice",
"type": "n8n-nodes-base.telegram",
"position": [
1210,
340
],
"webhookId": "b558622d-f8f7-478b-84b6-1eb9a655968a",
"parameters": {
"text": "=Transcript : done",
"chatId": "={{ $('Telegram Incoming Trigger').item.json.message.chat.id }}",
"additionalFields": []
},
"credentials": {
"telegramApi": {
"id": "mcE3UMMfqqtVOdLe",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "0bbcd16d-0c7b-4614-b630-000142f27ce4",
"name": "Secondary Config Setup",
"type": "n8n-nodes-base.set",
"position": [
1130,
510
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "id-2",
"name": "sheet_id",
"type": "string",
"value": "<__PLACEHOLDER_VALUE__Google Sheets Document ID__>"
},
{
"id": "id-3",
"name": "sheet_tab",
"type": "string",
"value": "<__PLACEHOLDER_VALUE__Sheet Tab Name__>"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "457bff7d-2ba2-40bb-aed2-34b32f1bb7a6",
"name": "Scan Sheet for Ready",
"type": "n8n-nodes-base.googleSheets",
"position": [
920,
560
],
"parameters": {
"options": [],
"filtersUI": {
"values": [
{
"lookupValue": "ready",
"lookupColumn": "status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "name",
"value": "={{ $json.sheet_tab }}"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.sheet_id }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "YlIXFU6zUDsqwmRG",
"name": ""
}
},
"typeVersion": 4.7,
"alwaysOutputData": true
},
{
"id": "2b231b15-61c4-472b-a3fd-93f9d5e9225e",
"name": "Resolve Drive File ID",
"type": "n8n-nodes-base.set",
"position": [
720,
510
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "a1750d20-2f6e-4826-80b8-654d0985120d",
"name": "final_google_drive_url",
"type": "string",
"value": "={{ $json['url Heygen'].match(/https:\\/\\/drive\\.google\\.com\\/file\\/d\\/([A-Za-z0-9_-]+)/i)[1] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "a1773b3f-3a7e-4527-ae42-994feb96e7ea",
"name": "Download Drive File",
"type": "n8n-nodes-base.googleDrive",
"position": [
500,
570
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.final_google_drive_url }}"
},
"options": [],
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "odf7JAwyqVFVZBhQ",
"name": ""
}
},
"typeVersion": 3
},
{
"id": "a226989b-7e49-41fa-9f70-4ae90da42ef6",
"name": "Upload Media to Blotato",
"type": "@blotato/n8n-nodes-blotato.blotato",
"position": [
300,
510
],
"parameters": {
"mediaUrl": "=https://drive.google.com/uc?export=download&id={{ $json.final_google_drive_url }}",
"resource": "media"
},
"credentials": {
"blotatoApi": {
"id": "wozsYJYLfCZO37j8",
"name": ""
}
},
"typeVersion": 2
},
{
"id": "f7577bf3-db6a-46cb-8886-ac3ad16d349a",
"name": "Publish to YouTube",
"type": "@blotato/n8n-nodes-blotato.blotato",
"position": [
0,
570
],
"parameters": {
"options": [],
"platform": "youtube",
"accountId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "YouTube Account"
},
"postContentText": "={{ $('Scan Sheet for Ready').item.json['Description New'] }}",
"postContentMediaUrls": "={{ $json.url }}",
"postCreateYoutubeOptionTitle": "={{ $('Scan Sheet for Ready').item.json['Title New'] }}",
"postCreateYoutubeOptionPrivacyStatus": "private",
"postCreateYoutubeOptionShouldNotifySubscribers": false
},
"credentials": {
"blotatoApi": {
"id": "wozsYJYLfCZO37j8",
"name": ""
}
},
"typeVersion": 2
},
{
"id": "784911d5-6c25-47ad-a84c-b499b448f81d",
"name": "Mark Sheet Published",
"type": "n8n-nodes-base.googleSheets",
"position": [
240,
710
],
"parameters": {
"columns": {
"value": {
"Url": "={{ $('Scan Sheet for Ready').item.json.Url }}",
"status": "publish"
},
"schema": [
{
"id": "Date",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title New",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Title New",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Transcript New",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Transcript New",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description New",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Description New",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tags",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Tags",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "url Heygen",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "url Heygen",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Url"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "={{ $('Secondary Config Setup').item.json.sheet_tab }}"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Secondary Config Setup').item.json.sheet_id }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "YlIXFU6zUDsqwmRG",
"name": ""
}
},
"typeVersion": 4.7,
"alwaysOutputData": true
}
],
"active": false,
"pinData": [],
"settings": {
"availableInMCP": false,
"executionOrder": "v1"
},
"versionId": null,
"connections": {
"Publish to YouTube": {
"main": [
[
{
"node": "Mark Sheet Published",
"type": "main",
"index": 0
}
]
]
},
"Normalize Transcript Text": {
"main": [
[
{
"node": "Compose Video Script",
"type": "main",
"index": 0
}
]
]
},
"Create SEO Metadata": {
"main": [
[
{
"node": "Update Sheet with SEO",
"type": "main",
"index": 0
}
]
]
},
"Derive Video Identifier": {
"main": [
[
{
"node": "Transcript API Request",
"type": "main",
"index": 0
}
]
]
},
"Download Drive File": {
"main": [
[
{
"node": "Upload Media to Blotato",
"type": "main",
"index": 0
}
]
]
},
"Compose Video Script": {
"main": [
[
{
"node": "Create SEO Metadata",
"type": "main",
"index": 0
}
]
]
},
"Telegram Incoming Trigger": {
"main": [
[
{
"node": "Extract Telegram Content",
"type": "main",
"index": 0
}
]
]
},
"Scan Sheet for Ready": {
"main": [
[
{
"node": "Resolve Drive File ID",
"type": "main",
"index": 0
}
]
]
},
"Resolve Drive File ID": {
"main": [
[
{
"node": "Download Drive File",
"type": "main",
"index": 0
}
]
]
},
"Transcript API Request": {
"main": [
[
{
"node": "Normalize Transcript Text",
"type": "main",
"index": 0
}
]
]
},
"Update Sheet with SEO": {
"main": [
[
{
"node": "Telegram Status Notice",
"type": "main",
"index": 0
}
]
]
},
"Extract Telegram Content": {
"main": [
[
{
"node": "Primary Config Setup",
"type": "main",
"index": 0
}
]
]
},
"Primary Config Setup": {
"main": [
[
{
"node": "Append Sheet Entry",
"type": "main",
"index": 0
}
]
]
},
"Append Sheet Entry": {
"main": [
[
{
"node": "Derive Video Identifier",
"type": "main",
"index": 0
}
]
]
},
"Upload Media to Blotato": {
"main": [
[
{
"node": "Publish to YouTube",
"type": "main",
"index": 0
}
]
]
},
"Secondary Config Setup": {
"main": [
[
{
"node": "Scan Sheet for Ready",
"type": "main",
"index": 0
}
]
]
}
}
}