Enumerar actividades de redes sociales de una empresa antes de una llamada
Este es unSalesflujo de automatización del dominio deautomatización que contiene 19 nodos.Utiliza principalmente nodos como Set, Code, Html, Gmail, Merge. Enumerar actividades de redes sociales de la empresa antes de una llamada
- •Cuenta de Google y credenciales de API de Gmail
- •Pueden requerirse credenciales de autenticación para la API de destino
Nodos utilizados (19)
Categoría
{
"meta": {
"instanceId": "3c58c896c9089c8fb4d7f2b069bf3119193f239a1f538829758e2f4d6b5f5b24"
},
"nodes": [
{
"id": "f59411f9-5dad-4f8c-af0c-c3ab25171107",
"name": "Obtener tweets recientes",
"type": "n8n-nodes-base.httpRequest",
"position": [
233.55908776779552,
1409.619212163096
],
"parameters": {
"url": "https://twitter154.p.rapidapi.com/user/tweets",
"options": {
"batching": {
"batch": {
"batchSize": 1,
"batchInterval": 2000
}
}
},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "limit",
"value": "10"
},
{
"name": "user_id",
"value": "={{ $json.twitter.id }}"
},
{
"name": "include_replies",
"value": "={{ false }}"
},
{
"name": "include_pinned",
"value": "={{ false }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "X-RapidAPI-Host",
"value": "twitter154.p.rapidapi.com"
},
{
"name": "X-RapidAPI-Key",
"value": "={{ $('Setup').first().json.twitterAPIKey }}"
}
]
}
},
"typeVersion": 4.1
},
{
"id": "c25d29ef-71bb-4ea1-8794-47911dac997f",
"name": "Configuración",
"type": "n8n-nodes-base.set",
"position": [
-440,
980
],
"parameters": {
"fields": {
"values": [
{
"name": "linkedInAPIKey"
},
{
"name": "twitterAPIKey"
},
{
"name": "emails"
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "5bf52838-157b-49fe-a4d8-3817198502dd",
"name": "Cada mañana a las 7",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-680,
980
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 7
}
]
}
},
"typeVersion": 1.1
},
{
"id": "aff4dd6e-a480-4f43-9b48-05172d4b7b2d",
"name": "Obtener reuniones de hoy",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-80,
980
],
"parameters": {
"options": {
"timeMax": "={{ $now.endOf('day') }}",
"timeMin": "={{ $now.beginningOf('day') }}",
"singleEvents": true
},
"calendar": {
"__rl": true,
"mode": "list",
"value": "milorad.filipovic19@gmail.com",
"cachedResultName": "milorad.filipovic19@gmail.com"
},
"operation": "getAll"
},
"typeVersion": 1
},
{
"id": "63973273-3821-4c9f-8976-6dd47ac9a62e",
"name": "Obtener dominios de correo de asistentes",
"type": "n8n-nodes-base.set",
"position": [
120,
980
],
"parameters": {
"fields": {
"values": [
{
"name": "domain",
"type": "arrayValue",
"arrayValue": "={{ $json.attendees.filter(a => !a.organizer).map(a => a.email.split('@').pop()) }}"
},
{
"name": "attendeeEmails",
"type": "arrayValue",
"arrayValue": "={{ $json.attendees.filter(a => !a.organizer).map(a => a.email) }}"
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "093b978f-8d5e-4051-be21-e8a7a3430c9c",
"name": "Separar",
"type": "n8n-nodes-base.splitOut",
"position": [
300,
980
],
"parameters": {
"include": "selectedOtherFields",
"options": {},
"fieldToSplitOut": "domain",
"fieldsToInclude": "attendeeEmails, start"
},
"typeVersion": 1
},
{
"id": "467308c9-c6a0-4d1c-a6e1-4598075e62a6",
"name": "Obtener publicaciones recientes de LinkedIn",
"type": "n8n-nodes-base.httpRequest",
"position": [
233.55908776779552,
1209.619212163096
],
"parameters": {
"url": "https://fresh-linkedin-profile-data.p.rapidapi.com/get-company-posts",
"options": {
"batching": {
"batch": {}
}
},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "linkedin_url",
"value": "=https://www.linkedin.com/{{ $json.linkedin.handle }}"
},
{
"name": "sort_by",
"value": "recent"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "X-RapidAPI-Key",
"value": "={{ $('Setup').item.json.linkedInAPIKey }}"
},
{
"name": "X-RapidAPI-Host",
"value": "fresh-linkedin-profile-data.p.rapidapi.com"
}
]
}
},
"typeVersion": 4.1
},
{
"id": "71a9223b-4d71-4d0d-a4df-f8836d3c3d1f",
"name": "Enriquecer empresa del asistente",
"type": "n8n-nodes-base.clearbit",
"position": [
640,
980
],
"parameters": {
"domain": "={{ $json.domain }}",
"additionalFields": {}
},
"typeVersion": 1
},
{
"id": "0fad8349-2a4f-4cee-a03e-98e8d95b015c",
"name": "Gmail",
"type": "n8n-nodes-base.gmail",
"position": [
1313.5590877677955,
1309.619212163096
],
"parameters": {
"sendTo": "={{ $('Setup').first().json.emails }}",
"message": "={{ $json.html }}",
"options": {},
"subject": "=Latest social activity for: {{ $('Extract data for email').item.json.name }} "
},
"credentials": {
"gmailOAuth2": {
"id": "10",
"name": "mrdosija@gmail.com"
}
},
"typeVersion": 2.1
},
{
"id": "bf667011-717e-4a5a-ac7d-c377edb063f8",
"name": "Formatear publicaciones de LinkedIn",
"type": "n8n-nodes-base.code",
"position": [
453.5590877677955,
1209.619212163096
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "// console.log('LINKEDIN', $('Enrich attendee company').item.json.name.toLowerCase())\nconst company = $('Enrich attendee company').item.json.name.toLowerCase();\n\nlet html = `\n<div style=\"display: flex; align-items: center; margin: 2em 0 1em\">\n <img src=\"https://store-images.s-microsoft.com/image/apps.31120.9007199266245564.44dc7699-748d-4c34-ba5e-d04eb48f7960.bc4172bd-63f0-455a-9acd-5457f44e4473\" style=\"width: 20px; height: 20px; margin-right: 10px\" />\n <h3 style=\"margin: 0\">LinkedIn posts</h3>\n</div>\n<table style=\"width: 100%\">\n`;\nfor(article of $input.item.json.data.slice(0,10)) {\n html += `\n <tr>\n <td style=\"background-color: #f7f9fc; font-family: sans-serif; padding: 0.3em 1em\">\n <div>\n <a style=\"display: block; color: #000; text-decoration: none; margin-bottom: 5px; font-size: 1.1em\" href=\"${article.url}\"><i>${article.text}</i></a>\n </div>\n <p style=\"margin: 0; font-size: 0.8em\">\n <span title=\"Likes\">❤️ ${article.num_likes}</span> | <span title=\"Comments\">💬 ${article.num_comments}</span>\n </p>\n </td>\n </tr>\n `\n}\nhtml += '</table>';\n\nreturn { \n \"html_linkedin\": html,\n name: $('Switch').item.json.name,\n meeting: $('Split Out').item.json\n};"
},
"typeVersion": 2
},
{
"id": "ee7ad92e-d4ed-4046-8d31-9c5ce4dda92b",
"name": "Formatear tweets",
"type": "n8n-nodes-base.code",
"position": [
453.5590877677955,
1409.619212163096
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "const company = $('Enrich attendee company').item.json.name.toLowerCase();\nlet html = `\n<div style=\"display: flex; align-items: center; margin: 2em 0 1em\">\n <img src=\"https://img.freepik.com/free-vector/new-2023-twitter-logo-x-icon-design_1017-45418.jpg?size=338&ext=jpg&ga=GA1.1.2008272138.1708473600&semt=ais\" style=\"width: 20px; height: 20px; margin-right: 10px\" />\n <h3 style=\"margin: 0\">Tweets</h3>\n</div>\n<table style=\"width: 100%\">`;\nfor(article of $input.item.json.results) {\n html += `\n <tr>\n <td style=\"background-color: #f7f9fc; font-family: sans-serif; padding: 0.3em 1em\">\n <div>\n <a style=\"display: block; color: #000; text-decoration: none; margin-bottom: 5px; font-size: 1.1em\" href=\"https://twitter.com/${article.user.username}/status/${article.tweet_id}\">\n <i>${article.text}</i></a>\n </div>\n <p style=\"margin: 0; font-size: 0.8em\">\n <span title=\"Retweets\">🔄 ${article.retweet_count}</span> | <span title=\"Favorites\">❤️ ${article.favorite_count}</span> | <span title=\"Replies\">💬 ${article.reply_count}</span>\n </p>\n </td>\n </tr>\n `\n}\nhtml += '</table>';\n\nreturn { \n \"html_twitter\": html,\n name: $('Switch').item.json.name,\n meeting: $('Split Out').item.json\n};"
},
"typeVersion": 2
},
{
"id": "0523a00c-e6d3-4158-a861-3bbdd1d6af24",
"name": "Combinar toda la actividad por empresa",
"type": "n8n-nodes-base.merge",
"position": [
693.5590877677955,
1309.619212163096
],
"parameters": {
"mode": "combine",
"options": {
"clashHandling": {
"values": {
"resolveClash": "preferInput2"
}
}
},
"joinMode": "keepEverything",
"mergeByFields": {
"values": [
{
"field1": "name",
"field2": "name"
}
]
}
},
"typeVersion": 2.1
},
{
"id": "f7f8a5fd-e768-4011-bdbb-cf41a617ce00",
"name": "Extraer datos para correo",
"type": "n8n-nodes-base.set",
"position": [
873.5590877677955,
1309.619212163096
],
"parameters": {
"fields": {
"values": [
{
"name": "attendeeEmail",
"stringValue": "={{ $json.meeting.attendeeEmails.find(a => a.endsWith($json.meeting.domain)) }}"
},
{
"name": "startHour",
"type": "numberValue",
"numberValue": "={{ DateTime.fromISO($json.meeting.start.dateTime).hour }}"
},
{
"name": "startMinute",
"type": "numberValue",
"numberValue": "={{ DateTime.fromISO($json.meeting.start.dateTime).minute }}"
}
]
},
"include": "selected",
"options": {},
"includeFields": "name, html_twitter, html_linkedin"
},
"typeVersion": 3.2
},
{
"id": "679fb981-1774-4a3e-8aa4-0cef2f416ecb",
"name": "Preparar plantilla de correo",
"type": "n8n-nodes-base.html",
"position": [
1093.5590877677955,
1309.619212163096
],
"parameters": {
"html": "<!DOCTYPE html>\n\n<html>\n<head>\n <meta charset=\"UTF-8\" />\n <title>Social media activity for company: {{ $json.name }}</title>\n</head>\n<body>\n <div class=\"container\">\n <h2 style=\"font-size: 1.2em\">\n 🗓️ Meeting with \n <span>{{ $json.attendeeEmail }}</span> \n at {{ $json.startHour }}:{{ $json.startMinute < 10 ? `0${$json.startMinute}` : $json.startMinute }}h\n </h2>\n {{ $json.html_linkedin ?? ''}}\n {{ $json.html_twitter ?? ''}}\n </div>\n</body>\n</html>\n\n<style>\n.container {\n font-family: sans-serif;\n}\n</style>"
},
"typeVersion": 1.1
},
{
"id": "8d08145c-9376-4933-8cb2-05babc855b7a",
"name": "Switch",
"type": "n8n-nodes-base.switch",
"position": [
-6.440912232204482,
1309.619212163096
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "linkedin",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.linkedin.handle !== null }}",
"rightValue": ""
}
]
},
"renameOutput": true
},
{
"outputKey": "twitter",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "bbb0310e-8b20-4bc6-a540-a4cd17470e28",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.twitter.id !== null }}",
"rightValue": ""
}
]
},
"renameOutput": true
}
]
},
"options": {
"allMatchingOutputs": true,
"looseTypeValidation": false
}
},
"typeVersion": 3
},
{
"id": "e4332ab1-5618-477c-9c0b-a2a01278036f",
"name": "Nota adhesiva",
"type": "n8n-nodes-base.stickyNote",
"position": [
-520,
720
],
"parameters": {
"color": 7,
"width": 409.31582584657923,
"height": 426.61520915049425,
"content": "## Start here\n1️⃣ Register on [RapidAPI](https://rapidapi.com) and subscribe to these two APIs:\n- [Fresh LinkedIn Profile Data](https://rapidapi.com/freshdata-freshdata-default/api/fresh-linkedin-profile-data)\n- [Twitter](https://rapidapi.com/omarmhaimdat/api/twitter154)\n\n\n2️⃣ Set API keys for these two in `linkedInAPIKey` and `twitterAPIKey`fields of this node\n\n3️⃣ Set email addresses that should receive the list in the `emails` field of this node"
},
"typeVersion": 1
},
{
"id": "2b7a7085-8e19-40a2-9910-6ad829433706",
"name": "Nota adhesiva1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-220.44091223220448,
1289.619212163096
],
"parameters": {
"color": 7,
"width": 334.90628250854803,
"height": 308.7389742148118,
"content": "\n\n\n\n\n\n\n\n\n\n\n\n\n\n💡 If you need to get activities from more social media accounts found by ClearBit, they can be added here, just make sure to process them properly in separate switch node branches"
},
"typeVersion": 1
},
{
"id": "8f616351-c18d-460c-9d58-abe01c04e90b",
"name": "Nota adhesiva2",
"type": "n8n-nodes-base.stickyNote",
"position": [
840,
560
],
"parameters": {
"color": 5,
"width": 738.9631933644362,
"height": 717.2835666148258,
"content": "### You will receive one email for every company in your calendar. These emails will look something like this:\n\n"
},
"typeVersion": 1
},
{
"id": "dbd6c7df-d857-40e2-b1ba-cb1e68f9cb1a",
"name": "Mantener solo aquellos con el dominio",
"type": "n8n-nodes-base.filter",
"position": [
460,
980
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "881d891e-ea17-4879-a5cf-72d08b281f56",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.domain }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2
}
],
"pinData": {},
"connections": {
"c25d29ef-71bb-4ea1-8794-47911dac997f": {
"main": [
[
{
"node": "aff4dd6e-a480-4f43-9b48-05172d4b7b2d",
"type": "main",
"index": 0
}
]
]
},
"8d08145c-9376-4933-8cb2-05babc855b7a": {
"main": [
[
{
"node": "467308c9-c6a0-4d1c-a6e1-4598075e62a6",
"type": "main",
"index": 0
}
],
[
{
"node": "f59411f9-5dad-4f8c-af0c-c3ab25171107",
"type": "main",
"index": 0
}
]
]
},
"093b978f-8d5e-4051-be21-e8a7a3430c9c": {
"main": [
[
{
"node": "dbd6c7df-d857-40e2-b1ba-cb1e68f9cb1a",
"type": "main",
"index": 0
}
]
]
},
"ee7ad92e-d4ed-4046-8d31-9c5ce4dda92b": {
"main": [
[
{
"node": "0523a00c-e6d3-4158-a861-3bbdd1d6af24",
"type": "main",
"index": 1
}
]
]
},
"5bf52838-157b-49fe-a4d8-3817198502dd": {
"main": [
[
{
"node": "c25d29ef-71bb-4ea1-8794-47911dac997f",
"type": "main",
"index": 0
}
]
]
},
"f59411f9-5dad-4f8c-af0c-c3ab25171107": {
"main": [
[
{
"node": "ee7ad92e-d4ed-4046-8d31-9c5ce4dda92b",
"type": "main",
"index": 0
}
]
]
},
"bf667011-717e-4a5a-ac7d-c377edb063f8": {
"main": [
[
{
"node": "0523a00c-e6d3-4158-a861-3bbdd1d6af24",
"type": "main",
"index": 0
}
]
]
},
"f7f8a5fd-e768-4011-bdbb-cf41a617ce00": {
"main": [
[
{
"node": "679fb981-1774-4a3e-8aa4-0cef2f416ecb",
"type": "main",
"index": 0
}
]
]
},
"aff4dd6e-a480-4f43-9b48-05172d4b7b2d": {
"main": [
[
{
"node": "63973273-3821-4c9f-8976-6dd47ac9a62e",
"type": "main",
"index": 0
}
]
]
},
"679fb981-1774-4a3e-8aa4-0cef2f416ecb": {
"main": [
[
{
"node": "0fad8349-2a4f-4cee-a03e-98e8d95b015c",
"type": "main",
"index": 0
}
]
]
},
"71a9223b-4d71-4d0d-a4df-f8836d3c3d1f": {
"main": [
[
{
"node": "8d08145c-9376-4933-8cb2-05babc855b7a",
"type": "main",
"index": 0
}
]
]
},
"467308c9-c6a0-4d1c-a6e1-4598075e62a6": {
"main": [
[
{
"node": "bf667011-717e-4a5a-ac7d-c377edb063f8",
"type": "main",
"index": 0
}
]
]
},
"63973273-3821-4c9f-8976-6dd47ac9a62e": {
"main": [
[
{
"node": "093b978f-8d5e-4051-be21-e8a7a3430c9c",
"type": "main",
"index": 0
}
]
]
},
"dbd6c7df-d857-40e2-b1ba-cb1e68f9cb1a": {
"main": [
[
{
"node": "71a9223b-4d71-4d0d-a4df-f8836d3c3d1f",
"type": "main",
"index": 0
}
]
]
},
"0523a00c-e6d3-4158-a861-3bbdd1d6af24": {
"main": [
[
{
"node": "f7f8a5fd-e768-4011-bdbb-cf41a617ce00",
"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?
Avanzado - Ventas
¿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
Compartir este flujo de trabajo