优雅交付 - 服务排期与路线规划器（适配Notion/Sheets）

• •HTTP Webhook 端点（n8n 会自动生成）
• •Telegram Bot Token
• •可能需要目标 API 的认证凭证

{
  "name": "优雅交付 - 服务排期与路线规划器（适配 Notion/Sheets）",
  "nodes": [
    {
      "name": "📝 说明（请先阅读）",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        20,
        -20
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "name": "🧰 设置与凭证",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        20,
        440
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "name": "📦 Notion/Sheets 数据结构",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        820,
        -20
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "name": "🧭 数据映射器（示例载荷）",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        820,
        380
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "name": "Webhook（预订）",
      "type": "n8n-nodes-base.webhook",
      "position": [
        20,
        920
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "name": "解析预订",
      "type": "n8n-nodes-base.function",
      "position": [
        300,
        920
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "name": "地理编码（OSM Nominatim）",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        560,
        860
      ],
      "parameters": {},
      "typeVersion": 4
    },
    {
      "name": "格式化地理编码",
      "type": "n8n-nodes-base.function",
      "position": [
        800,
        860
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "name": "合并数据",
      "type": "n8n-nodes-base.merge",
      "position": [
        1040,
        920
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "name": "生成摘要与链接",
      "type": "n8n-nodes-base.function",
      "position": [
        1260,
        920
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "name": "Telegram → 所有者提醒",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1500,
        800
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "name": "等待至开始前1小时",
      "type": "n8n-nodes-base.wait",
      "position": [
        1500,
        1040
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "name": "邮件 → 客户（到达前通知）",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        1740,
        1040
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "name": "响应Webhook",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        1740,
        800
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "name": "✨ 可选附加功能",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2060,
        760
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {},
  "staticData": {},
  "connections": {
    "Merge Data": {
      "main": [
        [
          {
            "node": "Build Summary & Links",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse Booking": {
      "main": [
        [
          {
            "node": "Geocode (OSM Nominatim)",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Merge Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Geocode": {
      "main": [
        [
          {
            "node": "Merge Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook (Bookings)": {
      "main": [
        [
          {
            "node": "Parse Booking",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait until 1h before": {
      "main": [
        [
          {
            "node": "Email → Client (Pre-arrival)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Summary & Links": {
      "main": [
        [
          {
            "node": "Telegram → Owner Alert",
            "type": "main",
            "index": 0
          },
          {
            "node": "Wait until 1h before",
            "type": "main",
            "index": 0
          },
          {
            "node": "Respond to Webhook",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Geocode (OSM Nominatim)": {
      "main": [
        [
          {
            "node": "Format Geocode",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}