将上传的视频转化为AI生成的博客研究（使用Dumpling AI和ChatGPT）
中级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 9 个节点。主要使用 Code, GoogleDrive, HttpRequest, GoogleSheets, ExtractFromFile 等节点。 视频转博客研究自动化，使用GPT-4o、Dumpling AI和Google Sheets
前置要求
- •Google Drive API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "iFQVBMkzOaaImF1b",
"meta": {
"instanceId": "a1ae5c8dc6c65e674f9c3947d083abcc749ef2546dff9f4ff01de4d6a36ebfe6",
"templateCredsSetupCompleted": true
},
"name": "将上传的视频转化为AI生成的博客研究（使用Dumpling AI和ChatGPT）",
"tags": [],
"nodes": [
{
"id": "b4cd7b7e-c7f6-4929-8772-d8d49e209db6",
"name": "观看上传的视频",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
-780,
-60
],
"parameters": {
"event": "fileCreated",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"triggerOn": "specificFolder",
"folderToWatch": {
"__rl": true,
"mode": "list",
"value": "1qh0vXJpLpoeXsfe0OFlbClBwDYqApn1A",
"cachedResultUrl": "https://drive.google.com/drive/folders/1qh0vXJpLpoeXsfe0OFlbClBwDYqApn1A",
"cachedResultName": "Video"
}
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "B0Hulh0j065xznhI",
"name": "nnekajennifer"
}
},
"typeVersion": 1
},
{
"id": "dafd1e7a-cf22-4ee9-832f-406db230068c",
"name": "下载视频",
"type": "n8n-nodes-base.googleDrive",
"position": [
-560,
-60
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.id }}"
},
"options": {},
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "B0Hulh0j065xznhI",
"name": "nnekajennifer"
}
},
"typeVersion": 3
},
{
"id": "a9416012-f251-4156-a8fe-d06847ec1268",
"name": "将视频转换为 Base64",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-340,
-60
],
"parameters": {
"options": {},
"operation": "binaryToPropery"
},
"typeVersion": 1
},
{
"id": "3f9cc134-5e8c-4496-a16a-eb701907d657",
"name": "使用Dumpling AI进行转录",
"type": "n8n-nodes-base.httpRequest",
"position": [
-120,
-60
],
"parameters": {
"url": "https://app.dumplingai.com/api/v1/extract-video",
"method": "POST",
"options": {},
"jsonBody": "={\n \"inputMethod\": \"base64\",\n \"video\": \"{{$json.data}}\",\n \"prompt\": \"extract everything spoken in this video word for word. Include timestamps for each sentence, identify different speakers if possible, and return only the full transcription without any explanations or extra formatting.\"\n}\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "RLFzAcGRepr5eXZB",
"name": "Dumpling AI-n8n"
}
},
"typeVersion": 4.2
},
{
"id": "64f39f44-577c-4c60-8be2-fc9ea39e802c",
"name": "使用OpenAI提取关键词",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
100,
-60
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "chatgpt-4o-latest",
"cachedResultName": "CHATGPT-4O-LATEST"
},
"options": {},
"messages": {
"values": [
{
"role": "system",
"content": "You are given the full transcript of a YouTube video. Analyze the transcript and return exactly five high-impact keywords or keyword phrases that best represent the main topics and ideas discussed in the video. Focus on terms that are relevant for SEO, content tagging, or summarizing the video’s core message. Return only the keywords in a simple comma-separated format, nothing else."
},
{
"content": "=Here is the transcript: {{ $json.results }}"
}
]
}
},
"credentials": {
"openAiApi": {
"id": "dd8NvMC6rvx8RITo",
"name": "OpenAi account 2"
}
},
"typeVersion": 1.8
},
{
"id": "8557c87e-53c8-4bf6-8b35-e13981a0a5fe",
"name": "通过Dumpling AI进行竞争对手研究",
"type": "n8n-nodes-base.httpRequest",
"position": [
476,
-60
],
"parameters": {
"url": "https://app.dumplingai.com/api/v1/agents/generate-completion",
"method": "POST",
"options": {},
"jsonBody": "={\n \"messages\": [\n {\n \"role\": \"user\",\n \"content\":\" {{ $json.message.content }}\"\n }\n ],\n \"agentId\": \"79e8a289-8e4a-46f5-8cc2-abeceb8ae9e4\",\n \"parseJson\": true\n}\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "RLFzAcGRepr5eXZB",
"name": "Dumpling AI-n8n"
}
},
"typeVersion": 4.2
},
{
"id": "5a2d59bc-73d5-437e-bc2f-cef6783d3533",
"name": "为Google Sheets格式化结果",
"type": "n8n-nodes-base.code",
"position": [
700,
-60
],
"parameters": {
"jsCode": "return items.map(item => {\n const perplexity = item.json.parsedJson?.topicsFromPerplexity || [];\n const google = item.json.parsedJson?.blogPostsFromGoogle || [];\n\n const formattedPerplexity = perplexity.map(p => {\n return `Title: ${p.title}\\nSummary: ${p.summary}\\nNotes: ${p.notes}`;\n }).join('\\n\\n');\n\n const formattedGoogle = google.map(g => {\n return `Title: ${g.title}\\nURL: ${g.url}\\nSummary: ${g.summary}`;\n }).join('\\n\\n');\n\n return {\n json: {\n perplexityOutput: formattedPerplexity,\n googleSearchOutput: formattedGoogle\n }\n };\n});\n\n"
},
"typeVersion": 2
},
{
"id": "c7610f48-f86a-4be7-8087-04438ed2f023",
"name": "追加到Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
916,
-60
],
"parameters": {
"columns": {
"value": {
"Keywords": "={{ $('Extract Keywords with OpenAI').item.json.message.content }}",
"blogPostsFromGoogle": "={{ $json.googleSearchOutput }}",
"topicsFromPerplexity": "={{ $json.perplexityOutput }}"
},
"schema": [
{
"id": "Keywords",
"type": "string",
"display": true,
"required": false,
"displayName": "Keywords",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "topicsFromPerplexity",
"type": "string",
"display": true,
"required": false,
"displayName": "topicsFromPerplexity",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "blogPostsFromGoogle",
"type": "string",
"display": true,
"required": false,
"displayName": "blogPostsFromGoogle",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/10J1qtgITl76XcuNqUdv5lWcPRJt5sfuhHnYE6L2jsjo/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/10J1qtgITl76XcuNqUdv5lWcPRJt5sfuhHnYE6L2jsjo/edit?usp=drivesdk",
"cachedResultName": "Agent"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "GaJqJHuS5mQxap7q",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "9eba3491-e0b6-49d6-a63f-63eaaf1125b3",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-780,
-360
],
"parameters": {
"width": 800,
"height": 560,
"content": "## 🎬 AI视频转博客研究自动化"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {
"Watch Uploaded Videos": [
{
"json": {
"id": "1Rlv_IgYTo3E2b6G8EBtkpdrmLJJbR4S9",
"kind": "drive#file",
"name": "videoplayback (11).mp4",
"size": "7576046",
"owners": [
{
"me": true,
"kind": "drive#user",
"photoLink": "https://lh3.googleusercontent.com/a/ACg8ocKCAELsjJ9Qppv0Kxqn-OzAtIPjciCPAwYLs5V7Akt8AZSgGSM=s64",
"displayName": "Nneka Jennifer Alisieze",
"emailAddress": "nnekajenniferalisieze@gmail.com",
"permissionId": "13872179939933913025"
}
],
"shared": false,
"spaces": [
"drive"
],
"parents": [
"1qh0vXJpLpoeXsfe0OFlbClBwDYqApn1A"
],
"starred": false,
"trashed": false,
"version": "5",
"iconLink": "https://drive-thirdparty.googleusercontent.com/16/type/video/mp4",
"mimeType": "video/mp4",
"ownedByMe": true,
"viewedByMe": true,
"createdTime": "2025-07-29T21:53:04.511Z",
"md5Checksum": "6f446c4ac03995b9d1345f2632dd1747",
"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": "nnekajenniferalisieze@gmail.com",
"pendingOwner": false
}
],
"webViewLink": "https://drive.google.com/file/d/1Rlv_IgYTo3E2b6G8EBtkpdrmLJJbR4S9/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,
"canChangeItemDownloadRestriction": true,
"canModifyOwnerContentRestriction": true,
"canModifyEditorContentRestriction": true,
"canChangeCopyRequiresWriterPermission": true
},
"hasThumbnail": true,
"modifiedByMe": true,
"modifiedTime": "2025-07-29T21:52:19.000Z",
"sha1Checksum": "167f926cf29e254083decb3aa454f5afc41e32e1",
"fileExtension": "mp4",
"permissionIds": [
"13872179939933913025"
],
"thumbnailLink": "https://lh3.googleusercontent.com/drive-storage/AJQWtBNYajm2L14WC6a7NsgXVRmNfR5cO_LVeMxe3e9ZmCEqR72SlJm9rghwII2EdaZb-03jnwfbH0x_6GTnauvvewI3l4mGgyaTAKkYd4hivCeohpw=s220",
"headRevisionId": "0B9Z2_-yY3S8oekE2RXhTcTExbnRPT0x4VTVHdTc5ak5jTVM0PQ",
"quotaBytesUsed": "7576046",
"sha256Checksum": "c8906b57fcf9cb078255cf7f9d8ea3ad60dcc20e29e82d739c38cd964a3477aa",
"viewedByMeTime": "2025-07-29T21:53:04.511Z",
"webContentLink": "https://drive.google.com/uc?id=1Rlv_IgYTo3E2b6G8EBtkpdrmLJJbR4S9&export=download",
"isAppAuthorized": false,
"writersCanShare": true,
"modifiedByMeTime": "2025-07-29T21:52:19.000Z",
"originalFilename": "videoplayback (11).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
},
"downloadRestrictions": {
"itemDownloadRestriction": {
"restrictedForReaders": false,
"restrictedForWriters": false
},
"effectiveDownloadRestrictionWithContext": {
"restrictedForReaders": false,
"restrictedForWriters": false
}
},
"viewersCanCopyContent": true,
"copyRequiresWriterPermission": false,
"inheritedPermissionsDisabled": false
}
}
],
"Run Competitor Research via Dumpling AI": [
{
"json": {
"text": "{\n \"keywords\": [\n \"AI automation workflows\",\n \"n8n GitHub repository\",\n \"Python automation setup\",\n \"prebuilt workflow templates\",\n \"open source workflow tools\"\n ],\n \"topicsFromPerplexity\": [\n {\n \"title\": \"AI Automation Workflows in n8n\",\n \"summary\": \"n8n supports AI-driven automation by integrating with various AI APIs, allowing users to automate tasks like data extraction and sentiment analysis.\",\n \"notes\": \"The platform has over 1700 community-contributed templates focused on AI automation.\"\n },\n {\n \"title\": \"Integration with GitHub\",\n \"summary\": \"n8n offers extensive GitHub integration, enabling automation of DevOps tasks such as CI/CD pipelines and issue management.\",\n \"notes\": \"This integration enhances productivity in software development workflows.\"\n },\n {\n \"title\": \"Python Integration in Automation\",\n \"summary\": \"Users can incorporate Python code into n8n workflows, allowing for complex automation and data processing.\",\n \"notes\": \"This feature combines visual workflow building with the precision of coding.\"\n }\n ],\n \"blogPostsFromGoogle\": [\n {\n \"title\": \"lucaswalter/n8n-ai-workflows - GitHub\",\n \"url\": \"https://github.com/lucaswalter/n8n-ai-workflows\",\n \"summary\": \"Collection of n8n workflows, automations, and agents created for The Recap AI YouTube channel and the AI Automation Mastery free Skool community.\"\n },\n {\n \"title\": \"Automated Blog Generation with Gemini AI, GitHub & Jekyll Publishing\",\n \"url\": \"https://n8n.io/workflows/6357-automated-blog-generation-with-gemini-ai-github-and-jekyll-publishing/\",\n \"summary\": \"This n8n workflow automates the creation and publication of technical blog posts based on a list of topics stored in Google Sheets.\"\n },\n {\n \"title\": \"Boost Efficiency with N8N Workflow Automation - Milvus Blog\",\n \"url\": \"https://milvus.io/blog/i-discovered-this-n8n-repo-that-actually-10xd-my-workflow-automation-efficiency.md\",\n \"summary\": \"Learn how to automate workflows with N8N, covering setup, templates, and integrations to boost productivity.\"\n },\n {\n \"title\": \"The Complete n8n Workflow Guide: Building an AI Development Automation\",\n \"url\": \"https://medium.com/@mongin.marc/the-complete-n8n-workflow-guide-building-an-ai-development-automation-step-by-step-b755bacc624a\",\n \"summary\": \"A detailed guide to creating a n8n workflow that automates development tasks using Claude AI, Notion, and GitHub.\"\n },\n {\n \"title\": \"Automate Your Home Lab with n8n Workflow Automation and AI\",\n \"url\": \"https://www.virtualizationhowto.com/2025/07/automate-your-home-lab-with-n8n-workflow-automation-and-ai/\",\n \"summary\": \"Learn about the power of n8n Workflow Automation to simplify tasks and connect over 200 services for streamlined processes.\"\n }\n ]\n}",
"steps": [
{
"text": "",
"usage": {
"totalTokens": 861,
"promptTokens": 774,
"completionTokens": 87
},
"toolCalls": [
{
"args": {
"query": "AI automation workflows, n8n GitHub repository, Python automation setup, prebuilt workflow templates, open source workflow tools"
},
"type": "tool-call",
"toolName": "search_perplexity_0",
"toolCallId": "call_EXmsGl0LhM86EldjvajyHJLB"
},
{
"args": {
"query": "AI automation workflows n8n GitHub repository blog",
"dateRange": "pastMonth"
},
"type": "tool-call",
"toolName": "search_1",
"toolCallId": "call_5uBzGgmBOzBbSFGhTHblD0EU"
}
],
"toolResults": [
{
"args": {
"query": "AI automation workflows, n8n GitHub repository, Python automation setup, prebuilt workflow templates, open source workflow tools"
},
"type": "tool-result",
"result": "{\"content\":\"n8n is a powerful open-source workflow automation tool that supports AI automation workflows, Python automation, and integrates deeply with GitHub and many other services. It offers a rich ecosystem for building, sharing, and customizing automation workflows, including prebuilt templates and tools for Python scripting.\\n\\nKey points about n8n and related automation capabilities:\\n\\n- **AI Automation Workflows:** n8n supports AI-driven automation by integrating with AI APIs and services like OpenAI and Google AI. It allows automating tasks such as data extraction, text translation, summarization, sentiment analysis, and more, often by connecting proprietary data sources with AI models in modular workflows[2].\\n\\n- **GitHub Integration:** n8n provides extensive GitHub integration, enabling automation of tasks such as creating, editing, and deleting files or issues, managing pull requests, releases, and syncing data. This supports DevOps automation like CI/CD pipelines, automated testing, and ticket updates triggered by code changes[1][3].\\n\\n- **Python Automation Setup:** Users can incorporate Python code within workflows in n8n, either by writing custom Python scripts or adding Python libraries. This flexibility enables complex automation logic and data processing within workflows, combining visual drag-and-drop building with code precision[5].\\n\\n- **Prebuilt Workflow Templates:** n8n offers thousands of community-contributed workflow templates (over 1700), including a large collection focused on AI automation. These templates allow users to quickly start automations and customize them as needed. A GitHub repository named \\\"awesome-n8n-templates\\\" collects curated templates, although it may not specifically include setup scripts or prebuilt workflows for Python automation[2][4][5].\\n\\n- **Open Source and Extensibility:** n8n is fully open source, with its entire source code available on GitHub. It can be self-hosted or used via a hosted cloud version, supporting modular design, environment variables for secure credentials, version control of workflows via JSON export, and robust error handling—making it suitable for scalable automation projects[1][5].\\n\\nIn summary, n8n combines visual workflow building with powerful integrations (including GitHub and Python) and a vast library of prebuilt AI automation templates. It is an ideal open source platform for creating, managing, and scaling AI and other automation workflows with flexibility and control.\",\"usage\":{\"prompt_tokens\":23,\"completion_tokens\":466,\"total_tokens\":489,\"search_context_size\":\"low\"}}",
"toolName": "search_perplexity_0",
"toolCallId": "call_EXmsGl0LhM86EldjvajyHJLB"
},
{
"args": {
"query": "AI automation workflows n8n GitHub repository blog",
"dateRange": "pastMonth"
},
"type": "tool-result",
"result": {
"credits": 1,
"organic": [
{
"date": "Jul 2, 2025",
"link": "https://github.com/lucaswalter/n8n-ai-workflows",
"title": "lucaswalter/n8n-ai-workflows - GitHub",
"snippet": "Collection of n8n workflows, automations, and agents created for The Recap AI YouTube channel and the AI Automation Mastery free Skool community.",
"position": 1
},
{
"date": "5 days ago",
"link": "https://n8n.io/workflows/6357-automated-blog-generation-with-gemini-ai-github-and-jekyll-publishing/",
"title": "Automated Blog Generation with Gemini AI, GitHub & Jekyll Publishing",
"rating": 4.6,
"snippet": "Use Case. This n8n workflow automates the creation and publication of technical blog posts based on a list of topics stored in Google Sheets.",
"position": 2,
"sitelinks": [
{
"link": "https://n8n.io/workflows/6357-automated-blog-generation-with-gemini-ai-github-and-jekyll-publishing/#:~:text=%F0%9F%93%9D%20Use%20Case",
"title": "📝 Use Case"
},
{
"link": "https://n8n.io/workflows/6357-automated-blog-generation-with-gemini-ai-github-and-jekyll-publishing/#:~:text=%E2%9A%99%EF%B8%8F%20Setup%20Instructions",
"title": "⚙️ Setup Instructions"
},
{
"link": "https://n8n.io/workflows/6357-automated-blog-generation-with-gemini-ai-github-and-jekyll-publishing/#:~:text=%F0%9F%94%84%20Workflow%20Details",
"title": "🔄 Workflow Details"
}
],
"ratingCount": 27
},
{
"date": "Jul 9, 2025",
"link": "https://milvus.io/blog/i-discovered-this-n8n-repo-that-actually-10xd-my-workflow-automation-efficiency.md",
"title": "Boost Efficiency with N8N Workflow Automation - Milvus Blog",
"snippet": "Learn how to automate workflows with N8N. This step-by-step tutorial covers setup, 2000+ templates, and integrations to boost productivity and streamline ...",
"position": 3
},
{
"date": "Jul 21, 2025",
"link": "https://www.reddit.com/r/n8n/comments/1m5qnxn/i_built_a_content_generator_ai_workflow_using_n8n/",
"title": "I built a Content Generator AI workflow using n8n that takes daily ...",
"snippet": "It scrapes fresh topics, generates long form blog posts from RSS feeds, repurpose them using AI, and publishes directly to WordPress. Here's how the system ...",
"position": 4
},
{
"date": "Jul 17, 2025",
"link": "https://github.com/orgs/n8n-io/repositories",
"title": "Repositories - n8n-io - GitHub",
"snippet": "Fair-code workflow automation platform with native AI capabilities. Combine visual building with custom code, self-host or cloud, 400+ integrations. cliworkflow ...",
"position": 5
},
{
"date": "9 hours ago",
"link": "https://medium.com/@mongin.marc/the-complete-n8n-workflow-guide-building-an-ai-development-automation-step-by-step-b755bacc624a",
"title": "The Complete n8n Workflow Guide: Building an AI Development ...",
"snippet": "A detailed, hands-on guide to creating a n8n workflow that automates development tasks using Claude AI, Notion, and GitHub. Prerequisites.",
"position": 6
},
{
"date": "Jul 17, 2025",
"link": "https://n8n.io/workflows/5898-automated-n8n-workflow-backup-to-github-with-deletion-tracking/",
"title": "Automated n8n Workflow Backup to GitHub with Deletion Tracking",
"rating": 4.6,
"snippet": "This workflow will backup your workflows to GitHub. It uses the n8n API node to export all workflows. It then loops over the data, checks in GitHub to see if a ...",
"position": 7,
"ratingCount": 27
},
{
"date": "Jul 7, 2025",
"link": "https://github.com/topics/n8n-automation?o=desc&s=stars",
"title": "n8n-automation · GitHub Topics",
"snippet": "Supercharge your workflow automation with this curated collection of n8n templates! Instantly connect your favorite apps-like Gmail, Telegram, Google Drive, ...",
"position": 8
},
{
"date": "6 days ago",
"link": "https://www.reddit.com/r/n8n/comments/1m7wv4a/whats_the_most_impactful_daily_automation/",
"title": "What's the Most Impactful Daily Automation Workflow You've Built ...",
"snippet": "I've built dozens of automations with n8n, some for work, some just for fun, but a few stand out as game changers in my day-to-day: Second Brain Discord Bot: I ...",
"position": 9
},
{
"date": "Jul 21, 2025",
"link": "https://www.virtualizationhowto.com/2025/07/automate-your-home-lab-with-n8n-workflow-automation-and-ai/",
"title": "Automate Your Home Lab with n8n Workflow Automation and AI",
"snippet": "Learn about the power of n8n Workflow Automation to simplify your tasks and connect over 200 services for streamlined processes.",
"position": 10,
"sitelinks": [
{
"link": "https://www.virtualizationhowto.com/2025/07/automate-your-home-lab-with-n8n-workflow-automation-and-ai/#:~:text=Features%20of%20N8N",
"title": "Features Of N8n"
},
{
"link": "https://www.virtualizationhowto.com/2025/07/automate-your-home-lab-with-n8n-workflow-automation-and-ai/#:~:text=App%20integrations,-I%20think%20by%20far%20one",
"title": "App Integrations"
},
{
"link": "https://www.virtualizationhowto.com/2025/07/automate-your-home-lab-with-n8n-workflow-automation-and-ai/#:~:text=Installing%20n8n%20using%20Docker%20Compose",
"title": "Installing N8n Using Docker..."
}
]
}
],
"relatedSearches": [
{
"query": "Ai automation workflows n8n github repository blog example"
},
{
"query": "Ai automation workflows n8n github repository blog free"
},
{
"query": "N8n workflows GitHub"
},
{
"query": "N8n workflow leaked"
},
{
"query": "Workflow automation GitHub"
},
{
"query": "N8n-hosting github"
},
{
"query": "N8n templates GitHub"
},
{
"query": "N8n chat GitHub"
}
],
"searchParameters": {
"q": "AI automation workflows n8n GitHub repository blog",
"tbs": "qdr:m",
"type": "search",
"engine": "google"
}
},
"toolName": "search_1",
"toolCallId": "call_5uBzGgmBOzBbSFGhTHblD0EU"
}
],
"finishReason": "tool-calls"
},
{
"text": "{\n \"keywords\": [\n \"AI automation workflows\",\n \"n8n GitHub repository\",\n \"Python automation setup\",\n \"prebuilt workflow templates\",\n \"open source workflow tools\"\n ],\n \"topicsFromPerplexity\": [\n {\n \"title\": \"AI Automation Workflows in n8n\",\n \"summary\": \"n8n supports AI-driven automation by integrating with various AI APIs, allowing users to automate tasks like data extraction and sentiment analysis.\",\n \"notes\": \"The platform has over 1700 community-contributed templates focused on AI automation.\"\n },\n {\n \"title\": \"Integration with GitHub\",\n \"summary\": \"n8n offers extensive GitHub integration, enabling automation of DevOps tasks such as CI/CD pipelines and issue management.\",\n \"notes\": \"This integration enhances productivity in software development workflows.\"\n },\n {\n \"title\": \"Python Integration in Automation\",\n \"summary\": \"Users can incorporate Python code into n8n workflows, allowing for complex automation and data processing.\",\n \"notes\": \"This feature combines visual workflow building with the precision of coding.\"\n }\n ],\n \"blogPostsFromGoogle\": [\n {\n \"title\": \"lucaswalter/n8n-ai-workflows - GitHub\",\n \"url\": \"https://github.com/lucaswalter/n8n-ai-workflows\",\n \"summary\": \"Collection of n8n workflows, automations, and agents created for The Recap AI YouTube channel and the AI Automation Mastery free Skool community.\"\n },\n {\n \"title\": \"Automated Blog Generation with Gemini AI, GitHub & Jekyll Publishing\",\n \"url\": \"https://n8n.io/workflows/6357-automated-blog-generation-with-gemini-ai-github-and-jekyll-publishing/\",\n \"summary\": \"This n8n workflow automates the creation and publication of technical blog posts based on a list of topics stored in Google Sheets.\"\n },\n {\n \"title\": \"Boost Efficiency with N8N Workflow Automation - Milvus Blog\",\n \"url\": \"https://milvus.io/blog/i-discovered-this-n8n-repo-that-actually-10xd-my-workflow-automation-efficiency.md\",\n \"summary\": \"Learn how to automate workflows with N8N, covering setup, templates, and integrations to boost productivity.\"\n },\n {\n \"title\": \"The Complete n8n Workflow Guide: Building an AI Development Automation\",\n \"url\": \"https://medium.com/@mongin.marc/the-complete-n8n-workflow-guide-building-an-ai-development-automation-step-by-step-b755bacc624a\",\n \"summary\": \"A detailed guide to creating a n8n workflow that automates development tasks using Claude AI, Notion, and GitHub.\"\n },\n {\n \"title\": \"Automate Your Home Lab with n8n Workflow Automation and AI\",\n \"url\": \"https://www.virtualizationhowto.com/2025/07/automate-your-home-lab-with-n8n-workflow-automation-and-ai/\",\n \"summary\": \"Learn about the power of n8n Workflow Automation to simplify tasks and connect over 200 services for streamlined processes.\"\n }\n ]\n}",
"usage": {
"totalTokens": 3705,
"promptTokens": 3022,
"completionTokens": 683
},
"toolCalls": [],
"toolResults": [],
"finishReason": "stop"
}
],
"threadId": "77a85cb6-bc58-4722-965f-9342a3b6200d",
"parsedJson": {
"keywords": [
"AI automation workflows",
"n8n GitHub repository",
"Python automation setup",
"prebuilt workflow templates",
"open source workflow tools"
],
"blogPostsFromGoogle": [
{
"url": "https://github.com/lucaswalter/n8n-ai-workflows",
"title": "lucaswalter/n8n-ai-workflows - GitHub",
"summary": "Collection of n8n workflows, automations, and agents created for The Recap AI YouTube channel and the AI Automation Mastery free Skool community."
},
{
"url": "https://n8n.io/workflows/6357-automated-blog-generation-with-gemini-ai-github-and-jekyll-publishing/",
"title": "Automated Blog Generation with Gemini AI, GitHub & Jekyll Publishing",
"summary": "This n8n workflow automates the creation and publication of technical blog posts based on a list of topics stored in Google Sheets."
},
{
"url": "https://milvus.io/blog/i-discovered-this-n8n-repo-that-actually-10xd-my-workflow-automation-efficiency.md",
"title": "Boost Efficiency with N8N Workflow Automation - Milvus Blog",
"summary": "Learn how to automate workflows with N8N, covering setup, templates, and integrations to boost productivity."
},
{
"url": "https://medium.com/@mongin.marc/the-complete-n8n-workflow-guide-building-an-ai-development-automation-step-by-step-b755bacc624a",
"title": "The Complete n8n Workflow Guide: Building an AI Development Automation",
"summary": "A detailed guide to creating a n8n workflow that automates development tasks using Claude AI, Notion, and GitHub."
},
{
"url": "https://www.virtualizationhowto.com/2025/07/automate-your-home-lab-with-n8n-workflow-automation-and-ai/",
"title": "Automate Your Home Lab with n8n Workflow Automation and AI",
"summary": "Learn about the power of n8n Workflow Automation to simplify tasks and connect over 200 services for streamlined processes."
}
],
"topicsFromPerplexity": [
{
"notes": "The platform has over 1700 community-contributed templates focused on AI automation.",
"title": "AI Automation Workflows in n8n",
"summary": "n8n supports AI-driven automation by integrating with various AI APIs, allowing users to automate tasks like data extraction and sentiment analysis."
},
{
"notes": "This integration enhances productivity in software development workflows.",
"title": "Integration with GitHub",
"summary": "n8n offers extensive GitHub integration, enabling automation of DevOps tasks such as CI/CD pipelines and issue management."
},
{
"notes": "This feature combines visual workflow building with the precision of coding.",
"title": "Python Integration in Automation",
"summary": "Users can incorporate Python code into n8n workflows, allowing for complex automation and data processing."
}
]
},
"stepsTaken": 2,
"tokenUsage": {
"totalTokens": 4566,
"promptTokens": 3796,
"completionTokens": 770
},
"creditUsage": 5
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "d652cd56-47ab-4493-b51d-fa8b95b5f195",
"connections": {
"Download Video": {
"main": [
[
{
"node": "Convert Video to Base64",
"type": "main",
"index": 0
}
]
]
},
"Watch Uploaded Videos": {
"main": [
[
{
"node": "Download Video",
"type": "main",
"index": 0
}
]
]
},
"Convert Video to Base64": {
"main": [
[
{
"node": "Transcribe with Dumpling AI",
"type": "main",
"index": 0
}
]
]
},
"Transcribe with Dumpling AI": {
"main": [
[
{
"node": "Extract Keywords with OpenAI",
"type": "main",
"index": 0
}
]
]
},
"Extract Keywords with OpenAI": {
"main": [
[
{
"node": "Run Competitor Research via Dumpling AI",
"type": "main",
"index": 0
}
]
]
},
"Format Results for Google Sheets": {
"main": [
[
{
"node": "Append to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Run Competitor Research via Dumpling AI": {
"main": [
[
{
"node": "Format Results for Google Sheets",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用 Dumpling AI 从表单自动生成电影级动物视频和声音
使用GPT-4、Dumpling AI和ElevenLabs音频将表单输入转换为电影级视频
Set
Code
Wait
+9
23 节点Yang
内容创作
使用Dumpling AI从YouTube视频自动生成平台特定帖子
使用GPT-4o和Dumpling AI从YouTube视频自动生成Instagram、Facebook和LinkedIn帖子
Set
Code
Merge
+6
20 节点Yang
内容创作
使用GPT-4、Dumpling AI和Google Drive生成广告图片变体
使用GPT-4、Dumpling AI和Google Drive生成广告图片变体
Split Out
Form Trigger
Google Drive
+8
14 节点Yang
内容创作
使用Dumpling AI和GPT-4o生成YouTube视频创意
通过视频分析使用Dumpling AI和GPT-4o生成YouTube内容创意
Code
Wait
Gmail
+8
13 节点Yang
内容创作
AI 产品图片生成器 - 公共模板
使用 OpenAI、Gemini 和 Google Workspace 的自动化产品广告图片创建
Code
Google Drive
Http Request
+6
15 节点Avkash Kakdiya
内容创作
1. 播放列表详情设置机器人副本
使用 Suno、GPT-4、Runway 和 Creatomate 创建 AI 生成的 YouTube 音乐播放列表
If
Set
Code
+22
203 节点Joseph
内容创作
