使用Dumpling AI + GPT-4o从视频洞察自动生成Facebook帖子

• •Google Drive API 凭证
• •可能需要目标 API 的认证凭证
• •Google Sheets API 凭证
• •OpenAI API Key

{
  "id": "AKfISaE8hA8EZPhV",
  "meta": {
    "instanceId": "a1ae5c8dc6c65e674f9c3947d083abcc749ef2546dff9f4ff01de4d6a36ebfe6",
    "templateCredsSetupCompleted": true
  },
  "name": "使用 Dumpling AI + GPT-4o 自动从视频洞察生成 Facebook 帖子",
  "tags": [],
  "nodes": [
    {
      "id": "db55c7d2-85d7-4933-a8c6-8946a3772c2d",
      "name": "新视频上传时触发",
      "type": "n8n-nodes-base.googleDriveTrigger",
      "position": [
        -1020,
        0
      ],
      "parameters": {
        "event": "fileCreated",
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "triggerOn": "specificFolder",
        "folderToWatch": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://drive.google.com/drive/folders/1NU00YbKNiHJptNuQZH6kgVUhLvDzE0ka",
          "cachedResultName": "n8n-video"
        }
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "id": "B0Hulh0j065xznhI",
          "name": "nnekajennifer"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "4b9e7acf-794e-4938-9e11-532db5c15e34",
      "name": "下载视频文件",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -800,
        0
      ],
      "parameters": {
        "fileId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $json.id }}"
        },
        "options": {},
        "operation": "download"
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "id": "B0Hulh0j065xznhI",
          "name": "nnekajennifer"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "088c9db2-8a26-4555-9f45-0212170670ac",
      "name": "将视频转换为 Base64",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        -580,
        0
      ],
      "parameters": {
        "options": {},
        "operation": "binaryToPropery"
      },
      "typeVersion": 1
    },
    {
      "id": "ad4f47e1-ec0a-4194-adce-3bc4be074353",
      "name": "使用 Dumpling AI 提取关键洞察",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -360,
        0
      ],
      "parameters": {
        "url": "https://app.dumplingai.com/api/v1/extract-video",
        "method": "POST",
        "options": {},
        "jsonBody": "={\n  \"inputMethod\": \"base64\",\n  \"video\": \"{{ $json.data }}\",\n  \"prompt\": \"You are an AI assistant that extracts key insights from a video transcript related to automation or technical tutorials. From the content, identify and return the following details clearly: 1. Topic of the video, 2. Main tools or platforms mentioned (e.g. N8N, 11Labs), 3. Purpose of the tutorial, 4. Key steps shared or demonstrated, 5. Important modules or actions discussed, 6. Any use case or real-world application mentioned, 7. Specific tips, issues, or recommendations shared by the creator. Focus only on the core lesson, and ignore filler intro or closing remarks unless they contain critical information. Respond only with the extracted data, do not repeat the transcript. Return your result in clean and structured JSON.\",\n  \"jsonMode\": true\n}\n",
        "sendBody": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth"
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "RLFzAcGRepr5eXZB",
          "name": "Dumpling AI-n8n"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "0c7cfd0f-0d99-410a-ac00-0d18926f1dba",
      "name": "生成 Facebook 帖子与图片提示",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -140,
        0
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "chatgpt-4o-latest",
          "cachedResultName": "CHATGPT-4O-LATEST"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "role": "system",
              "content": "=You are a professional content writer and visual assistant. Based on the extracted key points from a technical tutorial video, your task is to do two things:\n\nWrite a short, engaging Facebook post using the extracted content. The post should sound natural and friendly, as if someone is casually sharing something valuable they learned. Focus on the main topic, tools mentioned, what was demonstrated, and why it matters. Avoid technical jargon, hashtags, or links unless included in the content. Keep it between 100 and 150 words.\n\nCreate a simple image prompt idea that could be used to generate a visual for the post. The image should support the post’s topic (e.g., showing a voice assistant, an automation flow, or AI tools in action). The prompt should be descriptive but concise, suitable for text-to-image generation.\n\nReturn your result in this JSON format:\n\n{\n  \"facebook_post\": \"string\",\n  \"image_prompt\": \"string\"\n}\nOnly output the JSON, no explanation or extra text.\n\n\n\n\n\n\n\n\n\n"
            },
            {
              "content": "=Here is the extracted content:{{ $('Extract Key Insights with Dumpling AI').item.json.results }}"
            }
          ]
        },
        "jsonOutput": true
      },
      "credentials": {
        "openAiApi": {
          "id": "dd8NvMC6rvx8RITo",
          "name": "OpenAi account 2"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "c0e3ca61-c58f-410c-8d78-a20f368ba6a5",
      "name": "使用 Dumpling AI 生成 AI 图片",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        220,
        0
      ],
      "parameters": {
        "url": "https://app.dumplingai.com/api/v1/generate-ai-image",
        "method": "POST",
        "options": {},
        "jsonBody": "={\n  \"model\": \"recraft-v3\",\n  \"input\": {\n    \"prompt\": \"{{ $json.message.content.image_prompt}}\", \n    \"style\": \"any\"\n  }\n}",
        "sendBody": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth"
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "RLFzAcGRepr5eXZB",
          "name": "Dumpling AI-n8n"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "9f6d375b-e2e7-4e2f-bab8-77fe1f803514",
      "name": "将帖子和图片 URL 保存到 Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        440,
        0
      ],
      "parameters": {
        "columns": {
          "value": {
            "Post": "={{ $('Generate Facebook Post & Image Prompt').item.json.message.content.facebook_post }}",
            "Image URL": "={{ $json.images[0].url }}"
          },
          "schema": [
            {
              "id": "Post",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Post",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Image URL",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Image URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NkLQ4ZZ3qSv8HybYuKyW2BgViUij68ux4_SnoBphmWE/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NkLQ4ZZ3qSv8HybYuKyW2BgViUij68ux4_SnoBphmWE/edit?usp=drivesdk",
          "cachedResultName": "facebook post"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "GaJqJHuS5mQxap7q",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "7c08f7b1-5540-4a50-bfcb-c93d6ebf89fc",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1000,
        -320
      ],
      "parameters": {
        "width": 680,
        "height": 380,
        "content": "### 📌 工作流摘要"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {
    "Trigger on New Video Upload": [
      {
        "json": {
          "id": "1k2nT0tQh6U7qR2NxU_JMzF0oEi9YYJaR",
          "kind": "drive#file",
          "name": "Ultimate Guide to the ElevenLabs Node in n8n (AI Voice Agents).mp4",
          "size": "20055056",
          "owners": [
            {
              "me": true,
              "kind": "drive#user",
              "photoLink": "https://lh3.googleusercontent.com/a/ACg8ocKCAELsjJ9Qppv0Kxqn-OzAtIPjciCPAwYLs5V7Akt8AZSgGSM=s64",
              "displayName": "Nneka Jennifer Alisieze",
              "emailAddress": "",
              "permissionId": "13872179939933913025"
            }
          ],
          "shared": false,
          "spaces": [
            "drive"
          ],
          "parents": [
            "1NU00YbKNiHJptNuQZH6kgVUhLvDzE0ka"
          ],
          "starred": false,
          "trashed": false,
          "version": "7",
          "iconLink": "https://drive-thirdparty.googleusercontent.com/16/type/video/mp4",
          "mimeType": "video/mp4",
          "ownedByMe": true,
          "viewedByMe": true,
          "createdTime": "2025-06-17T21:47:18.212Z",
          "md5Checksum": "019c6b4fabe2b79eece91061581b209b",
          "permissions": [
            {
              "id": "13872179939933913025",
              "kind": "drive#permission",
              "role": "owner",
              "type": "user",
              "deleted": false,
              "photoLink": "https://lh3.googleusercontent.com/a/ACg8ocKCAELsjJ9Qppv0Kxqn-OzAtIPjciCPAwYLs5V7Akt8AZSgGSM=s64",
              "displayName": "Nneka Jennifer Alisieze",
              "emailAddress": "",
              "pendingOwner": false
            }
          ],
          "webViewLink": "https://drive.google.com/file/d/1k2nT0tQh6U7qR2NxU_JMzF0oEi9YYJaR/view?usp=drivesdk",
          "capabilities": {
            "canCopy": true,
            "canEdit": true,
            "canShare": true,
            "canTrash": true,
            "canDelete": true,
            "canRename": true,
            "canComment": true,
            "canUntrash": true,
            "canDownload": true,
            "canReadLabels": false,
            "canAddChildren": false,
            "canListChildren": false,
            "canModifyLabels": false,
            "canModifyContent": true,
            "canReadRevisions": true,
            "canRemoveChildren": false,
            "canAcceptOwnership": false,
            "canAddMyDriveParent": false,
            "canMoveItemOutOfDrive": true,
            "canMoveItemWithinDrive": true,
            "canRemoveMyDriveParent": true,
            "canMoveItemIntoTeamDrive": true,
            "canMoveChildrenWithinDrive": false,
            "canModifyContentRestriction": true,
            "canRemoveContentRestriction": false,
            "canEnableInheritedPermissions": true,
            "canChangeSecurityUpdateEnabled": false,
            "canChangeViewersCanCopyContent": true,
            "canDisableInheritedPermissions": false,
            "canModifyOwnerContentRestriction": true,
            "canModifyEditorContentRestriction": true,
            "canChangeCopyRequiresWriterPermission": true
          },
          "hasThumbnail": true,
          "modifiedByMe": true,
          "modifiedTime": "2025-06-17T21:46:00.000Z",
          "sha1Checksum": "5448ff78c9f83c222ec63f175c42ae7f8ae7c98c",
          "fileExtension": "mp4",
          "permissionIds": [
            "13872179939933913025"
          ],
          "thumbnailLink": "https://lh3.googleusercontent.com/drive-storage/AJQWtBPM8BsCFqa0sKirpxjHP-G_9WaauNnNtesi9HzH-TIbE6Eh3dAYZELGk1hKBjLzFTgeYUrFK3Sz6YmgqhUnR3mAwjYx7POUMGnGBV-YIMZBAtQ=s220",
          "headRevisionId": "0B9Z2_-yY3S8oY3dlVjQ0S3I0V2ErdU8xd0xpSjNkRWJFQ0IwPQ",
          "quotaBytesUsed": "20055056",
          "sha256Checksum": "6cf6c040fb5b02fd400e13a0c36e08f76cc3bde500c235975211cc1167d746c0",
          "viewedByMeTime": "2025-06-17T21:47:18.212Z",
          "webContentLink": "https://drive.google.com/uc?id=1k2nT0tQh6U7qR2NxU_JMzF0oEi9YYJaR&export=download",
          "isAppAuthorized": false,
          "writersCanShare": true,
          "modifiedByMeTime": "2025-06-17T21:46:00.000Z",
          "originalFilename": "Ultimate Guide to the ElevenLabs Node in n8n (AI Voice Agents).mp4",
          "thumbnailVersion": "1",
          "explicitlyTrashed": false,
          "fullFileExtension": "mp4",
          "lastModifyingUser": {
            "me": true,
            "kind": "drive#user",
            "photoLink": "https://lh3.googleusercontent.com/a/ACg8ocKCAELsjJ9Qppv0Kxqn-OzAtIPjciCPAwYLs5V7Akt8AZSgGSM=s64",
            "displayName": "Nneka Jennifer Alisieze",
            "emailAddress": "nnekajenniferalisieze@gmail.com",
            "permissionId": "13872179939933913025"
          },
          "linkShareMetadata": {
            "securityUpdateEnabled": true,
            "securityUpdateEligible": false
          },
          "videoMediaMetadata": {
            "width": 854,
            "height": 480,
            "durationMillis": "658166"
          },
          "viewersCanCopyContent": true,
          "copyRequiresWriterPermission": false,
          "inheritedPermissionsDisabled": false
        }
      }
    ]
  },
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "7925d4c9-da76-43aa-a3ff-6a8fda9103d5",
  "connections": {
    "Download Video File": {
      "main": [
        [
          {
            "node": "Convert Video to Base64",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert Video to Base64": {
      "main": [
        [
          {
            "node": "Extract Key Insights with Dumpling AI",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Trigger on New Video Upload": {
      "main": [
        [
          {
            "node": "Download Video File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate AI Image with Dumpling AI": {
      "main": [
        [
          {
            "node": "Save Post and Image URL to Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Key Insights with Dumpling AI": {
      "main": [
        [
          {
            "node": "Generate Facebook Post & Image Prompt",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Facebook Post & Image Prompt": {
      "main": [
        [
          {
            "node": "Generate AI Image with Dumpling AI",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}