8
n8n 中文网amn8n.com

自动化Google日历事件创建和AI驱动跟进建议

高级

这是一个Lead Nurturing, AI Chatbot领域的自动化工作流,包含 33 个节点。主要使用 Set, Code, Wait, Gmail, Filter 等节点。 通过WhatsApp和邮件的Google日历事件与Gemini AI跟进建议

前置要求
  • Google 账号和 Gmail API 凭证
  • Google Sheets API 凭证
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "wbeBVcWnoiefTvp5",
  "meta": {
    "instanceId": "cb9a1e5321767b6316634728341237e564b2587ab15b74ca0a89eb02a53484d6",
    "templateCredsSetupCompleted": true
  },
  "name": "自动化 Google Calendar 事件创建和 OpenAI 驱动的跟进提案",
  "tags": [],
  "nodes": [
    {
      "id": "1a126147-47b1-4ffd-9494-4d9222d5002b",
      "name": "遍历项目",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -240,
        528
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "0d24a4c9-984f-4ad7-ae80-1825d2004809",
      "name": "创建事件",
      "type": "n8n-nodes-base.googleCalendar",
      "position": [
        432,
        448
      ],
      "parameters": {
        "end": "={{ $json.formatted }}",
        "calendar": {
          "__rl": true,
          "mode": "list",
          "value": "e21dbf6b634115581d14738bf4a5f4d7345da12474fde143738955b247276b96@group.calendar.google.com",
          "cachedResultName": "Sales - Send WhatsApp reminder"
        },
        "remindersUi": {
          "remindersValues": [
            {
              "method": "email",
              "minutes": 30
            }
          ]
        },
        "additionalFields": {
          "color": "3",
          "summary": "={{ $json.title }}",
          "location": "={{ $json.location }}",
          "attendees": [],
          "description": "={{ $json.description }}",
          "sendUpdates": "all"
        },
        "useDefaultReminders": "={{ false }}"
      },
      "credentials": {
        "googleCalendarOAuth2Api": {
          "id": "mcPtmcUSueXxIEm8",
          "name": "Google Calendar account"
        }
      },
      "typeVersion": 1.3
    },
    {
      "id": "87939508-6c62-499f-ae9a-813cac137c57",
      "name": "日期和时间",
      "type": "n8n-nodes-base.dateTime",
      "position": [
        -16,
        448
      ],
      "parameters": {
        "date": "={{ $json['end time'] }}",
        "format": "custom",
        "options": {
          "includeInputFields": true
        },
        "operation": "formatDate",
        "customFormat": "yyyy-MM-dd HH:mm:ss ZZZZ"
      },
      "typeVersion": 2
    },
    {
      "id": "ab2713e8-6ece-4a98-ab6c-bab90f7196f5",
      "name": "代码",
      "type": "n8n-nodes-base.code",
      "position": [
        176,
        448
      ],
      "parameters": {
        "jsCode": "const items = $input.all(); // Get all rows\nconst pad = n => String(n).padStart(2, '0');\n\nreturn items.map(item => {\n    const input = item.json;\n\n    // Convert formattedDate (UTC) to JS Date\n    const d = new Date(input.formattedDate);\n\n    // Build ISO string in UTC\n    const isoUTC = `${d.getUTCFullYear()}-${pad(d.getUTCMonth() + 1)}-${pad(d.getUTCDate())}T` +\n                   `${pad(d.getUTCHours())}:${pad(d.getUTCMinutes())}:${pad(d.getUTCSeconds())}Z`;\n\n    return {\n        json: {\n            ...input,\n            formatted: isoUTC\n        }\n    };\n});\n"
      },
      "typeVersion": 2
    },
    {
      "id": "9d212fd1-4189-48b7-92d2-e4e8241281c0",
      "name": "获取过去事件",
      "type": "n8n-nodes-base.googleCalendar",
      "position": [
        -528,
        1728
      ],
      "parameters": {
        "options": {},
        "timeMax": "={{ $now.minus({ day: 0 }) }}",
        "timeMin": "={{ $now.minus({ day: 4 }) }}",
        "calendar": {
          "__rl": true,
          "mode": "list",
          "value": "e21dbf6b634115581d14738bf4a5f4d7345da12474fde143738955b247276b96@group.calendar.google.com",
          "cachedResultName": "Sales - Send WhatsApp reminder"
        },
        "operation": "getAll",
        "returnAll": true
      },
      "credentials": {
        "googleCalendarOAuth2Api": {
          "id": "mcPtmcUSueXxIEm8",
          "name": "Google Calendar account"
        }
      },
      "typeVersion": 1.3
    },
    {
      "id": "094e8163-7dd2-4bc3-a59b-62a2d57749ec",
      "name": "标记为已查看",
      "type": "n8n-nodes-base.removeDuplicates",
      "position": [
        -304,
        1728
      ],
      "parameters": {
        "options": {},
        "operation": "removeItemsSeenInPreviousExecutions",
        "dedupeValue": "={{ $json.id }}"
      },
      "typeVersion": 2
    },
    {
      "id": "27f7ddbf-0341-47cc-9da3-dbadbd1e8110",
      "name": "计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -688,
        528
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "minutes"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "a67ee294-2d4f-46a8-bbb7-c08e0be2a407",
      "name": "从表格中获取",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -464,
        528
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupColumn": "status"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DSRrIDvw-Q9NugRK3eT7GMa0kwe0QnGhdySnqq1_kJU/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1DSRrIDvw-Q9NugRK3eT7GMa0kwe0QnGhdySnqq1_kJU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DSRrIDvw-Q9NugRK3eT7GMa0kwe0QnGhdySnqq1_kJU/edit?usp=drivesdk",
          "cachedResultName": "Sales - Send WhatsApp reminder"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "gFH3Wjq6yYqSEAei",
          "name": "Google Sheets"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "e5681977-acb6-4d64-a2f9-22233080e9a6",
      "name": "在表格中更新状态",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        880,
        544
      ],
      "parameters": {
        "columns": {
          "value": {
            "status": "checked",
            "row_number": "={{ $('Get in sheet').item.json.row_number }}",
            " reminder status": "sent"
          },
          "schema": [
            {
              "id": "title",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "description",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "location",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "location",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "color_number",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "color_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "start time",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "start time",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "end time",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "end time",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": " reminder status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": " reminder status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "status",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "row_number"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DSRrIDvw-Q9NugRK3eT7GMa0kwe0QnGhdySnqq1_kJU/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1DSRrIDvw-Q9NugRK3eT7GMa0kwe0QnGhdySnqq1_kJU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DSRrIDvw-Q9NugRK3eT7GMa0kwe0QnGhdySnqq1_kJU/edit?usp=drivesdk",
          "cachedResultName": "Sales - Send WhatsApp reminder"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "gFH3Wjq6yYqSEAei",
          "name": "Google Sheets"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "2ee3f43e-6710-42d5-a022-28aa3090ce27",
      "name": "Rapiwa",
      "type": "n8n-nodes-rapiwa.rapiwa",
      "position": [
        656,
        352
      ],
      "parameters": {
        "number": "88017XXX63400",
        "message": "=Hi, just create “{{ $json.summary }}” meeting scheduled for {{ $json.end.dateTime }}. Please let me know if this time still works for you. Looking forward to it!",
        "productOperation": "promo"
      },
      "credentials": {
        "rapiwaApi": {
          "id": "ge5WDOaDo4d1hBpU",
          "name": "Rapiwa account 2"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "f8338ab0-1bc5-4ac1-b640-cbdbf973e1d7",
      "name": "计划触发器1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -752,
        1728
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "minutes"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "b743d3bf-5150-42e4-9db8-250785fda332",
      "name": "仅限跟进",
      "type": "n8n-nodes-base.filter",
      "position": [
        144,
        1616
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "73f38d1b-75c6-4372-8e81-a2db61b045a8",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "0328dfd5-0d27-4e83-93c9-c2ae879abd47",
      "name": "输出",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        608,
        1840
      ],
      "parameters": {
        "schemaType": "manual",
        "inputSchema": "{\n  \"type\": \"object\",\n  \"properties\": {\n    \"slots\": {\n      \"type\": \"array\",\n      \"items\": {\n        \"type\": \"object\",\n        \"properties\": {\n          \"start\": { \"type\": \"string\" },\n          \"end\": { \"type\": \"string\" }\n        }\n      }\n    }\n  }\n}"
      },
      "typeVersion": 1.2
    },
    {
      "id": "7509af23-9d83-4b30-b896-ac289609b3f8",
      "name": "可用性",
      "type": "n8n-nodes-base.googleCalendarTool",
      "position": [
        496,
        1840
      ],
      "parameters": {
        "options": {
          "timezone": {
            "__rl": true,
            "mode": "id",
            "value": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Timezone', ``, 'string') }}",
            "__regex": "([-+/_a-zA-Z0-9]*)"
          }
        },
        "timeMax": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('End_Time', ``, 'string') }}",
        "timeMin": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Start_Time', ``, 'string') }}",
        "calendar": {
          "__rl": true,
          "mode": "list",
          "value": "e21dbf6b634115581d14738bf4a5f4d7345da12474fde143738955b247276b96@group.calendar.google.com",
          "cachedResultName": "Sales - Send WhatsApp reminder"
        },
        "resource": "calendar"
      },
      "credentials": {
        "googleCalendarOAuth2Api": {
          "id": "mcPtmcUSueXxIEm8",
          "name": "Google Calendar account"
        }
      },
      "typeVersion": 1.3
    },
    {
      "id": "8a31bf27-84f8-4e48-8b06-bdf10fb926d3",
      "name": "生成消息",
      "type": "n8n-nodes-base.set",
      "position": [
        832,
        1616
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "cf09c95c-f25e-4fd7-bade-a0feaeaffb3b",
              "name": "message",
              "type": "string",
              "value": "=Here's are a few available slots to book the next meeting.\n{{\n$json.output.slots\n  .filter(slot => !DateTime.fromISO(slot.start).isWeekend())\n  .map(slot => `* ${DateTime.fromISO(slot.start).format('cccc, DDD @ hh:mm')} - ${DateTime.fromISO(slot.end).format('hh:mm')}`)\n.join('\\n')\n}}\n\nLet me know which I should book or let me know if it's okay to dismiss."
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "fda54f21-bceb-4649-ab68-94e2a6f11887",
      "name": "循环遍历项目1",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -80,
        1728
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "8ed45b86-7a56-4301-8e32-1fc2cf39c50d",
      "name": "等待",
      "type": "n8n-nodes-base.wait",
      "position": [
        1104,
        624
      ],
      "webhookId": "adc885e1-5488-418a-87db-0069784d2423",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "1ebb876e-9abd-48fe-8f85-2cdbe1c8e5d0",
      "name": "等待1",
      "type": "n8n-nodes-base.wait",
      "position": [
        1280,
        1824
      ],
      "webhookId": "143615ee-8408-410a-aed1-854c061259e1",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "d1a19978-cb34-4bdb-9635-abdcb248c059",
      "name": "Rapiwa1",
      "type": "n8n-nodes-rapiwa.rapiwa",
      "position": [
        1056,
        1520
      ],
      "parameters": {
        "number": "8801XXX3400",
        "message": "={{ $json.message }}",
        "productOperation": "promo"
      },
      "credentials": {
        "rapiwaApi": {
          "id": "ge5WDOaDo4d1hBpU",
          "name": "Rapiwa account 2"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "af14ad3b-414f-41b7-9558-817f64e3bce6",
      "name": "发送消息",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1056,
        1712
      ],
      "webhookId": "9d9eeca6-ece8-4495-8d0f-db0eda3fca8a",
      "parameters": {
        "sendTo": "your mail address",
        "message": "={{ $json.message }}",
        "options": {},
        "subject": "={{ $json.message.split(\" \").slice(0, 10).join(\" \") }}",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "nLDXXLCx9bNCHuNe",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "dd63cc9b-423b-433b-a4f0-4d9ddf5f9a32",
      "name": "发送消息1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        656,
        544
      ],
      "webhookId": "9d9eeca6-ece8-4495-8d0f-db0eda3fca8a",
      "parameters": {
        "sendTo": "your mail address",
        "message": "=Hi, just create “{{ $json.summary }}” meeting scheduled for {{ $json.end.dateTime }}. Please let me know if this time still works for you. Looking forward to it!",
        "options": {},
        "subject": "=Meeting scheduled for {{ $json.end.dateTime }}",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "nLDXXLCx9bNCHuNe",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "92e79917-d2bc-478a-ae1a-7dc118b5c8a6",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -784,
        320
      ],
      "parameters": {
        "width": 496,
        "height": 368,
        "content": "## 计划触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "60679101-9a93-4fc9-b5c1-8e851ea62cea",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -128,
        96
      ],
      "parameters": {
        "width": 480,
        "height": 512,
        "content": "## 日期和时间"
      },
      "typeVersion": 1
    },
    {
      "id": "2a63a61c-82f4-441a-ae87-0a17837f16dd",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        272
      ],
      "parameters": {
        "width": 256,
        "height": 336,
        "content": "## 创建事件"
      },
      "typeVersion": 1
    },
    {
      "id": "80921e5e-4391-4c94-8f69-5ee8ded1093e",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        640,
        16
      ],
      "parameters": {
        "width": 608,
        "height": 784,
        "content": "## Rapiwa"
      },
      "typeVersion": 1
    },
    {
      "id": "eb087842-bda1-474d-81fc-39b2d6ddf998",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        1008
      ],
      "parameters": {
        "width": 1056,
        "height": 992,
        "content": "## 会议助手"
      },
      "typeVersion": 1
    },
    {
      "id": "bb0dd99d-a763-49ab-9d23-69f9fefb788d",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -800,
        1488
      ],
      "parameters": {
        "width": 672,
        "height": 400,
        "content": "## 获取近期会议"
      },
      "typeVersion": 1
    },
    {
      "id": "3c133a36-4bbc-4b54-972b-1cb2f7ded3c5",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        1440
      ],
      "parameters": {
        "width": 272,
        "height": 384,
        "content": "## 仅限跟进"
      },
      "typeVersion": 1
    },
    {
      "id": "7f07047f-eae3-4586-92a7-9ada810b5686",
      "name": "会议助手",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        416,
        1616
      ],
      "parameters": {
        "text": "=### Details of the previous call as following\ntitle: {{ $json.summary }}\ndate: {{ $json.start.dateTime }} {{ $json.start.timeZone }}\nduration: {{ DateTime.fromISO($json.end.dateTime).diffTo(DateTime.fromISO($json.start.dateTime), 'minutes') }} minutes",
        "options": {
          "systemMessage": "=You are a calendar availability assistant. Analyse the previous meeting and help me find a similar available slot for the next meeting.\n* take into consideration the day, time of day and duration of the previous meeting and try to set the same or similar for the next\n* next meeting should be in the future.\n* return a list of available slots so that I can forward them to the user.\n\nToday's date is {{ $now }}."
        },
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 1.7
    },
    {
      "id": "0b730f8b-d92c-41a5-8648-a6179e649ba0",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -816,
        880
      ],
      "parameters": {
        "color": 7,
        "width": 2256,
        "height": 1136,
        "content": "# 提醒事件"
      },
      "typeVersion": 1
    },
    {
      "id": "ffc11e3c-51c2-47cc-8803-8c319682ddb2",
      "name": "便签8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -800,
        -112
      ],
      "parameters": {
        "color": 7,
        "width": 2064,
        "height": 928,
        "content": "# 创建事件"
      },
      "typeVersion": 1
    },
    {
      "id": "22b3938e-1a95-465f-b33d-6ed38f4f0500",
      "name": "便签10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2064,
        -112
      ],
      "parameters": {
        "width": 1216,
        "height": 1632,
        "content": "# 自动化 Google Calendar 事件创建和 OpenAI 驱动的跟进提案"
      },
      "typeVersion": 1
    },
    {
      "id": "fe0314f4-e859-46a1-82cf-c2af6864df45",
      "name": "OpenAI",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        400,
        1840
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "typeVersion": 1.2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "callerPolicy": "workflowsFromSameOwner",
    "availableInMCP": false,
    "executionOrder": "v1"
  },
  "versionId": "9b84c33b-5b41-4b20-a9a5-e2a58c57c527",
  "connections": {
    "Code": {
      "main": [
        [
          {
            "node": "Create an event",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait1": {
      "main": [
        [
          {
            "node": "Loop Over Items1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI": {
      "ai_languageModel": [
        [
          {
            "node": "Meeting Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Output": {
      "ai_outputParser": [
        [
          {
            "node": "Meeting Agent",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Rapiwa": {
      "main": [
        []
      ]
    },
    "Rapiwa1": {
      "main": [
        []
      ]
    },
    "Date & Time": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Availability": {
      "ai_tool": [
        [
          {
            "node": "Meeting Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Get in sheet": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Mark as Seen": {
      "main": [
        [
          {
            "node": "Loop Over Items1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Meeting Agent": {
      "main": [
        [
          {
            "node": "Generate Message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a message": {
      "main": [
        [
          {
            "node": "Wait1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create an event": {
      "main": [
        [
          {
            "node": "Rapiwa",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send a message1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Past Events": {
      "main": [
        [
          {
            "node": "Mark as Seen",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Date & Time",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Only Follow Ups": {
      "main": [
        [
          {
            "node": "Meeting Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a message1": {
      "main": [
        [
          {
            "node": "Update status in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Message": {
      "main": [
        [
          {
            "node": "Rapiwa1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items1": {
      "main": [
        [],
        [
          {
            "node": "Only Follow Ups",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger1": {
      "main": [
        [
          {
            "node": "Get Past Events",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update status in sheet": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级 - 客户培育, AI 聊天机器人

需要付费吗?

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

工作流信息
难度等级
高级
节点数量33
分类2
节点类型17
难度说明

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

外部链接
在 n8n.io 查看

分享此工作流