Crear una presentación personalizada para cada prospecto
Este es unMarketingflujo de automatización del dominio deautomatización que contiene 14 nodos.Utiliza principalmente nodos como Merge, Switch, GoogleDrive, GoogleSheets, GoogleSlides. Crear presentaciones de diapositivas de Google personalizadas para el arranque en frío a partir de datos CSV
- •Credenciales de API de Google Drive
- •Credenciales de API de Google Sheets
Nodos utilizados (14)
Categoría
{
"id": "eF84e2NyJWTCVClW",
"meta": {
"instanceId": "5ce52989094be90be3b3bdd9ed9cee1d7ce1fcecaa598afaec4a50646d32e291",
"templateCredsSetupCompleted": true
},
"name": "Create Custom Presentations per Lead",
"tags": [
{
"id": "fSDcaaN3w5sV5e3S",
"name": "Templates",
"createdAt": "2025-02-23T15:20:47.262Z",
"updatedAt": "2025-02-23T15:20:47.262Z"
},
{
"id": "iMiiPG3ObM1yILch",
"name": "SD - Sales",
"createdAt": "2025-02-23T15:27:45.789Z",
"updatedAt": "2025-02-23T15:28:28.561Z"
}
],
"nodes": [
{
"id": "4cc04b1c-d97d-4d5a-b614-ba22b7b447bd",
"name": "Descargar por ID",
"type": "n8n-nodes-base.googleDrive",
"position": [
-280,
160
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.id }}"
},
"options": {},
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "J7noNRzf26R3DpFF",
"name": "Jim Privat"
}
},
"typeVersion": 3
},
{
"id": "8d550abf-a5f8-424d-8bfb-d9a9732eb93f",
"name": "Mover a carpeta de lista de leads",
"type": "n8n-nodes-base.googleDrive",
"position": [
1060,
160
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Create new Sheet').first().json.spreadsheetId }}"
},
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"folderId": {
"__rl": true,
"mode": "id",
"value": "=1-oMQTyijYXNmt-Dwh748JFjlDZVCu6ii"
},
"operation": "move"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "J7noNRzf26R3DpFF",
"name": "Jim Privat"
}
},
"typeVersion": 3
},
{
"id": "4872b5ec-6dda-4920-b6e2-120bdc273c00",
"name": "Agregar ID de presentación a lista de leads",
"type": "n8n-nodes-base.googleSheets",
"position": [
1740,
160
],
"parameters": {
"columns": {
"value": {
"Email": "={{ $('Get all Leads').item.json.Email }}",
"PresentationID": "={{ $json.presentationId }}"
},
"schema": [
{
"id": "First Name",
"type": "string",
"display": true,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Full Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Full Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Contact Location",
"type": "string",
"display": true,
"required": false,
"displayName": "Contact Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Employees",
"type": "string",
"display": true,
"required": false,
"displayName": "Employees",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Industry",
"type": "string",
"display": true,
"required": false,
"displayName": "Industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "State",
"type": "string",
"display": true,
"required": false,
"displayName": "State",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "City",
"type": "string",
"display": true,
"required": false,
"displayName": "City",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PresentationID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PresentationID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Keywords",
"type": "string",
"display": true,
"required": false,
"displayName": "Keywords",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
]
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "={{ $('Create new Sheet').first().json.sheets[0].properties.sheetId }}"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Create new Sheet').first().json.spreadsheetId }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "tO62CXNbmAYSCBIY",
"name": "Midgard"
}
},
"typeVersion": 4.5
},
{
"id": "afe225e3-fb82-4091-8310-6645d883c54d",
"name": "Obtener todos los leads",
"type": "n8n-nodes-base.googleSheets",
"position": [
840,
160
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "id",
"value": "={{ $('Create new Sheet').first().json.sheets[0].properties.sheetId }}"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Create new Sheet').first().json.spreadsheetId }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "tO62CXNbmAYSCBIY",
"name": "Midgard"
}
},
"executeOnce": true,
"typeVersion": 4.5
},
{
"id": "635c62cf-4369-442b-8fd7-be2e4caa6ebc",
"name": "Crear nueva hoja",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
40
],
"parameters": {
"title": "=Leads_{{ $now.setZone('Europe/Berlin').toFormat('yyyy-dd-MM') }}",
"options": {},
"resource": "spreadsheet",
"sheetsUi": {
"sheetValues": [
{
"title": "sample_data"
}
]
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "tO62CXNbmAYSCBIY",
"name": "Midgard"
}
},
"typeVersion": 4.5
},
{
"id": "d55c0f32-b74a-484a-b759-9ca1c4cf8d65",
"name": "Combinar datos para nuevo documento de lead",
"type": "n8n-nodes-base.googleSheets",
"position": [
580,
160
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "First Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Full Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Full Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Contact Location",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Contact Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Employees",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Employees",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Industry",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "State",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "State",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "City",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "City",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Keywords",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keywords",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": []
},
"options": {
"useAppend": true
},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "={{ $('Create new Sheet').first().json.sheets[0].properties.sheetId }}"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Create new Sheet').first().json.spreadsheetId }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "tO62CXNbmAYSCBIY",
"name": "Midgard"
}
},
"typeVersion": 4.5
},
{
"id": "9d93741a-93b2-4556-9f2e-2d40617c69ac",
"name": "Nuevos leads recibidos",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
-800,
160
],
"parameters": {
"event": "fileCreated",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"triggerOn": "specificFolder",
"folderToWatch": {
"__rl": true,
"mode": "list",
"value": "1GYT9Z8_BnqqY9dqsMpFWJqjeNVsq_xTY",
"cachedResultUrl": "https://drive.google.com/drive/folders/1GYT9Z8_BnqqY9dqsMpFWJqjeNVsq_xTY",
"cachedResultName": "__cmath"
}
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "J7noNRzf26R3DpFF",
"name": "Jim Privat"
}
},
"typeVersion": 1
},
{
"id": "174ff078-e06a-47c3-93c2-441667e0f8e5",
"name": "¿Tipo de archivo?",
"type": "n8n-nodes-base.switch",
"position": [
-560,
160
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "csv",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.mimeType }}",
"rightValue": "text/csv"
}
]
},
"renameOutput": true
},
{
"outputKey": "xlsx",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "c2f2fb50-a750-4870-aff7-11df142a9be5",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.mimeType }}",
"rightValue": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "23d71fb1-c8f2-4144-a40e-be378aa2043a",
"name": "Combinar documento nuevo vacío con datos de CSV",
"type": "n8n-nodes-base.merge",
"position": [
300,
160
],
"parameters": {
"mode": "chooseBranch",
"useDataOfInput": 2
},
"typeVersion": 3
},
{
"id": "195d7ed6-7dc0-4f49-8256-f47b4c8d426b",
"name": "Crear presentación personalizada",
"type": "n8n-nodes-base.googleSlides",
"position": [
1520,
160
],
"parameters": {
"textUi": {
"textValues": [
{
"text": "{COMPANYNAME}",
"replaceText": "={{ $('Get all Leads').item.json.Company }}"
},
{
"text": "{Testdurchgestrichen}",
"replaceText": "={{ $('Get all Leads').item.json['Full Name'] }}"
},
{
"text": "{nichtdurchgestrichen}",
"replaceText": "={{ $('Get all Leads').item.json['First Name'] }}"
}
]
},
"options": {},
"operation": "replaceText",
"presentationId": "={{ $json.id }}"
},
"credentials": {
"googleSlidesOAuth2Api": {
"id": "e9cejsZpBHAaXKv0",
"name": "GSlides Midgard"
}
},
"typeVersion": 2
},
{
"id": "97d47391-20ea-4db7-bdf6-22eebc22a9dd",
"name": "Nota adhesiva",
"type": "n8n-nodes-base.stickyNote",
"position": [
980,
60
],
"parameters": {
"color": 4,
"width": 960,
"height": 340,
"content": "# Duplicate Template and Create Custom Presentations"
},
"typeVersion": 1
},
{
"id": "acded411-6cdf-489a-bb14-c7c14cdaee23",
"name": "Nota adhesiva1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
-120
],
"parameters": {
"color": 4,
"width": 1300,
"height": 520,
"content": "# Create New Google Sheets and Insert Data from CSV file"
},
"typeVersion": 1
},
{
"id": "9dd9e32a-5c1b-4faf-8054-63b66f5dd24e",
"name": "Extraer información de archivo CSV",
"type": "n8n-nodes-base.extractFromFile",
"position": [
0,
220
],
"parameters": {
"options": {
"encoding": "utf-8",
"delimiter": ",",
"headerRow": true
}
},
"typeVersion": 1
},
{
"id": "0329eabe-dee1-41fd-a7eb-017343523e40",
"name": "Copiar plantilla de presentación",
"type": "n8n-nodes-base.googleDrive",
"position": [
1300,
160
],
"parameters": {
"name": "={{ $('Get all Leads').item.json.Company }} X MYCOMPANYNAME_{{ $now.setZone('Europe/Berlin').toFormat('yyyy-dd-MM') }}",
"fileId": {
"__rl": true,
"mode": "list",
"value": "1FtMBECbZY-9gSW6L6DtioOOJv-V9LXduEjZO0pp-NmA",
"cachedResultUrl": "https://docs.google.com/presentation/d/1FtMBECbZY-9gSW6L6DtioOOJv-V9LXduEjZO0pp-NmA/edit?usp=drivesdk",
"cachedResultName": "Stardawn Updated"
},
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"options": {},
"folderId": {
"__rl": true,
"mode": "list",
"value": "1Yu2s72rgOJlz1-tMuzlaeN8UZezYftRT",
"cachedResultUrl": "https://drive.google.com/drive/folders/1Yu2s72rgOJlz1-tMuzlaeN8UZezYftRT",
"cachedResultName": "Custom Presentations"
},
"operation": "copy",
"sameFolder": false
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "J7noNRzf26R3DpFF",
"name": "Jim Privat"
}
},
"typeVersion": 3
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "bd03e5b5-be73-444f-a1e6-f037db77a01b",
"connections": {
"174ff078-e06a-47c3-93c2-441667e0f8e5": {
"main": [
[
{
"node": "4cc04b1c-d97d-4d5a-b614-ba22b7b447bd",
"type": "main",
"index": 0
}
]
]
},
"afe225e3-fb82-4091-8310-6645d883c54d": {
"main": [
[
{
"node": "8d550abf-a5f8-424d-8bfb-d9a9732eb93f",
"type": "main",
"index": 0
}
]
]
},
"4cc04b1c-d97d-4d5a-b614-ba22b7b447bd": {
"main": [
[
{
"node": "9dd9e32a-5c1b-4faf-8054-63b66f5dd24e",
"type": "main",
"index": 0
},
{
"node": "635c62cf-4369-442b-8fd7-be2e4caa6ebc",
"type": "main",
"index": 0
}
]
]
},
"635c62cf-4369-442b-8fd7-be2e4caa6ebc": {
"main": [
[
{
"node": "23d71fb1-c8f2-4144-a40e-be378aa2043a",
"type": "main",
"index": 0
}
]
]
},
"9d93741a-93b2-4556-9f2e-2d40617c69ac": {
"main": [
[
{
"node": "174ff078-e06a-47c3-93c2-441667e0f8e5",
"type": "main",
"index": 0
}
]
]
},
"8d550abf-a5f8-424d-8bfb-d9a9732eb93f": {
"main": [
[
{
"node": "0329eabe-dee1-41fd-a7eb-017343523e40",
"type": "main",
"index": 0
}
]
]
},
"0329eabe-dee1-41fd-a7eb-017343523e40": {
"main": [
[
{
"node": "195d7ed6-7dc0-4f49-8256-f47b4c8d426b",
"type": "main",
"index": 0
}
]
]
},
"195d7ed6-7dc0-4f49-8256-f47b4c8d426b": {
"main": [
[
{
"node": "4872b5ec-6dda-4920-b6e2-120bdc273c00",
"type": "main",
"index": 0
}
]
]
},
"d55c0f32-b74a-484a-b759-9ca1c4cf8d65": {
"main": [
[
{
"node": "afe225e3-fb82-4091-8310-6645d883c54d",
"type": "main",
"index": 0
}
]
]
},
"9dd9e32a-5c1b-4faf-8054-63b66f5dd24e": {
"main": [
[
{
"node": "23d71fb1-c8f2-4144-a40e-be378aa2043a",
"type": "main",
"index": 1
}
]
]
},
"23d71fb1-c8f2-4144-a40e-be378aa2043a": {
"main": [
[
{
"node": "d55c0f32-b74a-484a-b759-9ca1c4cf8d65",
"type": "main",
"index": 0
}
]
]
}
}
}¿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 - Marketing
¿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
JPres
@stardawnaiCompartir este flujo de trabajo