8
n8n 中文网amn8n.com

AI驱动的施工现场进度追踪器

中级

这是一个Project Management, Multimodal AI领域的自动化工作流，包含 13 个节点。主要使用 EmailSend, GoogleDrive, GoogleSheets, SplitInBatches, ScheduleTrigger 等节点。 使用 Google Gemini AI、Drive 照片和 Sheets 跟踪施工现场进度

前置要求
  • •Google Drive API 凭证
  • •Google Sheets API 凭证
  • •Google Gemini API Key

使用的节点 (13)

EmailSend
StickyNote
GoogleDrive
GoogleSheets
SplitInBatches
ScheduleTrigger
ChainLlm
LmChatGoogleGemini

分类

项目管理
多模态 AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "erQR03J34CgGUlgv",
  "meta": {
    "instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
    "templateCredsSetupCompleted": true
  },
  "name": "AI驱动的施工现场进度追踪器",
  "tags": [],
  "nodes": [
    {
      "id": "da61ca99-96ef-4d45-980a-b345934e1763",
      "name": "由 Github 模型提供支持",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -360,
        -200
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "12714e65-1608-415f-a7ad-cd5f53011d38",
      "name": "AI分析",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        300,
        -200
      ],
      "parameters": {
        "batching": {},
        "messages": {
          "messageValues": [
            {
              "message": "You are an AI construction progress analyst. Analyze the provided daily site photo and summarize the visible construction progress. Focus on structural elements (e.g., foundation, walls, roofing), machinery, materials, and any noticeable changes from previous days if available.  Return the update in 2-3 clear bullet points.  Then suggest the next expected step of construction based on standard workflow.  Format:  Progress Summary: • Point 1 • Point 2  Next Expected Step: <one-line suggestion>  Be concise, use simple language, and avoid speculation if details are unclear."
            }
          ]
        }
      },
      "typeVersion": 1.7
    },
    {
      "id": "a49a82ee-e630-4344-99bc-e97647ae5c6c",
      "name": "将数据追加到表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        676,
        -200
      ],
      "parameters": {
        "range": "Sheet1!A:B",
        "options": {},
        "sheetId": "=uyt543erty65432456yu",
        "operation": "append"
      },
      "credentials": {
        "googleApi": {
          "id": "ScSS2KxGQULuPtdy",
          "name": "Google Sheets- test"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "d478f1a4-023a-49f8-a4ed-84ad03c49714",
      "name": "追踪所有图片",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        80,
        -200
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "477884af-a527-41ad-983e-02f9b82c79bc",
      "name": "列出文件",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -140,
        -200
      ],
      "parameters": {
        "options": {},
        "operation": "list"
      },
      "credentials": {
        "googleApi": {
          "id": "ScSS2KxGQULuPtdy",
          "name": "Google Sheets- test"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "bcf6fcdc-ea52-4ae6-a148-22ae84ecbf73",
      "name": "Google Gemini",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        388,
        20
      ],
      "parameters": {
        "options": {},
        "modelName": "=models/gemini-1.0-pro"
      },
      "credentials": {
        "googlePalmApi": {
          "id": "RvSkIBjP48ORJKhU",
          "name": "Google Gemini(PaLM) Api account - test"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "91e41140-4d9d-466a-8085-34f610a9d4b9",
      "name": "发送邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        900,
        -200
      ],
      "webhookId": "ae4b22c4-3d88-4bd3-86db-07dab410f21e",
      "parameters": {
        "text": "=Construction site progress report is ready",
        "options": {},
        "subject": "Construction Site Progress Report",
        "toEmail": "contractor@gmail.com",
        "fromEmail": "abc@gmail.com",
        "emailFormat": "text"
      },
      "credentials": {
        "smtp": {
          "id": "G1kyF8cSWTZ4vouN",
          "name": "SMTP -test"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "43c14ff9-a3bf-40e7-bb52-95c011799740",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -380,
        -300
      ],
      "parameters": {
        "color": 6,
        "width": 160,
        "height": 260,
        "content": "每日运行工作流以检查新的现场照片"
      },
      "typeVersion": 1
    },
    {
      "id": "ec04c3bb-f1ea-488b-bca7-1cf82f90209a",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        620,
        -300
      ],
      "parameters": {
        "color": 5,
        "width": 200,
        "height": 260,
        "content": "将AI生成的摘要记录到Google Sheet中进行追踪"
      },
      "typeVersion": 1
    },
    {
      "id": "4e2ca085-ce22-4225-9521-3f846d273284",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        40,
        -300
      ],
      "parameters": {
        "color": 3,
        "width": 160,
        "height": 260,
        "content": "循环处理每张图片，分别发送进行AI分析"
      },
      "typeVersion": 1
    },
    {
      "id": "f218dc67-2bf0-4a7c-8efd-9534541c639c",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        -300
      ],
      "parameters": {
        "color": 4,
        "width": 160,
        "height": 260,
        "content": "从云端硬盘文件夹获取最新上传的现场照片"
      },
      "typeVersion": 1
    },
    {
      "id": "46582e78-902c-406e-aa0a-1a09e4b2892c",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        280,
        -300
      ],
      "parameters": {
        "width": 280,
        "height": 260,
        "content": "将每张图片传递给Gemini AI进行施工进度检测"
      },
      "typeVersion": 1
    },
    {
      "id": "d51ee962-ce7f-4e99-9c0b-640c694d5090",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        860,
        -300
      ],
      "parameters": {
        "color": 2,
        "width": 160,
        "height": 260,
        "content": "向相关方发送每日现场进度更新"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "ee36063d-88ba-403f-b408-db4ed188007f",
  "connections": {
    "AI Analysis": {
      "main": [
        [
          {
            "node": "Append data to a sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "List a file": {
      "main": [
        [
          {
            "node": "Tack All Images ",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini": {
      "ai_languageModel": [
        [
          {
            "node": "AI Analysis",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "List a file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Tack All Images ": {
      "main": [
        [
          {
            "node": "AI Analysis",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Tack All Images ",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append data to a sheet": {
      "main": [
        [
          {
            "node": "Send email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

中级 - 项目管理, 多模态 AI

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

通过WhatsApp、邮件和Twilio SMS发送的食品菜单更新通知器
食品菜单更新通知器
If
Set
Code
+7
22 节点Oneclick AI Squad
社交媒体
AI活动与预算编排套件
使用 Claude AI 和 Google Sheets 实现活动策划和预算优化自动化
Code
Merge
Slack
+6
20 节点Oneclick AI Squad
项目管理
LinkedIn和X病毒内容自动引擎
使用AI生成和发布自动创建LinkedIn和X的病毒内容
If
Set
Wait
+26
156 节点Diptamoy Barman
内容创作
医疗设备维护警报系统
使用Google Sheets监控医疗设备并发送WhatsApp和邮件警报
Code
Cron
Wait
+5
14 节点Oneclick AI Squad
项目管理
带跟进与回复追踪的自动邮件群发
带跟进与回复追踪的自动邮件群发
If
Gmail
Switch
+5
11 节点Oneclick AI Squad
社交媒体
向买家发送每日房地产施工更新
通过 Gmail 和 WhatsApp 使用 Google Sheets 发送每日房地产施工更新
If
Set
Filter
+5
19 节点Oneclick AI Squad
项目管理
工作流信息
难度等级
中级
节点数量13
分类2
节点类型8
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Oneclick AI Squad

Oneclick AI Squad

@oneclick-ai

The AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.

外部链接
在 n8n.io 查看 →

分享此工作流