Automatisierte Veröffentlichung von YouTube-Videos aus Drive mit integrierter GPT- und Gemini-Metadatenerstellung

• •Telegram Bot Token
• •Google Drive API-Anmeldedaten
• •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
• •OpenAI API Key
• •Google Gemini API Key

{
  "meta": {
    "instanceId": "bb58de5a5031a6915d56b6838fb3b3b84efbdb51f48c823505ab47d6641ee185",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "d343874d-2389-40c9-ab46-47f02a7ea77d",
      "name": "Neues Video herunterladen",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        272,
        -128
      ],
      "parameters": {
        "fileId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $('New Video?').item.json.id }}"
        },
        "options": {},
        "operation": "download"
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "id": "GxtbT8g7MSIFmjgF",
          "name": "Google Drive account 2"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "84c6f604-08f9-407c-9935-b4e8c9b03add",
      "name": "Neues Video?",
      "type": "n8n-nodes-base.googleDriveTrigger",
      "position": [
        -928,
        -208
      ],
      "parameters": {
        "event": "fileCreated",
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "triggerOn": "specificFolder",
        "folderToWatch": {
          "__rl": true,
          "mode": "list",
          "value": "1vAZ6zUlbqqaFv2_sPZXx_yeNQcjrfcvy",
          "cachedResultUrl": "https://drive.google.com/drive/folders/1vAZ6zUlbqqaFv2_sPZXx_yeNQcjrfcvy",
          "cachedResultName": "All Motivatioanl video"
        }
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "id": "GxtbT8g7MSIFmjgF",
          "name": "Google Drive account 2"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "28445d38-79c3-4d7c-8aaa-9a30ee298bfe",
      "name": "Beschreibung erstellen",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -624,
        -224
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-nano",
          "cachedResultName": "GPT-4.1-NANO"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "role": "system",
              "content": "You are a professional copywriter.\nYou receive the transcript of an economics-related video.\n\nYour task is to write a detailed but concise summary (in paragraphs) about the content of the video. The output will be used as the YouTube video description.\n\n✍️ Writing Guidelines:\n\nStart with an engaging opening like:\n“In this video…” or “In this episode…”\n\nWrite entirely from my perspective, using phrases such as “in my opinion,” “in my view,” “I explain why,” or “I discuss how.”\n\nNever say phrases like “the speaker says,” “they mention,” or “in this episode, I learn.” Everything must sound like my own explanation.\n\nUse clear, assertive, and confident statements — avoid uncertain terms such as “might,” “could,” “possibly,” or “maybe.”\n\nInclude 2–4 relevant emojis to make the tone more dynamic and expressive.\n\nEnd with 2–5 broad, relevant hashtags (e.g., #economics #business #money #success #motivation).\n\n⚙️ Input:\n\nThe transcript will come from the uploaded video (added separately).\n\n🎯 Output:\n\nA polished, first-person YouTube description that summarizes the video’s key economic or motivational insights — confident, engaging, and ready to publish."
            },
            {
              "content": "=Here is the Scence:{{ $json.originalFilename }}"
            }
          ]
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "FsX9JrZqhSEHtkmm",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.7
    },
    {
      "id": "b0cbd1ba-77ca-4874-bdfd-cd76c2a56892",
      "name": "2.5FlashPrev",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        -352,
        -64
      ],
      "parameters": {
        "options": {},
        "modelName": "models/gemini-2.0-flash"
      },
      "credentials": {
        "googlePalmApi": {
          "id": "xcpoBH67frp9oHY2",
          "name": "Google Gemini(PaLM) Api account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "0b75f8c6-64a2-447e-bae4-05c5d4e8a0c3",
      "name": "YT-Tags",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -352,
        -224
      ],
      "parameters": {
        "text": "=Now follows the actual topic/transcript. Give me the YouTube tags for it:\n{{ $json.message.content }}",
        "options": {
          "systemMessage": "You are a YouTube SEO and motivational content specialist.\nYour task is to generate only YouTube tags (no description, no hashtags) based on the given video topic or transcript.\n\n✍️ Guidelines:\n\nOutput only comma-separated tags — no extra text, no formatting.\n\nTags should combine motivation, mindset, life lessons, money, success, and economics themes depending on the input.\n\nFocus on high-performing, searchable keywords that match motivational and economic growth content.\n\nInclude a mix of broad and specific tags (e.g., motivation, mindset, personal growth, economics, success, wealth, discipline, resilience).\n\nKeep total tags around 20–30 per response.\n\n⚙️ Input:\n\nVideo topic or transcript (added separately).\n\n🎯 Output:\n\nOnly a clean list of YouTube tags, comma-separated — no hashtags, no extra commentary."
        },
        "promptType": "define"
      },
      "typeVersion": 1.9
    },
    {
      "id": "2d1d7fb2-95e0-4190-a7fc-4947d097745a",
      "name": "YT-Titel",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -80,
        -224
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-nano",
          "cachedResultName": "GPT-4.1-NANO"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "role": "system",
              "content": "You are a professional copywriter for SEO-optimized YouTube titles."
            },
            {
              "content": "=Write me a suitable SEO YouTube title for the transcript of the following video transcript. Only the title, nothing else. Max 40 characters, so keep it short."
            }
          ]
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "FsX9JrZqhSEHtkmm",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.7
    },
    {
      "id": "ddc63e6b-8cff-4949-b97a-747d481c2253",
      "name": "Auf youtube hochladen",
      "type": "n8n-nodes-base.youTube",
      "position": [
        -592,
        224
      ],
      "parameters": {
        "title": "={{ $json.message.content }}",
        "options": {
          "description": "=🚀 Self-hosted n8n setup — 100% working like n8n.io cloud.\nHosted on your server, fully configured & ready to automate.\nVisit: Evalinfo.com\nWhatsApp: +923250754569 | +923321997882\n\n{{ $('Create Description').item.json.message.content }}\n\n\n#myreelgen #evalinfo #muhammadnouman #ai #aiagents #n8n #selfhostedn8n\n\n{{ $('YT Tags').item.json.output }}",
          "privacyStatus": "public"
        },
        "resource": "video",
        "operation": "upload",
        "categoryId": "22",
        "regionCode": "IN",
        "binaryProperty": "=data"
      },
      "credentials": {
        "youTubeOAuth2Api": {
          "id": "13qYzNIjCJpMx9GK",
          "name": "Eval info"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "e352184f-beb2-4e07-9eb3-d7aaafd83b6a",
      "name": "Notiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1008,
        -368
      ],
      "parameters": {
        "color": 6,
        "width": 352,
        "height": 416,
        "content": "## Get video from Drive Folder\n**Double click** to edit me. [Guide](https://docs.n8n.io/workflows/sticky-notes/)"
      },
      "typeVersion": 1
    },
    {
      "id": "ef946b76-9232-4d4e-b970-f8f24b38a336",
      "name": "Notiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -640,
        -368
      ],
      "parameters": {
        "color": 3,
        "width": 816,
        "height": 416,
        "content": "## Generate Meta data \n**Double click** to edit me. [Guide](https://docs.n8n.io/workflows/sticky-notes/)"
      },
      "typeVersion": 1
    },
    {
      "id": "59aa6d9e-9e07-414d-9159-676f365c9a8e",
      "name": "Notiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        192,
        -368
      ],
      "parameters": {
        "color": 3,
        "width": 224,
        "height": 416,
        "content": "## Download Video  \n**Double click** to edit me. [Guide](https://docs.n8n.io/workflows/sticky-notes/)"
      },
      "typeVersion": 1
    },
    {
      "id": "5281a05f-2357-4881-a996-ac9d9dc17c19",
      "name": "Notiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -640,
        64
      ],
      "parameters": {
        "color": 3,
        "width": 816,
        "height": 416,
        "content": "## Upload Video\n**Double click** to edit me. [Guide](https://docs.n8n.io/workflows/sticky-notes/)"
      },
      "typeVersion": 1
    },
    {
      "id": "e631fb6d-a7a3-485f-a7b8-c535275cb9f7",
      "name": "Notiz4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        192,
        64
      ],
      "parameters": {
        "color": 3,
        "width": 224,
        "height": 416,
        "content": "## Delete Video  \n**Double click** to edit me. [Guide](https://docs.n8n.io/workflows/sticky-notes/)"
      },
      "typeVersion": 1
    },
    {
      "id": "5e6af056-bd53-4a85-a10f-c30416a039a0",
      "name": "Notiz5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        432,
        64
      ],
      "parameters": {
        "color": 6,
        "width": 352,
        "height": 416,
        "content": "## Send Notfication\n**Double click** to edit me. [Guide](https://docs.n8n.io/workflows/sticky-notes/)"
      },
      "typeVersion": 1
    },
    {
      "id": "5d150d6e-8d28-4503-9565-cd42fc08d4ed",
      "name": "Video aus Upload-Ordner löschen1",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        256,
        224
      ],
      "parameters": {
        "fileId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $('New Video?').item.json.id }}"
        },
        "options": {},
        "operation": "deleteFile"
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "id": "GxtbT8g7MSIFmjgF",
          "name": "Google Drive account 2"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "3a7f4655-5fef-4209-93f8-e50fa3fecb44",
      "name": "Textnachricht senden",
      "type": "n8n-nodes-base.telegram",
      "position": [
        512,
        224
      ],
      "webhookId": "6544dd10-e8a9-47f2-8c98-5c0c3a839928",
      "parameters": {
        "text": "=🎬 Your video has been uploaded to YouTube channel **\"Eval Info\"!**\n\n• 🆔 Upload ID: {{ $('Upload to youtube').item.json.uploadId }}\n• 🗑️ Drive file deleted: {{ $json.success ? '✅ Yes' : '❌ No' }}\n• 🎯 Title: {{ $('YT Title').item.json.message.content }}\n",
        "chatId": "6727168479",
        "additionalFields": {}
      },
      "credentials": {
        "telegramApi": {
          "id": "2cLY9VvUkHDGd3Yx",
          "name": "uploaded to YT Evaal info"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "223440f4-14e1-4d87-914e-a148ff75639f",
      "name": "Auf Instagram posten",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -608,
        640
      ],
      "parameters": {
        "url": "https://graph.facebook.com/v19.0/<YOUR PAGE ID HERE>/media",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "contentType": "form-urlencoded",
        "authentication": "predefinedCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "image_url",
              "value": "<YOUR IMAGE URL HERE>"
            },
            {
              "name": "caption",
              "value": "<YOUR CAPTION HERE>"
            }
          ]
        },
        "nodeCredentialType": "facebookGraphApi"
      },
      "typeVersion": 4.2
    },
    {
      "id": "952eb838-7b36-4169-9c97-1660a4d7c139",
      "name": "instagram-Beitrag veröffentlichen",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -272,
        640
      ],
      "parameters": {
        "url": "https://graph.facebook.com/v19.0/17841404935066235/media_publish",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "contentType": "form-urlencoded",
        "authentication": "predefinedCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "creation_id",
              "value": "={{ $json.id }}"
            }
          ]
        },
        "nodeCredentialType": "facebookGraphApi"
      },
      "typeVersion": 4.2
    },
    {
      "id": "6663b262-9207-4d34-8470-a60f9e783294",
      "name": "Auf Facebook posten",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        240,
        640
      ],
      "parameters": {
        "url": "https://graph.facebook.com/v19.0/266271423823110/photos",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "contentType": "form-urlencoded",
        "authentication": "predefinedCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "url",
              "value": "https://images.pexels.com/photos/5475816/pexels-photo-5475816.jpeg?auto=compress&cs=tinysrgb&fit=crop&h=627&w=1200"
            },
            {
              "name": "caption",
              "value": "This is the caption for the post"
            },
            {
              "name": "access_token",
              "value": "={{ $json.data[0].access_token }}"
            }
          ]
        },
        "nodeCredentialType": "facebookGraphApi"
      },
      "typeVersion": 4.2
    },
    {
      "id": "a94f3725-1eaf-4491-8958-d812f83fe35b",
      "name": "System-Token zum Abruf des Seiten-Tokens verwenden",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -96,
        640
      ],
      "parameters": {
        "url": "https://graph.facebook.com/v19.0/me/accounts",
        "options": {},
        "authentication": "predefinedCredentialType",
        "nodeCredentialType": "facebookGraphApi"
      },
      "typeVersion": 4.2
    },
    {
      "id": "22179199-f09d-4456-bf1c-45bb7a2531f3",
      "name": "Korrektes Seiten-Token abrufen",
      "type": "n8n-nodes-base.code",
      "position": [
        64,
        640
      ],
      "parameters": {
        "jsCode": "const page = $json.data.find(p => p.id === '266271423823110');\nreturn [{ json: { access_token: page.access_token } }];\n"
      },
      "typeVersion": 2
    },
    {
      "id": "f3f681e0-cea6-48ce-9891-c7a4c62dcaee",
      "name": "2 Sekunden warten",
      "type": "n8n-nodes-base.wait",
      "position": [
        -448,
        640
      ],
      "webhookId": "c40b180e-016c-4648-898a-5942b8a9b00d",
      "parameters": {
        "amount": 2
      },
      "typeVersion": 1.1
    },
    {
      "id": "7caacc2c-fcf6-4b39-ad05-81235611e68f",
      "name": "Notiz8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -656,
        496
      ],
      "parameters": {
        "color": 5,
        "width": 1072,
        "height": 360,
        "content": "Using the permanant never expire token"
      },
      "typeVersion": 1
    },
    {
      "id": "0541f012-b217-4854-9b11-f04636165f20",
      "name": "Notiz9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1360,
        112
      ],
      "parameters": {
        "width": 680,
        "height": 1220,
        "content": " How to Create a Permanent System User Token (Recommended)\n\nThis token doesn’t expire and is best for automation use cases\n\n1. Verify Your Business\n\nGo to https://business.facebook.com/settings/info\n\nComplete business verification under Business Info tab\n\nSubmit your business documents and wait for approval (Sometimes you just have to submit an EIN/Tax-ID.\n\nApproval can take 1-5 Business days\n\nOnce Approved do the following.\n\n2. Create a System User\n\nIn Business Settings\n\nGo to System Users > Click Add\n\nAssign a name (e.g. n8n-bot) and select Admin access\n\n3. Assign Assets to System User\n\nIn the same System User view, assign:\n\nYour Facebook Page (with Full Control)\n\nYour Instagram Account (linked via Page)\n\nYour App\n\n4. Generate a Token\n\nClick Generate Token\n\nSelect your App\n\nSet expiration to Never\n\nGrant these permissions:\n\npages_show_list\n\npages_read_engagement\n\npages_manage_posts\n\ninstagram_basic\n\ninstagram_content_publish\n\n-If instagram_content_publish is not visible, you may need to request it via App Review under the App dashboard.\n\n5. Use This Token\n\nStore it in the Facebook Graph API\n\n"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "0b75f8c6-64a2-447e-bae4-05c5d4e8a0c3": {
      "main": [
        [
          {
            "node": "2d1d7fb2-95e0-4190-a7fc-4947d097745a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2d1d7fb2-95e0-4190-a7fc-4947d097745a": {
      "main": [
        [
          {
            "node": "d343874d-2389-40c9-ab46-47f02a7ea77d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "84c6f604-08f9-407c-9935-b4e8c9b03add": {
      "main": [
        [
          {
            "node": "28445d38-79c3-4d7c-8aaa-9a30ee298bfe",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b0cbd1ba-77ca-4874-bdfd-cd76c2a56892": {
      "ai_languageModel": [
        [
          {
            "node": "0b75f8c6-64a2-447e-bae4-05c5d4e8a0c3",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "f3f681e0-cea6-48ce-9891-c7a4c62dcaee": {
      "main": [
        [
          {
            "node": "952eb838-7b36-4169-9c97-1660a4d7c139",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "223440f4-14e1-4d87-914e-a148ff75639f": {
      "main": [
        [
          {
            "node": "f3f681e0-cea6-48ce-9891-c7a4c62dcaee",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ddc63e6b-8cff-4949-b97a-747d481c2253": {
      "main": [
        [
          {
            "node": "5d150d6e-8d28-4503-9565-cd42fc08d4ed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "28445d38-79c3-4d7c-8aaa-9a30ee298bfe": {
      "main": [
        [
          {
            "node": "0b75f8c6-64a2-447e-bae4-05c5d4e8a0c3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d343874d-2389-40c9-ab46-47f02a7ea77d": {
      "main": [
        [
          {
            "node": "ddc63e6b-8cff-4949-b97a-747d481c2253",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3a7f4655-5fef-4209-93f8-e50fa3fecb44": {
      "main": [
        []
      ]
    },
    "22179199-f09d-4456-bf1c-45bb7a2531f3": {
      "main": [
        [
          {
            "node": "6663b262-9207-4d34-8470-a60f9e783294",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "952eb838-7b36-4169-9c97-1660a4d7c139": {
      "main": [
        [
          {
            "node": "a94f3725-1eaf-4491-8958-d812f83fe35b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5d150d6e-8d28-4503-9565-cd42fc08d4ed": {
      "main": [
        [
          {
            "node": "3a7f4655-5fef-4209-93f8-e50fa3fecb44",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a94f3725-1eaf-4491-8958-d812f83fe35b": {
      "main": [
        [
          {
            "node": "22179199-f09d-4456-bf1c-45bb7a2531f3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}