{
  "id": "wrf8Kd0XRbKFEHwR",
  "meta": {
    "instanceId": "0430772da25f7bca29bf5ef2b251086a85fb4096503a6f781526d32befd038d6"
  },
  "name": "会议纪要自动化 (Google Sheets + Gmail)",
  "tags": [
    {
      "id": "3T7uxjPBNibzqJlE",
      "name": "Google",
      "createdAt": "2025-08-18T07:15:32.460Z",
      "updatedAt": "2025-08-18T07:15:32.460Z"
    },
    {
      "id": "7zEwLFClveXBEcdb",
      "name": "google sheet",
      "createdAt": "2025-08-18T07:16:22.756Z",
      "updatedAt": "2025-08-18T07:16:22.756Z"
    },
    {
      "id": "E9IjhPyJvr7DXQgz",
      "name": "meeting minutes",
      "createdAt": "2025-08-18T07:17:07.060Z",
      "updatedAt": "2025-08-18T07:17:07.060Z"
    },
    {
      "id": "WsGNTPBsmCdx55kq",
      "name": "email",
      "createdAt": "2025-08-18T07:16:22.745Z",
      "updatedAt": "2025-08-18T07:16:22.745Z"
    },
    {
      "id": "bg5CwpF83fBHrGAh",
      "name": "Productivity",
      "createdAt": "2025-08-18T07:15:32.499Z",
      "updatedAt": "2025-08-18T07:15:32.499Z"
    },
    {
      "id": "eAzNESqLUWwWMrE9",
      "name": "gmail",
      "createdAt": "2025-08-18T07:16:22.709Z",
      "updatedAt": "2025-08-18T07:16:22.709Z"
    }
  ],
  "nodes": [
    {
      "id": "aecc3b32-343b-421b-b758-e642f5e7c750",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "color": 3,
        "height": 176,
        "content": "## 必需条件"
      },
      "typeVersion": 1
    },
    {
      "id": "ba8eb175-dfc8-4b58-b7ce-31d5ebed6fd0",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        272,
        -352
      ],
      "parameters": {
        "color": 2,
        "width": 416,
        "height": 848,
        "content": "## 1. 工作流触发与数据收集"
      },
      "typeVersion": 1
    },
    {
      "id": "67394444-d561-468f-bc5d-14e7d73e6c48",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        704,
        -352
      ],
      "parameters": {
        "color": 4,
        "width": 560,
        "height": 848,
        "content": "## 2. 发送邮件"
      },
      "typeVersion": 1
    },
    {
      "id": "7722b28d-8289-4b46-838d-6ef72865abed",
      "name": "触发器",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        304,
        336
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "9a808aca-5b56-4d5d-9f60-861e17dd85b8",
      "name": "包含会议纪要的邮件",
      "type": "n8n-nodes-base.gmail",
      "position": [
        928,
        336
      ],
      "webhookId": "9411bee4-d354-40dd-84a2-559bb6beb7bb",
      "parameters": {
        "sendTo": "email",
        "message": "={{$json.html}}",
        "options": {},
        "subject": "Meeting notes today's meeting"
      },
      "typeVersion": 2.1
    },
    {
      "id": "cd26d1d7-ba33-4983-acd4-f2d65f88c413",
      "name": "生成邮件",
      "type": "n8n-nodes-base.code",
      "position": [
        720,
        336
      ],
      "parameters": {
        "jsCode": "const allItems = $input.all();\n\n\nconsole.log(\"Données reçues:\", JSON.stringify(allItems, null, 2));\n\n// build the table\nlet tableRows = '';\nallItems.forEach(item => {\n  tableRows += `\n  <tr>\n    <td>${item.json.Topic || ''}</td>\n    <td>${item.json.Status || ''}</td>\n    <td>${item.json.Owner || ''}</td>\n    <td>${item.json[\"Next Step\"] || ''}</td>\n  </tr>`;\n});\n\n// generate  HTML\nconst html = `\n<!DOCTYPE html>\n<html>\n<head>\n  <style>\n    table {\n      border-collapse: collapse;\n      width: 100%;\n      margin: 20px 0;\n      font-family: Arial, sans-serif;\n    }\n    th, td {\n      border: 1px solid #dddddd;\n      text-align: left;\n      padding: 8px;\n    }\n    th {\n      background-color: #f2f2f2;\n      font-weight: bold;\n    }\n  </style>\n</head>\n<body>\n  <p>Hello,</p>\n  <p>Here are the elements of the meeting:</p>\n  \n  <table>\n    <thead>\n      <tr>\n        <th>Topic</th>\n        <th>Status</th>\n        <th>Owner</th>\n        <th>Next Step</th>\n      </tr>\n    </thead>\n    <tbody>\n      ${tableRows}\n    </tbody>\n  </table>\n  \n  <p>Have a good day.<br/>PM Team</p>\n</body>\n</html>`;\n\nreturn [{ json: { html } }];"
      },
      "typeVersion": 2
    },
    {
      "id": "3f6ccf89-ad6f-4981-b089-03305093a3ff",
      "name": "获取数据",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        512,
        336
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "id",
          "value": "id"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": "url"
        }
      },
      "typeVersion": 4.6
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "ee35c6b7-b5c5-4b38-b126-fa4a6df47265",
  "connections": {
    "Trigger": {
      "main": [
        [
          {
            "node": "Get the data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get the data": {
      "main": [
        [
          {
            "node": "Generate the email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate the email": {
      "main": [
        [
          {
            "node": "Email with meeting minutes",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

常见问题

如何使用这个工作流？

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

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

中级 - 个人效率, 多模态 AI

需要付费吗？

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

会议纪要自动化 (Google Sheets + Gmail)

使用的节点 (7)

分类

如何使用这个工作流？

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

需要付费吗？

相关工作流推荐