8
n8n 中文网amn8n.com

向买家发送每日房地产施工更新

高级

这是一个Project Management领域的自动化工作流，包含 19 个节点。主要使用 If, Set, Filter, WhatsApp, EmailSend 等节点。 通过 Gmail 和 WhatsApp 使用 Google Sheets 发送每日房地产施工更新

前置要求
  • •Google Sheets API 凭证

使用的节点 (19)

If
Set
Filter
WhatsApp
EmailSend
StickyNote
GoogleSheets
ScheduleTrigger

分类

项目管理
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "Dj30tB9fIDgZhHm0",
  "meta": {
    "instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
    "templateCredsSetupCompleted": true
  },
  "name": "向买家发送每日房地产施工更新",
  "tags": [],
  "nodes": [
    {
      "id": "1ee0759b-7485-41cb-acdb-bda40a17f3e5",
      "name": "每日触发器（印度标准时间上午8:00）",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -2040,
        60
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 8
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "640457a6-f3d3-492b-b9ca-7c3d8d0b34f8",
      "name": "设置 Google Sheets 配置",
      "type": "n8n-nodes-base.set",
      "position": [
        -1820,
        60
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "4669b111-8540-4de2-a5f7-672f2ad81e98",
              "name": "Sheet_ID",
              "type": "string",
              "value": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
            },
            {
              "id": "58c89ccb-2e3d-4334-9366-d0b285fdfbd8",
              "name": "Sheet_Name",
              "type": "string",
              "value": "Construction_Reports"
            },
            {
              "id": "1a2b3c4d-5e6f-7g8h-9i0j-k1l2m3n4o5p6",
              "name": "Today_Date",
              "type": "string",
              "value": "={{ $now.format('DD/MM/YYYY') }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "a90e3dc3-fdcd-4d27-b1d1-02943146ad02",
      "name": "读取 Google Sheets 数据",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1600,
        60
      ],
      "parameters": {
        "options": {},
        "sheetName": "={{ $('Set Google Sheet Config').item.json.Sheet_Name }}",
        "documentId": "={{ $('Set Google Sheet Config').item.json.Sheet_ID }}"
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "rgIk6EXVdPbmPYAl",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.4
    },
    {
      "id": "2a48679b-71b1-4479-8080-f3e16dc3498a",
      "name": "筛选今日报告",
      "type": "n8n-nodes-base.filter",
      "position": [
        -1380,
        60
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "7h8i9j0k-1l2m-3n4o-5p6q-r7s8t9u0v1w2",
              "operator": {
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.Date }}",
              "rightValue": "={{ $('Set Google Sheet Config').item.json.Today_Date }}"
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "9f461a8c-2971-44a9-bbbf-b64b9a02ea60",
      "name": "检查是否找到报告",
      "type": "n8n-nodes-base.if",
      "position": [
        -1160,
        60
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "2x3y4z5a-6b7c-8d9e-0f1g-h2i3j4k5l6m7",
              "operator": {
                "type": "number",
                "operation": "gt"
              },
              "leftValue": "={{ $runIndex }}",
              "rightValue": "0"
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "18c77930-ada3-43a7-9835-54a1c6fbd8c2",
      "name": "设置通知接收人",
      "type": "n8n-nodes-base.set",
      "position": [
        -940,
        60
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "0b0969ab-45d1-427c-bac0-bd59a43661d7",
              "name": "Notification_Users",
              "type": "string",
              "value": "user1@gmail.com,user2@gmail.com,projectmanager@company.com"
            },
            {
              "id": "4d5e6f7g-8h9i-0j1k-2l3m-n4o5p6q7r8s9",
              "name": "WhatsApp_Numbers",
              "type": "string",
              "value": "+919876543210,+919876543211,+919876543212"
            },
            {
              "id": "9t0u1v2w-3x4y-5z6a-7b8c-d9e0f1g2h3i4",
              "name": "Admin_Email",
              "type": "string",
              "value": "admin@constructioncompany.com"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "01ee5331-df8e-4fe1-9156-d1c6258b33c8",
      "name": "创建通知内容",
      "type": "n8n-nodes-base.set",
      "position": [
        -720,
        60
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "ad95bad5-c4ac-4864-a83c-06d59d99b415",
              "name": "Report_Summary",
              "type": "string",
              "value": "=📋 **CONSTRUCTION REPORTS SUMMARY - {{ $('Set Google Sheet Config').item.json.Today_Date }}**\n\n{{ $('Filter Today\\'s Reports').all().map(item => `🏗️ **${item.json.Project_Name}**\n👷 Contractor: ${item.json.Contractor_Name}\n📍 Location: ${item.json.Location}\n📊 Progress: ${item.json.Progress_Percentage}%\n⚡ Status: ${item.json.Status}\n📝 Today's Work: ${item.json.Work_Description}\n🚧 Issues: ${item.json.Issues || 'None reported'}\n💰 Budget Status: ${item.json.Budget_Status}\n📅 Next Milestone: ${item.json.Next_Milestone}\n\n---\n`).join('') }}\n\n📊 Total Projects Updated: {{ $('Filter Today\\'s Reports').all().length }}\n⏰ Report Generated: {{ $now.format('DD/MM/YYYY HH:mm:ss') }}"
            },
            {
              "id": "5j6k7l8m-9n0o-1p2q-3r4s-t5u6v7w8x9y0",
              "name": "Email_Subject",
              "type": "string",
              "value": "🏗️ Daily Construction Reports - {{ $('Set Google Sheet Config').item.json.Today_Date }} ({{ $('Filter Today\\'s Reports').all().length }} Projects Updated)"
            },
            {
              "id": "0z1a2b3c-4d5e-6f7g-8h9i-j0k1l2m3n4o5",
              "name": "WhatsApp_Message",
              "type": "string",
              "value": "=🏗️ *Daily Construction Update*\n📅 {{ $('Set Google Sheet Config').item.json.Today_Date }}\n\n📊 *{{ $('Filter Today\\'s Reports').all().length }} Projects Updated Today*\n\n{{ $('Filter Today\\'s Reports').all().map(item => `🔸 *${item.json.Project_Name}*\n   Progress: ${item.json.Progress_Percentage}%\n   Status: ${item.json.Status}\n   Contractor: ${item.json.Contractor_Name}\n\n`).join('') }}For detailed reports, check your email.\n\n_Auto-generated from Construction Reports Sheet_"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "8fe62b99-7e70-4ae0-9ecf-fa5cd5338f10",
      "name": "发送 WhatsApp 通知",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        -500,
        160
      ],
      "webhookId": "f6576fdd-1b46-4617-ae60-31c4636c38fd",
      "parameters": {
        "textBody": "={{ $('Create Notification Content').item.json.WhatsApp_Message }}",
        "operation": "send",
        "phoneNumberId": "=+919876543210",
        "additionalFields": {},
        "recipientPhoneNumber": "+919876543210"
      },
      "credentials": {
        "whatsAppApi": {
          "id": "b0PxTDPdWzznWnfG",
          "name": "WhatsApp-test "
        }
      },
      "typeVersion": 1
    },
    {
      "id": "9576da40-cab9-4a20-b3bb-332696306e30",
      "name": "发送邮件通知",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        -500,
        -40
      ],
      "webhookId": "d0c3ff03-3c95-4d34-b6a2-1c8594fb080b",
      "parameters": {
        "text": "={{ $('Create Notification Content').item.json.Report_Summary }}",
        "options": {},
        "subject": "={{ $('Create Notification Content').item.json.Email_Subject }}",
        "toEmail": "={{ $('Set Notification Recipients').item.json.Notification_Users }}",
        "fromEmail": "reports@constructioncompany.com",
        "emailFormat": "text"
      },
      "credentials": {
        "smtp": {
          "id": "G1kyF8cSWTZ4vouN",
          "name": "SMTP -test"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "47dc08b6-d4b8-4380-af14-81732c6cf598",
      "name": "记录成功通知",
      "type": "n8n-nodes-base.set",
      "position": [
        -280,
        60
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "6p7q8r9s-0t1u-2v3w-4x5y-z6a7b8c9d0e1",
              "name": "Success_Log",
              "type": "string",
              "value": "{{ $now.format('DD/MM/YYYY HH:mm:ss') }} - SUCCESS: Daily construction reports sent to {{ $('Set Notification Recipients').item.json.Notification_Users.split(',').length }} users via Email & WhatsApp. Reports found: {{ $('Filter Today\\'s Reports').all().length }} projects. Sheet: {{ $('Set Google Sheet Config').item.json.Sheet_Name }}"
            },
            {
              "id": "2f3g4h5i-6j7k-8l9m-0n1o-p2q3r4s5t6u7",
              "name": "Log_Status",
              "type": "string",
              "value": "COMPLETED"
            },
            {
              "id": "log-details-001",
              "name": "Projects_Reported",
              "type": "string",
              "value": "={{ $('Filter Today\\'s Reports').all().map(item => item.json.Project_Name).join(', ') }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "17c027f8-e22b-4169-9562-5e9e0c253344",
      "name": "便签 - 触发器",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2080,
        -120
      ],
      "parameters": {
        "width": 180,
        "height": 340,
        "content": "每天印度标准时间上午8:00触发，检查 Google Sheets 中承包商的新施工报告"
      },
      "typeVersion": 1
    },
    {
      "id": "5675361f-8fc5-462b-9591-3b273e5937af",
      "name": "便签 - 配置",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1860,
        -120
      ],
      "parameters": {
        "color": 4,
        "width": 180,
        "height": 340,
        "content": "配置 Google Sheets ID、工作表名称和今日日期以筛选最新报告"
      },
      "typeVersion": 1
    },
    {
      "id": "27d8d7b0-7fa5-4c22-9921-168c46149118",
      "name": "便签 - 读取表格",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1640,
        -120
      ],
      "parameters": {
        "color": 3,
        "width": 180,
        "height": 340,
        "content": "从包含承包商报告的 Google Sheets 读取所有数据，包括项目详情、进度和状态"
      },
      "typeVersion": 1
    },
    {
      "id": "26908522-c63d-4dd8-b50c-459e2e04389c",
      "name": "便签 - 筛选",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1420,
        -120
      ],
      "parameters": {
        "color": 5,
        "width": 180,
        "height": 340,
        "content": "根据日期列筛选表格记录，仅获取今日报告"
      },
      "typeVersion": 1
    },
    {
      "id": "f8cb9405-eb82-4ebc-91c6-e1d332ba3717",
      "name": "便签 - 检查报告",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1200,
        -120
      ],
      "parameters": {
        "width": 180,
        "height": 340,
        "content": "检查今日是否找到任何报告。如果是，发送通知；如果否，向管理员发送警报"
      },
      "typeVersion": 1
    },
    {
      "id": "75105320-736f-4c7e-bbcb-8461f26aac49",
      "name": "便签 - 联系人",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -980,
        -120
      ],
      "parameters": {
        "color": 4,
        "width": 180,
        "height": 340,
        "content": "应接收每日施工报告通知用户的邮件和 WhatsApp 联系人列表"
      },
      "typeVersion": 1
    },
    {
      "id": "5a93ee43-7991-434f-a0d1-da6950826479",
      "name": "便签 - 发送通知",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -540,
        -160
      ],
      "parameters": {
        "color": 3,
        "width": 180,
        "height": 500,
        "content": "通过邮件和 WhatsApp 向所有用户发送包含项目摘要的详细施工报告"
      },
      "typeVersion": 1
    },
    {
      "id": "d4bd125e-a980-479b-9ab2-e2ba7cb01753",
      "name": "便签 - 日志记录",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        -120
      ],
      "parameters": {
        "color": 2,
        "width": 180,
        "height": 340,
        "content": "记录所有通知活动，包括时间戳、接收人数量和项目详情，用于审计追踪"
      },
      "typeVersion": 1
    },
    {
      "id": "d13a8eb1-946d-445a-a837-32a4be084e87",
      "name": "便签 - 发送通知1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -760,
        -120
      ],
      "parameters": {
        "color": 5,
        "width": 180,
        "height": 340,
        "content": "创建详细施工报告"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "eadd981e-6c76-4e5d-81ae-864311a818d1",
  "connections": {
    "Check If Reports Found": {
      "main": [
        [
          {
            "node": "Set Notification Recipients",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    },
    "Filter Today's Reports": {
      "main": [
        [
          {
            "node": "Check If Reports Found",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Google Sheet Data": {
      "main": [
        [
          {
            "node": "Filter Today's Reports",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Email Notification": {
      "main": [
        [
          {
            "node": "Log Successful Notifications",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Google Sheet Config": {
      "main": [
        [
          {
            "node": "Read Google Sheet Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send WhatsApp Notification": {
      "main": [
        [
          {
            "node": "Log Successful Notifications",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Notification Content": {
      "main": [
        [
          {
            "node": "Send WhatsApp Notification",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send Email Notification",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Trigger (8:00 AM IST)": {
      "main": [
        [
          {
            "node": "Set Google Sheet Config",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Notification Recipients": {
      "main": [
        [
          {
            "node": "Create Notification Content",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

高级 - 项目管理

需要付费吗？

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

相关工作流推荐

医疗设备维护警报系统
使用Google Sheets监控医疗设备并发送WhatsApp和邮件警报
Code
Cron
Wait
+5
14 节点Oneclick AI Squad
项目管理
绩效评估调度与提醒
使用Google Sheets、日历、邮件和Slack自动化绩效评估流程
If
Set
Code
+7
16 节点Oneclick AI Squad
人力资源
通过WhatsApp、邮件和Twilio SMS发送的食品菜单更新通知器
食品菜单更新通知器
If
Set
Code
+7
22 节点Oneclick AI Squad
社交媒体
AI驱动的施工现场进度追踪器
使用 Google Gemini AI、Drive 照片和 Sheets 跟踪施工现场进度
Email Send
Google Drive
Google Sheets
+5
13 节点Oneclick AI Squad
项目管理
面向财务与会计的 AI 驱动发票提醒与付款追踪器
基于AI的发票提醒与付款追踪器，专为财务与会计设计
If
Set
Code
+8
35 节点Oneclick AI Squad
发票处理
自动化API正常运行时间监控与即时停机警报
API正常运行时间监控，含WhatsApp警报和Google表格管理
If
Code
Wait
+6
17 节点Oneclick AI Squad
开发运维
工作流信息
难度等级
高级
节点数量19
分类1
节点类型8
难度说明

适合高级用户，包含 16+ 个节点的复杂工作流

作者
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 查看 →

分享此工作流