AI-Virtual-Character-Videos mit HeyGen und Google Sheets Integration generieren

Fortgeschritten

Dies ist ein AI, Marketing-Bereich Automatisierungsworkflow mit 11 Nodes. Hauptsächlich werden HttpRequest, GoogleSheets, ManualTrigger und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung. Mit HeyGen und Google Sheets Integration KI-Virtual-Character-Videos erstellen

Voraussetzungen
  • Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
  • Google Sheets API-Anmeldedaten
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "meta": {
    "instanceId": "de145373c7ed10b34e35f8898916fdf37d53e7782c6f05bbe7b831e31042db96",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "43bde8be-dd80-43d5-93fa-bbed038d1fc0",
      "name": "Bei Klick auf 'Workflow testen'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -660,
        80
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6530a519-264d-41ef-87db-280c425f481f",
      "name": "Video abrufen",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        440,
        80
      ],
      "parameters": {
        "url": "https://api.heygen.com/v2/avatar/avatar_id/details",
        "options": {},
        "sendHeaders": true,
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "headerParameters": {
          "parameters": [
            {
              "name": "video_id",
              "value": "={{ $json.data.video_id }}"
            }
          ]
        }
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "hHUxPUb01H0Ij0se",
          "name": "Header Auth account"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "dcc4ed71-81da-4fe2-a865-cdda8a81ab2d",
      "name": "Video erstellen",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        80,
        80
      ],
      "parameters": {
        "url": "https://api.heygen.com/v2/video/generate",
        "method": "POST",
        "options": {},
        "jsonBody": "{\n  \"video_inputs\": [\n    {\n      \"character\": {\n        \"type\": \"avatar\",\n        \"avatar_id\": \"84c521ab0e4b4527a33423e1b813ea0c\",\n        \"avatar_style\": \"normal\"\n      },\n      \"voice\": {\n        \"type\": \"text\",\n        \"input_text\": \"hey, this is sagar and it is my avatar\",\n        \"voice_id\": \"2aa0fed15bbf424bb3a4f9c9537ab058\",\n        \"speed\": 1.1\n      }\n    }\n  ],\n  \"dimension\": {\n    \"width\": 1280,\n    \"height\": 720\n  }\n}\n",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "headerParameters": {
          "parameters": [
            {
              "name": "accept",
              "value": "application/json"
            }
          ]
        }
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "hHUxPUb01H0Ij0se",
          "name": "Header Auth account"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "5c6f7c73-3301-4e62-9cc2-1a4181e03fd4",
      "name": "Google Tabellen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -280,
        80
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xqIDGIYCCHlZyfWYMMHBisz4YggRKycygWzBfYaYI08/edit#gid=0",
          "cachedResultName": "New Script Uploaded"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1xqIDGIYCCHlZyfWYMMHBisz4YggRKycygWzBfYaYI08",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xqIDGIYCCHlZyfWYMMHBisz4YggRKycygWzBfYaYI08/edit?usp=drivesdk",
          "cachedResultName": "New Script"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "K7LQI1nT7J8NyxSW",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "3f5f9b1d-7854-4814-b0af-8b630032e00f",
      "name": "Google Tabellen1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        820,
        80
      ],
      "parameters": {
        "columns": {
          "value": {
            "Final Video": "={{ $json.data.video_url }}"
          },
          "schema": [
            {
              "id": "New Script",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "New Script",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Final Video",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Final Video",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "New Script"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xqIDGIYCCHlZyfWYMMHBisz4YggRKycygWzBfYaYI08/edit#gid=0",
          "cachedResultName": "New Script Uploaded"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1xqIDGIYCCHlZyfWYMMHBisz4YggRKycygWzBfYaYI08",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xqIDGIYCCHlZyfWYMMHBisz4YggRKycygWzBfYaYI08/edit?usp=drivesdk",
          "cachedResultName": "New Script"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "K7LQI1nT7J8NyxSW",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "eb08b935-e956-4756-9fd5-b0a196524535",
      "name": "Notizzettel1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -720,
        260
      ],
      "parameters": {
        "color": 4,
        "width": 255,
        "height": 239,
        "content": "👈\nSet up Manual Trigger Node.\n\nthis trigger will be activated.\n\nFollow the steps (YouTube video):\nhttps://youtu.be/llm60n03x3c?si=vO4jU6EZms-ZpDvL"
      },
      "typeVersion": 1
    },
    {
      "id": "b372533b-4de6-48d1-bb53-3a1a364da590",
      "name": "Notizzettel3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -720,
        -100
      ],
      "parameters": {
        "color": 3,
        "width": 272,
        "height": 140,
        "content": "### Your AI Avatar Videos Automation Agent with Google Sheets, HTTP Nodes (Easy to set-up in 5 steps only)"
      },
      "typeVersion": 1
    },
    {
      "id": "f0de3751-d50f-4ca6-b2e4-0e9c38d21557",
      "name": "Notizzettel5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        260
      ],
      "parameters": {
        "color": 5,
        "width": 275,
        "height": 359,
        "content": "👈\nSet up HTTP Node.\n\nMethod : Post\nURL : https://api.heygen.com/v2/video/generate\n\nFor Set up Authentication credentials (open & check the node parameters.)\n\nThis node will create AI Video with your video id and voice id using json code.\n\nFollow the steps (YouTube video):\nhttps://youtu.be/llm60n03x3c?si=vO4jU6EZms-ZpDvL"
      },
      "typeVersion": 1
    },
    {
      "id": "cab8d398-fe34-4f64-b325-fe6ce1ad8406",
      "name": "Notizzettel6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -360,
        260
      ],
      "parameters": {
        "width": 275,
        "height": 279,
        "content": "👈\nSet up Google Sheets Node.\n\nSet up credentials.\n\nCreate a new sheet in Google Sheets (e.g., AI Avatar Script).\n\nCreate 2 columns: Script/voice text, Final Video Link.\n\nFollow the steps (YouTube video):\nhttps://youtu.be/llm60n03x3c?si=vO4jU6EZms-ZpDvL"
      },
      "typeVersion": 1
    },
    {
      "id": "e046ae61-1f98-4eff-8a6a-d445623520d7",
      "name": "Notizzettel9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        360,
        260
      ],
      "parameters": {
        "color": 3,
        "width": 275,
        "height": 359,
        "content": "👈\nSet up HTTP Node.\n\nuse given cURL json code.\n\nMethod : Get\nURL : https://api.heygen.com/v2/avatar/avatar_id/details\n\nFor Set up Authentication credentials (open & check the node parameters.)\n\nput parameter name: video-id  & paste value: video_id from past http node. his node will create AI Video with your video id and voice id using json code.\n\n\nOutput : Your AI Avatar Video Link\nFollow the steps (YouTube video): https://youtu.be/llm60n03x3c?si=vO4jU6EZms-ZpDvL\n"
      },
      "typeVersion": 1
    },
    {
      "id": "99a5275c-3f72-4a75-94eb-276e620a6545",
      "name": "Notizzettel10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        740,
        260
      ],
      "parameters": {
        "width": 275,
        "height": 359,
        "content": "👈\nSet up Google Sheets Node.\n\nSet up credentials.\n\nuse given sheet in Google Sheets (e.g., AI Avatar Script).\n\nconnect the sheet parametr with Your AI Avatar Video Link in the - Final Video Link.\n\nOutput your AI Avatar video link will be uploaded in your google sheet - just open the sheet and download the video.\nFollow the steps (YouTube video):\nhttps://youtu.be/llm60n03x3c?si=vO4jU6EZms-ZpDvL"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "6530a519-264d-41ef-87db-280c425f481f": {
      "main": [
        [
          {
            "node": "Google Sheets1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets": {
      "main": [
        [
          {
            "node": "dcc4ed71-81da-4fe2-a865-cdda8a81ab2d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "dcc4ed71-81da-4fe2-a865-cdda8a81ab2d": {
      "main": [
        [
          {
            "node": "6530a519-264d-41ef-87db-280c425f481f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "43bde8be-dd80-43d5-93fa-bbed038d1fc0": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Fortgeschritten - Künstliche Intelligenz, Marketing

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.

Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes11
Kategorie2
Node-Typen4
Schwierigkeitsbeschreibung

Für erfahrene Benutzer, mittelkomplexe Workflows mit 6-15 Nodes

Autor

AI Automations Expert | Gen AI Filmmaker | AI Product Builder 🔹 Built 25+ AI Automation Systems Designed and deployed AI workflows using OpenAI, Make.com, Zapier, and AdminitM to automate business processes, save time, and boost productivity.

Externe Links
Auf n8n.io ansehen

Diesen Workflow teilen

Kategorien

Kategorien: 34