Reunión reservada - Enviar al boletín informativo y al CRM
Intermedio
Este es unAI, Marketing, IT Opsflujo de automatización del dominio deautomatización que contiene 9 nodos.Utiliza principalmente nodos como Set, SplitOut, Telegram, CalTrigger, HttpRequest, combinando tecnología de inteligencia artificial para lograr automatización inteligente. Automatización de la gestión de participantes en reuniones de Cal.com con Google Sheets, Beehiiv y Telegram
Requisitos previos
- •Bot Token de Telegram
- •Pueden requerirse credenciales de autenticación para la API de destino
- •Credenciales de API de Google Sheets
Nodos utilizados (9)
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
"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": "Dividir Asistentes",
"type": "n8n-nodes-base.splitOut",
"position": [
-460,
-140
],
"parameters": {
"options": {},
"fieldToSplitOut": "attendees"
},
"typeVersion": 1
},
{
"id": "171ed51e-6277-46d3-9037-8b2722ca06d0",
"name": "Agregar usuarios",
"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": "Establecer Asistente",
"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": "notificar en canal",
"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": "establecer datos",
"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": "Nota Adhesiva",
"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": "Nota Adhesiva1",
"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
}
]
]
}
}
}Preguntas frecuentes
¿Cómo usar este flujo de trabajo?
Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.
¿En qué escenarios es adecuado este flujo de trabajo?
Intermedio - Inteligencia Artificial, Marketing, Operaciones de TI
¿Es de pago?
Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.
Flujos de trabajo relacionados recomendados
Cargador de CSV a HubSpot (mapeo de campos dinámico e integración con Google Sheets)
Subidor de CSV a HubSpot con mapeo de campos dinámico e integración con Google Sheets
If
Set
Code
+
If
Set
Code
36 NodosPollupAI
Inteligencia Artificial
OCR Telegram - SAP
Procesamiento automatizado de facturas basado en Telegram, GPT-4o, OCR e integración con SAP
Set
Code
Wait
+
Set
Code
Wait
29 NodosRaquel Giugliano
Inteligencia Artificial
Generar automáticamente investigaciones sobre participantes en reuniones con GPT-4o, Google Calendar y Gmail
Usar GPT-4o, Google Calendar y Gmail para generar automáticamente estudios de participantes en reuniones
If
Set
Gmail
+
If
Set
Gmail
18 NodosAdam Janes
Inteligencia Artificial
Construir y vender automatización de IA y agentes
构建与ventasAIautomatización与inteligente体
If
Set
Wait
+
If
Set
Wait
74 NodosNICKYAI
Otros
Agente de IA para noticias a resumen automatizado v13
Equipo de investigación de noticias IA: automatización de informes 24/7 con citas de Perplexity
Set
Code
Gmail
+
Set
Code
Gmail
37 NodosDerek Cheung
Producto
Constructor de boletines de noticias de IA: Use Dumpling AI para hacer scraping de sitios web, resumen con GPT-4o
Constructor de boletines de noticias IA: Dumpling AI rastrea sitios web, GPT-4o resume
Set
Code
Gmail
+
Set
Code
Gmail
10 NodosYang
Inteligencia Artificial
Información del flujo de trabajo
Nivel de dificultad
Intermedio
Número de nodos9
Categoría3
Tipos de nodos7
Descripción de la dificultad
Autor
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.
Enlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo