動画から洞察を抽出して、自動のにFacebookの投稿を生成するDumpling AI + GPT-4o

• •Google Drive API認証情報
• •ターゲットAPIの認証情報が必要な場合あり
• •Google Sheets API認証情報
• •OpenAI API Key

{
  "id": "AKfISaE8hA8EZPhV",
  "meta": {
    "instanceId": "a1ae5c8dc6c65e674f9c3947d083abcc749ef2546dff9f4ff01de4d6a36ebfe6",
    "templateCredsSetupCompleted": true
  },
  "name": "Auto-Generate Facebook Posts from Video Insights with Dumpling AI + GPT-4o",
  "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シートに保存",
      "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": "### 📌 Workflow Summary\n\nThis workflow listens to a specific Google Drive folder. When a new video is uploaded:\n\n1. It downloads the video file and converts it to base64.\n2. The base64 video is sent to Dumpling AI's `/extract-video` endpoint with a prompt to extract key tutorial insights.\n3. The extracted content is passed to OpenAI (GPT-4o) to generate a short Facebook post and a descriptive image prompt.\n4. The prompt is then used to generate an AI image using Dumpling AI's image endpoint.\n5. Finally, the Facebook post and image URL are logged in a Google Sheet for easy publishing or review.\n\nUse this workflow to automate content repurposing from your technical videos.\n"
      },
      "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": {
    "4b9e7acf-794e-4938-9e11-532db5c15e34": {
      "main": [
        [
          {
            "node": "088c9db2-8a26-4555-9f45-0212170670ac",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "088c9db2-8a26-4555-9f45-0212170670ac": {
      "main": [
        [
          {
            "node": "ad4f47e1-ec0a-4194-adce-3bc4be074353",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "db55c7d2-85d7-4933-a8c6-8946a3772c2d": {
      "main": [
        [
          {
            "node": "4b9e7acf-794e-4938-9e11-532db5c15e34",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c0e3ca61-c58f-410c-8d78-a20f368ba6a5": {
      "main": [
        [
          {
            "node": "9f6d375b-e2e7-4e2f-bab8-77fe1f803514",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ad4f47e1-ec0a-4194-adce-3bc4be074353": {
      "main": [
        [
          {
            "node": "0c7cfd0f-0d99-410a-ac00-0d18926f1dba",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0c7cfd0f-0d99-410a-ac00-0d18926f1dba": {
      "main": [
        [
          {
            "node": "c0e3ca61-c58f-410c-8d78-a20f368ba6a5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}