会议已预订 - 发送至新闻简报和CRM
中级
这是一个AI, Marketing, IT Ops领域的自动化工作流，包含 9 个节点。主要使用 Set, SplitOut, Telegram, CalTrigger, HttpRequest 等节点，结合人工智能技术实现智能自动化。 使用Google Sheets、Beehiiv和Telegram自动化Cal.com会议参与者管理
前置要求
- •Telegram Bot Token
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "xe9sXQUc7yW8P8im",
"meta": {
"instanceId": "9219ebc7795bea866f70aa3d977d54417fdf06c41944be95e20cfb60f992db19",
"templateCredsSetupCompleted": true
},
"name": "Meeting booked - to newsletter and CRM",
"tags": [
{
"id": "55FGhjeaCcjBUam6",
"name": "1node",
"createdAt": "2025-04-30T08:13:16.484Z",
"updatedAt": "2025-04-30T08:13:16.484Z"
},
{
"id": "0eaHel3jWsgsvzT6",
"name": "template",
"createdAt": "2025-04-30T08:13:16.487Z",
"updatedAt": "2025-04-30T08:13:16.487Z"
},
{
"id": "33yuvdx4oQ05TZoD",
"name": "newsletter",
"createdAt": "2025-05-02T08:18:43.148Z",
"updatedAt": "2025-05-02T08:18:43.148Z"
}
],
"nodes": [
{
"id": "715f9c0b-58a6-46b9-b732-334cc2fb3a60",
"name": "Split Attendees",
"type": "n8n-nodes-base.splitOut",
"position": [
-460,
-140
],
"parameters": {
"options": {},
"fieldToSplitOut": "attendees"
},
"typeVersion": 1
},
{
"id": "171ed51e-6277-46d3-9037-8b2722ca06d0",
"name": "Add users",
"type": "n8n-nodes-base.googleSheets",
"position": [
200,
-140
],
"parameters": {
"columns": {
"value": {
"title": "={{ $('on New Booking').item.json.eventTitle }}",
"length": "={{ $('on New Booking').item.json.length }}",
"timeZone": "={{ $json.timeZone }}",
"createdAt": "={{ $('on New Booking').item.json.createdAt }}",
"attendeeName": "={{ $json.name }}",
"meetingStart": "={{ $('on New Booking').item.json.startTime }}",
"attendeeEmail": "={{ $json.email }}"
},
"schema": [
{
"id": "createdAt",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "createdAt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "meetingStart",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "meetingStart",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "attendeeName",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "attendeeName",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "attendeeEmail",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "attendeeEmail",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "timeZone",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "timeZone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "length",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "length",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1SJosfoM-WZEimBQTz1mu65xiyuq9bHII0Igd1mgCcq0/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1SJosfoM-WZEimBQTz1mu65xiyuq9bHII0Igd1mgCcq0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1SJosfoM-WZEimBQTz1mu65xiyuq9bHII0Igd1mgCcq0/edit?usp=drivesdk",
"cachedResultName": "Calendar bookings"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "twZdLFsI3kTnqtpG",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "3b22d814-fe80-4c5b-814f-4e2666c96ca3",
"name": "on New Booking",
"type": "n8n-nodes-base.calTrigger",
"position": [
-680,
-140
],
"webhookId": "0b5ccb99-8c0a-47e4-a970-403e607c89ed",
"parameters": {
"events": [
"BOOKING_CREATED"
],
"options": {}
},
"credentials": {
"calApi": {
"id": "3JuO2rbGXKSX0VL9",
"name": "Cal account"
}
},
"typeVersion": 2
},
{
"id": "020e7fc5-7f72-434f-8a84-15b177237146",
"name": "Add subscriber",
"type": "n8n-nodes-base.httpRequest",
"position": [
420,
-140
],
"parameters": {
"url": "=https://api.beehiiv.com/v2/publications/{{ $('set data').item.json.publicationId }}/subscriptions",
"method": "POST",
"options": {},
"sendBody": true,
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "email",
"value": "={{ $('Split Attendees').item.json.email }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "=Bearer {{ $('set data').item.json.beehiivAPI }}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "35678a8f-e844-484f-b7f3-7df5a80f4a2d",
"name": "Set Attendee",
"type": "n8n-nodes-base.set",
"position": [
-20,
-140
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "70fc23eb-95b5-43ba-9067-8d834d440684",
"name": "name",
"type": "string",
"value": "={{ $json.name }}"
},
{
"id": "2aa7594d-f6fd-4437-a7b0-ad3e23b0e719",
"name": "email",
"type": "string",
"value": "={{ $json.email }}"
},
{
"id": "7a2f22da-04e1-4507-b135-1fdfdcdda77f",
"name": "timeZone",
"type": "string",
"value": "={{ $json.timeZone }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "678b7ca8-2ecf-44b4-a420-e40600d09a74",
"name": "notify in channel",
"type": "n8n-nodes-base.telegram",
"position": [
640,
-140
],
"webhookId": "7ade83ec-58fa-4b43-aa3b-93bb0d9ae712",
"parameters": {
"text": "=📅 New meeting booked\n\nEvent name: {{ $('Add users').item.json.title }}\nStart Date: {{ $('Add users').item.json.meetingStart }} UTC\nName: {{ $('Add users').item.json.attendeeName }}\nEmail: {{ $('Add users').item.json.attendeeEmail }}\nUser time zone: {{ $('Add users').item.json.timeZone }}",
"chatId": "={{ $('set data').item.json.chatID }}",
"additionalFields": {
"appendAttribution": false
}
},
"credentials": {
"telegramApi": {
"id": "IgrntTxsoDphh19z",
"name": "Telegram account"
}
},
"typeVersion": 1.2
},
{
"id": "1e23785f-1a3d-4d0c-a7d1-1ebc6209d5c8",
"name": "set data",
"type": "n8n-nodes-base.set",
"position": [
-240,
-140
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "797d5771-b242-47f5-a0c6-dc3a1a8fb15b",
"name": "chatID",
"type": "string",
"value": "yourChatId"
},
{
"id": "1c3239e8-6fe2-48ad-9083-04d108a95aec",
"name": "beehiivAPI",
"type": "string",
"value": "yourAPIkey"
},
{
"id": "8c94a712-93a6-48de-8a27-93c5ed0e68eb",
"name": "publicationId",
"type": "string",
"value": "yourBeehiivPublicationId"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "cf66eff2-ca4d-4e52-b476-26334a82275f",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-330,
-460
],
"parameters": {
"width": 280,
"height": 480,
"content": "## Define your parameters\n- Find your telegram chat id to get notified in a private channel (bot must be added as admin)\n- Create an account on [Beehiiv]() and get your api key\n- Get your publication id from your newsletter which will be parsed in the \"Add subscriber\" url endpoint"
},
"typeVersion": 1
},
{
"id": "cc33ebc8-d966-4c17-ab4d-8fa6dde58c37",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1160,
-380
],
"parameters": {
"width": 400,
"height": 540,
"content": "## How it works\nThis workflow allows you to add each meeting guest into Google Sheets, adding one row for each guest and consequently adding those users to your newsletter on Beehiiv.\n\n## Set up steps\n\n- Create an account on [Cal.com](https://refer.cal.com/1node)\n- Create a new webhook on [Cal.com](https://refer.cal.com/1node) and send a test event to the URL that appears in the first node. You will get test data that you can pin to set the rest of the workflow.\n- For [Beehiiv](https://www.beehiiv.com?via=1node-ai) you will need to get the publication id from the account plus the api key. You will find those on your account settings. Define the publication id on the \"set data\" node, together with your Telegram chat id, if you wish to notify yourself in a private channel when a new subscriber is added.\n\nEnjoy building!\n\nAitor\n[1 Node](https://1node.ai)"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"callerPolicy": "workflowsFromSameOwner",
"errorWorkflow": "qFOYM3IA9QZ7fMym",
"executionOrder": "v1"
},
"versionId": "64184a3c-c62a-4bb1-ae93-d7b6d22d85a2",
"connections": {
"1e23785f-1a3d-4d0c-a7d1-1ebc6209d5c8": {
"main": [
[
{
"node": "35678a8f-e844-484f-b7f3-7df5a80f4a2d",
"type": "main",
"index": 0
}
]
]
},
"171ed51e-6277-46d3-9037-8b2722ca06d0": {
"main": [
[
{
"node": "020e7fc5-7f72-434f-8a84-15b177237146",
"type": "main",
"index": 0
}
]
]
},
"35678a8f-e844-484f-b7f3-7df5a80f4a2d": {
"main": [
[
{
"node": "171ed51e-6277-46d3-9037-8b2722ca06d0",
"type": "main",
"index": 0
}
]
]
},
"020e7fc5-7f72-434f-8a84-15b177237146": {
"main": [
[
{
"node": "678b7ca8-2ecf-44b4-a420-e40600d09a74",
"type": "main",
"index": 0
}
]
]
},
"3b22d814-fe80-4c5b-814f-4e2666c96ca3": {
"main": [
[
{
"node": "715f9c0b-58a6-46b9-b732-334cc2fb3a60",
"type": "main",
"index": 0
}
]
]
},
"715f9c0b-58a6-46b9-b732-334cc2fb3a60": {
"main": [
[
{
"node": "1e23785f-1a3d-4d0c-a7d1-1ebc6209d5c8",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 人工智能, 营销, IT 运维
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
CSV到HubSpot上传器（动态字段映射与Google Sheets集成）
具有动态字段映射和Google Sheets集成的CSV到HubSpot上传器
If
Set
Code
+
If
Set
Code
36 节点PollupAI
人工智能
OCR Telegram - SAP
基于Telegram、GPT-4o、OCR和SAP集成的自动化发票处理
Set
Code
Wait
+
Set
Code
Wait
29 节点Raquel Giugliano
人工智能
使用GPT-4o、Google日历和Gmail自动生成会议参与者研究
使用GPT-4o、Google日历和Gmail自动生成会议参与者研究
If
Set
Gmail
+
If
Set
Gmail
18 节点Adam Janes
人工智能
构建与销售AI自动化与智能体
构建与销售AI自动化与智能体
If
Set
Wait
+
If
Set
Wait
74 节点NICKYAI
其他
自动化新闻到简报AI代理v13
AI新闻研究团队：24/7简报自动化，含Perplexity引用
Set
Code
Gmail
+
Set
Code
Gmail
37 节点Derek Cheung
产品
AI新闻简报构建器：使用Dumpling AI抓取网站，GPT-4o摘要
AI新闻简报构建器：Dumpling AI抓取网站，GPT-4o摘要
Set
Code
Gmail
+
Set
Code
Gmail
10 节点Yang
人工智能
工作流信息
难度等级
中级
节点数量9
分类3
节点类型7
作者
Aitor | 1node.ai
@aitoralonsoHi, I’m Aitor, cofounder of 1node.ai. We help businesses integrate full-scale AI solutions that save time, cut costs, and increase revenue. Guaranteed. Need help building smarter workflows? Visit 1node.ai and let's connect.
外部链接
在 n8n.io 查看 →
分享此工作流